DBSelectOperation Object ( [debug] => false [sql] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [selectFields] => Array ( [0] => DISTINCT event.id_events [1] => event.* [2] => country.countryName [3] => syndromeName ) [whereFields] => Array ( [0] => Array ( [0] => syndrome.syndromeID [1] => 2 [2] => = ) ) [whereFields2] => [joinFields] => Array ( [0] => Array ( [0] => country.countryID [1] => event.country_countryCode ) ) [leftJoinFields] => Array ( [event] => LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID ) [tables] => Array ( [0] => country [1] => event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID ) [orderBy] => Array ( [0] => event.eventName DESC ) [groupBy] => [result] => DB_Error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024 [code] => -1 [message] => DB Error: unknown error [userinfo] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [nativecode=1030 ** Got error 28 from storage engine] [backtrace] => Array ( [0] => Array ( [file] => /usr/share/php/PEAR.php [line] => 945 [function] => __construct [class] => PEAR_Error [type] => -> [args] => Array ( [0] => DB Error: unknown error [1] => -1 [2] => 1 [3] => 1024 [4] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [nativecode=1030 ** Got error 28 from storage engine] ) ) [1] => Array ( [file] => /usr/share/php/DB.php [line] => 966 [function] => PEAR_Error [class] => PEAR_Error [object] => DB_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => DB Error: unknown error [1] => -1 [2] => 1 [3] => 1024 [4] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [nativecode=1030 ** Got error 28 from storage engine] ) ) [2] => Array ( [file] => /usr/share/php/PEAR.php [line] => 575 [function] => DB_Error [class] => DB_Error [object] => DB_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => -1 [1] => 1 [2] => 1024 [3] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [nativecode=1030 ** Got error 28 from storage engine] ) ) [3] => Array ( [function] => _raiseError [class] => PEAR [object] => DB_mysql Object ( [phptype] => mysql [dbsyntax] => mysql [features] => Array ( [limit] => alter [new_link] => 4.2.0 [numrows] => 1 [pconnect] => 1 [prepare] => [ssl] => [transactions] => 1 ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1044] => -26 [1046] => -14 [1048] => -3 [1049] => -27 [1050] => -5 [1051] => -18 [1054] => -19 [1061] => -5 [1062] => -5 [1064] => -2 [1091] => -4 [1100] => -21 [1136] => -22 [1142] => -26 [1146] => -18 [1216] => -3 [1217] => -3 [1356] => -13 [1451] => -3 [1452] => -3 ) [connection] => Resource id #3 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => iode_general [password] => pcpo36!#33 [protocol] => tcp [hostspec] => haedatdb [port] => [socket] => [database] => haedat ) [autocommit] => 1 [transaction_opcount] => 0 [_db] => haedat [fetchmode] => 1 [fetchmode_object_class] => stdClass [was_connected] => [last_query] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [options] => Array ( [result_buffering] => 500 [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [last_parameters] => Array ( ) [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [prepared_queries] => Array ( ) [_last_query_manip] => [_next_query_manip] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) ) [type] => -> [args] => Array ( [0] => DB_mysql Object ( [phptype] => mysql [dbsyntax] => mysql [features] => Array ( [limit] => alter [new_link] => 4.2.0 [numrows] => 1 [pconnect] => 1 [prepare] => [ssl] => [transactions] => 1 ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1044] => -26 [1046] => -14 [1048] => -3 [1049] => -27 [1050] => -5 [1051] => -18 [1054] => -19 [1061] => -5 [1062] => -5 [1064] => -2 [1091] => -4 [1100] => -21 [1136] => -22 [1142] => -26 [1146] => -18 [1216] => -3 [1217] => -3 [1356] => -13 [1451] => -3 [1452] => -3 ) [connection] => Resource id #3 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => iode_general [password] => pcpo36!#33 [protocol] => tcp [hostspec] => haedatdb [port] => [socket] => [database] => haedat ) [autocommit] => 1 [transaction_opcount] => 0 [_db] => haedat [fetchmode] => 1 [fetchmode_object_class] => stdClass [was_connected] => [last_query] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [options] => Array ( [result_buffering] => 500 [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [last_parameters] => Array ( ) [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [prepared_queries] => Array ( ) [_last_query_manip] => [_next_query_manip] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) ) [1] => [2] => -1 [3] => [4] => [5] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [nativecode=1030 ** Got error 28 from storage engine] [6] => DB_Error [7] => 1 ) ) [4] => Array ( [file] => /usr/share/php/PEAR.php [line] => 224 [function] => call_user_func_array [args] => Array ( [0] => Array ( [0] => PEAR [1] => _raiseError ) [1] => Array ( [0] => DB_mysql Object ( [phptype] => mysql [dbsyntax] => mysql [features] => Array ( [limit] => alter [new_link] => 4.2.0 [numrows] => 1 [pconnect] => 1 [prepare] => [ssl] => [transactions] => 1 ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1044] => -26 [1046] => -14 [1048] => -3 [1049] => -27 [1050] => -5 [1051] => -18 [1054] => -19 [1061] => -5 [1062] => -5 [1064] => -2 [1091] => -4 [1100] => -21 [1136] => -22 [1142] => -26 [1146] => -18 [1216] => -3 [1217] => -3 [1356] => -13 [1451] => -3 [1452] => -3 ) [connection] => Resource id #3 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => iode_general [password] => pcpo36!#33 [protocol] => tcp [hostspec] => haedatdb [port] => [socket] => [database] => haedat ) [autocommit] => 1 [transaction_opcount] => 0 [_db] => haedat [fetchmode] => 1 [fetchmode_object_class] => stdClass [was_connected] => [last_query] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [options] => Array ( [result_buffering] => 500 [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [last_parameters] => Array ( ) [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [prepared_queries] => Array ( ) [_last_query_manip] => [_next_query_manip] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) ) [1] => [2] => -1 [3] => [4] => [5] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [nativecode=1030 ** Got error 28 from storage engine] [6] => DB_Error [7] => 1 ) ) ) [5] => Array ( [file] => /usr/share/php/DB/common.php [line] => 1908 [function] => __call [class] => PEAR [object] => DB_mysql Object ( [phptype] => mysql [dbsyntax] => mysql [features] => Array ( [limit] => alter [new_link] => 4.2.0 [numrows] => 1 [pconnect] => 1 [prepare] => [ssl] => [transactions] => 1 ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1044] => -26 [1046] => -14 [1048] => -3 [1049] => -27 [1050] => -5 [1051] => -18 [1054] => -19 [1061] => -5 [1062] => -5 [1064] => -2 [1091] => -4 [1100] => -21 [1136] => -22 [1142] => -26 [1146] => -18 [1216] => -3 [1217] => -3 [1356] => -13 [1451] => -3 [1452] => -3 ) [connection] => Resource id #3 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => iode_general [password] => pcpo36!#33 [protocol] => tcp [hostspec] => haedatdb [port] => [socket] => [database] => haedat ) [autocommit] => 1 [transaction_opcount] => 0 [_db] => haedat [fetchmode] => 1 [fetchmode_object_class] => stdClass [was_connected] => [last_query] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [options] => Array ( [result_buffering] => 500 [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [last_parameters] => Array ( ) [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [prepared_queries] => Array ( ) [_last_query_manip] => [_next_query_manip] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) ) [type] => -> [args] => Array ( [0] => raiseError [1] => Array ( [0] => [1] => -1 [2] => [3] => [4] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [nativecode=1030 ** Got error 28 from storage engine] [5] => DB_Error [6] => 1 ) ) ) [6] => Array ( [file] => /usr/share/php/DB/common.php [line] => 1908 [function] => raiseError [class] => PEAR [object] => DB_mysql Object ( [phptype] => mysql [dbsyntax] => mysql [features] => Array ( [limit] => alter [new_link] => 4.2.0 [numrows] => 1 [pconnect] => 1 [prepare] => [ssl] => [transactions] => 1 ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1044] => -26 [1046] => -14 [1048] => -3 [1049] => -27 [1050] => -5 [1051] => -18 [1054] => -19 [1061] => -5 [1062] => -5 [1064] => -2 [1091] => -4 [1100] => -21 [1136] => -22 [1142] => -26 [1146] => -18 [1216] => -3 [1217] => -3 [1356] => -13 [1451] => -3 [1452] => -3 ) [connection] => Resource id #3 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => iode_general [password] => pcpo36!#33 [protocol] => tcp [hostspec] => haedatdb [port] => [socket] => [database] => haedat ) [autocommit] => 1 [transaction_opcount] => 0 [_db] => haedat [fetchmode] => 1 [fetchmode_object_class] => stdClass [was_connected] => [last_query] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [options] => Array ( [result_buffering] => 500 [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [last_parameters] => Array ( ) [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [prepared_queries] => Array ( ) [_last_query_manip] => [_next_query_manip] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) ) [type] => -> [args] => Array ( [0] => [1] => -1 [2] => [3] => [4] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [nativecode=1030 ** Got error 28 from storage engine] [5] => DB_Error [6] => 1 ) ) [7] => Array ( [file] => /usr/share/php/DB/mysql.php [line] => 898 [function] => raiseError [class] => DB_common [object] => DB_mysql Object ( [phptype] => mysql [dbsyntax] => mysql [features] => Array ( [limit] => alter [new_link] => 4.2.0 [numrows] => 1 [pconnect] => 1 [prepare] => [ssl] => [transactions] => 1 ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1044] => -26 [1046] => -14 [1048] => -3 [1049] => -27 [1050] => -5 [1051] => -18 [1054] => -19 [1061] => -5 [1062] => -5 [1064] => -2 [1091] => -4 [1100] => -21 [1136] => -22 [1142] => -26 [1146] => -18 [1216] => -3 [1217] => -3 [1356] => -13 [1451] => -3 [1452] => -3 ) [connection] => Resource id #3 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => iode_general [password] => pcpo36!#33 [protocol] => tcp [hostspec] => haedatdb [port] => [socket] => [database] => haedat ) [autocommit] => 1 [transaction_opcount] => 0 [_db] => haedat [fetchmode] => 1 [fetchmode_object_class] => stdClass [was_connected] => [last_query] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [options] => Array ( [result_buffering] => 500 [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [last_parameters] => Array ( ) [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [prepared_queries] => Array ( ) [_last_query_manip] => [_next_query_manip] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) ) [type] => -> [args] => Array ( [0] => -1 [1] => [2] => [3] => [4] => 1030 ** Got error 28 from storage engine ) ) [8] => Array ( [file] => /usr/share/php/DB/mysql.php [line] => 327 [function] => mysqlRaiseError [class] => DB_mysql [object] => DB_mysql Object ( [phptype] => mysql [dbsyntax] => mysql [features] => Array ( [limit] => alter [new_link] => 4.2.0 [numrows] => 1 [pconnect] => 1 [prepare] => [ssl] => [transactions] => 1 ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1044] => -26 [1046] => -14 [1048] => -3 [1049] => -27 [1050] => -5 [1051] => -18 [1054] => -19 [1061] => -5 [1062] => -5 [1064] => -2 [1091] => -4 [1100] => -21 [1136] => -22 [1142] => -26 [1146] => -18 [1216] => -3 [1217] => -3 [1356] => -13 [1451] => -3 [1452] => -3 ) [connection] => Resource id #3 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => iode_general [password] => pcpo36!#33 [protocol] => tcp [hostspec] => haedatdb [port] => [socket] => [database] => haedat ) [autocommit] => 1 [transaction_opcount] => 0 [_db] => haedat [fetchmode] => 1 [fetchmode_object_class] => stdClass [was_connected] => [last_query] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [options] => Array ( [result_buffering] => 500 [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [last_parameters] => Array ( ) [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [prepared_queries] => Array ( ) [_last_query_manip] => [_next_query_manip] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) ) [type] => -> [args] => Array ( ) ) [9] => Array ( [file] => /usr/share/php/DB/common.php [line] => 1216 [function] => simpleQuery [class] => DB_mysql [object] => DB_mysql Object ( [phptype] => mysql [dbsyntax] => mysql [features] => Array ( [limit] => alter [new_link] => 4.2.0 [numrows] => 1 [pconnect] => 1 [prepare] => [ssl] => [transactions] => 1 ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1044] => -26 [1046] => -14 [1048] => -3 [1049] => -27 [1050] => -5 [1051] => -18 [1054] => -19 [1061] => -5 [1062] => -5 [1064] => -2 [1091] => -4 [1100] => -21 [1136] => -22 [1142] => -26 [1146] => -18 [1216] => -3 [1217] => -3 [1356] => -13 [1451] => -3 [1452] => -3 ) [connection] => Resource id #3 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => iode_general [password] => pcpo36!#33 [protocol] => tcp [hostspec] => haedatdb [port] => [socket] => [database] => haedat ) [autocommit] => 1 [transaction_opcount] => 0 [_db] => haedat [fetchmode] => 1 [fetchmode_object_class] => stdClass [was_connected] => [last_query] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [options] => Array ( [result_buffering] => 500 [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [last_parameters] => Array ( ) [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [prepared_queries] => Array ( ) [_last_query_manip] => [_next_query_manip] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) ) [type] => -> [args] => Array ( [0] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 ) ) [10] => Array ( [file] => /var/www/html/framework/classes/DBSelectOperation.class.php [line] => 485 [function] => query [class] => DB_common [object] => DB_mysql Object ( [phptype] => mysql [dbsyntax] => mysql [features] => Array ( [limit] => alter [new_link] => 4.2.0 [numrows] => 1 [pconnect] => 1 [prepare] => [ssl] => [transactions] => 1 ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1044] => -26 [1046] => -14 [1048] => -3 [1049] => -27 [1050] => -5 [1051] => -18 [1054] => -19 [1061] => -5 [1062] => -5 [1064] => -2 [1091] => -4 [1100] => -21 [1136] => -22 [1142] => -26 [1146] => -18 [1216] => -3 [1217] => -3 [1356] => -13 [1451] => -3 [1452] => -3 ) [connection] => Resource id #3 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => iode_general [password] => pcpo36!#33 [protocol] => tcp [hostspec] => haedatdb [port] => [socket] => [database] => haedat ) [autocommit] => 1 [transaction_opcount] => 0 [_db] => haedat [fetchmode] => 1 [fetchmode_object_class] => stdClass [was_connected] => [last_query] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [options] => Array ( [result_buffering] => 500 [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [last_parameters] => Array ( ) [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [prepared_queries] => Array ( ) [_last_query_manip] => [_next_query_manip] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) ) [type] => -> [args] => Array ( [0] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 ) ) [11] => Array ( [file] => /var/www/html/codeBase/classes/Search.class.php [line] => 91 [function] => go [class] => DBSelectOperation [object] => DBSelectOperation Object *RECURSION* [type] => -> [args] => Array ( ) ) [12] => Array ( [file] => /var/www/html/codeBase/classes/EventSearch.class.php [line] => 511 [function] => execute [class] => Search [object] => EventSearch Object ( [gridSearch] => [limit] => 20 [offset] => 0 [dbSelect] => DBSelectOperation Object *RECURSION* [numRecords] => 3928 [displayResults] => [result] => [pageNav] => [searchFields] => Array ( [syndromeID] => 2 ) [searchTitle] => CFP (Ciguatera Fish Poisoning) + [numRows] => 3928 ) [type] => -> [args] => Array ( ) ) [13] => Array ( [file] => /var/www/html/eventSearch.php [line] => 149 [function] => execute [class] => EventSearch [object] => EventSearch Object ( [gridSearch] => [limit] => 20 [offset] => 0 [dbSelect] => DBSelectOperation Object *RECURSION* [numRecords] => 3928 [displayResults] => [result] => [pageNav] => [searchFields] => Array ( [syndromeID] => 2 ) [searchTitle] => CFP (Ciguatera Fish Poisoning) + [numRows] => 3928 ) [type] => -> [args] => Array ( ) ) ) [callback] => ) [totalPossibleRows] => [numRows] => [limit] => 20 [offset] => 0 [db] => DB_mysql Object ( [phptype] => mysql [dbsyntax] => mysql [features] => Array ( [limit] => alter [new_link] => 4.2.0 [numrows] => 1 [pconnect] => 1 [prepare] => [ssl] => [transactions] => 1 ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1044] => -26 [1046] => -14 [1048] => -3 [1049] => -27 [1050] => -5 [1051] => -18 [1054] => -19 [1061] => -5 [1062] => -5 [1064] => -2 [1091] => -4 [1100] => -21 [1136] => -22 [1142] => -26 [1146] => -18 [1216] => -3 [1217] => -3 [1356] => -13 [1451] => -3 [1452] => -3 ) [connection] => Resource id #3 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => iode_general [password] => pcpo36!#33 [protocol] => tcp [hostspec] => haedatdb [port] => [socket] => [database] => haedat ) [autocommit] => 1 [transaction_opcount] => 0 [_db] => haedat [fetchmode] => 1 [fetchmode_object_class] => stdClass [was_connected] => [last_query] => SELECT DISTINCT event.id_events, event.*, country.countryName, syndromeName FROM country, event LEFT JOIN event_has_syndrome ON event.id_events = event_has_syndrome.event_id_events LEFT JOIN syndrome ON event_has_syndrome.syndrome_syndromeID = syndrome.syndromeID WHERE syndrome.syndromeID = "2" and country.countryID = event.country_countryCode ORDER BY event.eventName DESC LIMIT 0, 20 [options] => Array ( [result_buffering] => 500 [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [last_parameters] => Array ( ) [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [prepared_queries] => Array ( ) [_last_query_manip] => [_next_query_manip] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) ) [whereType] => AND [countField] => DISTINCT event.id_events [joinFieldsJoined] => Array ( [0] => country.countryID = event.country_countryCode ) [whereFieldsJoined] => Array ( [0] => syndrome.syndromeID = "2" ) )