object(MDB2_BufferedResult_mysql)#8 (9) { ["db"]=> object(MDB2_Driver_mysqlLog)#3 (39) { ["string_quoting"]=> array(4) { ["start"]=> string(1) "'" ["end"]=> string(1) "'" ["escape"]=> string(1) "\" ["escape_pattern"]=> string(1) "\" } ["identifier_quoting"]=> array(3) { ["start"]=> string(1) "`" ["end"]=> string(1) "`" ["escape"]=> string(1) "`" } ["sql_comments"]=> array(3) { [0]=> array(3) { ["start"]=> string(3) "-- " ["end"]=> string(1) " " ["escape"]=> bool(false) } [1]=> array(3) { ["start"]=> string(1) "#" ["end"]=> string(1) " " ["escape"]=> bool(false) } [2]=> array(3) { ["start"]=> string(2) "/*" ["end"]=> string(2) "*/" ["escape"]=> bool(false) } } ["start_transaction"]=> bool(true) ["varchar_max_length"]=> int(65532) ["link":"MDB2_Driver_mysql":private]=> NULL ["db_index"]=> int(1) ["dsn"]=> array(10) { ["phptype"]=> string(8) "mysqlLog" ["dbsyntax"]=> string(8) "mysqlLog" ["username"]=> string(11) "dbo00030127" ["password"]=> string(8) "hB5dR2Fc" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(9) "localhost" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> bool(false) ["mode"]=> bool(false) } ["connected_dsn"]=> array(10) { ["phptype"]=> string(8) "mysqlLog" ["dbsyntax"]=> string(8) "mysqlLog" ["username"]=> string(11) "dbo00030127" ["password"]=> string(8) "hB5dR2Fc" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(9) "localhost" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> bool(false) ["mode"]=> bool(false) } ["connection"]=> object(mysqli)#7 (19) { ["affected_rows"]=> int(0) ["client_info"]=> string(79) "mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $" ["client_version"]=> int(50012) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["field_count"]=> int(4) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(23) "5.7.26-0ubuntu0.16.04.1" ["server_version"]=> int(50726) ["stat"]=> string(147) "Uptime: 264317 Threads: 142 Questions: 7167173 Slow queries: 0 Opens: 789598 Flush tables: 1 Open tables: 416 Queries per second avg: 27.115" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(2954166) ["warning_count"]=> int(1) } ["opened_persistent"]=> bool(false) ["database_name"]=> string(10) "db00030127" ["connected_database_name"]=> string(10) "db00030127" ["connected_server_info"]=> string(23) "5.7.26-0ubuntu0.16.04.1" ["supported"]=> array(19) { ["sequences"]=> string(8) "emulated" ["indexes"]=> bool(true) ["affected_rows"]=> bool(true) ["summary_functions"]=> bool(true) ["order_by_text"]=> bool(true) ["transactions"]=> bool(true) ["savepoints"]=> bool(true) ["current_id"]=> string(8) "emulated" ["limit_queries"]=> bool(true) ["LOBs"]=> bool(true) ["replace"]=> bool(true) ["sub_selects"]=> bool(true) ["auto_increment"]=> bool(true) ["primary_key"]=> bool(true) ["result_introspection"]=> bool(true) ["prepared_statements"]=> bool(true) ["identifier_quoting"]=> bool(true) ["pattern_escaping"]=> bool(true) ["new_link"]=> bool(true) } ["options"]=> array(30) { ["ssl"]=> bool(false) ["field_case"]=> int(0) ["disable_query"]=> bool(false) ["result_class"]=> string(14) "MDB2_Result_%s" ["buffered_result_class"]=> string(22) "MDB2_BufferedResult_%s" ["result_wrap_class"]=> bool(false) ["result_buffering"]=> bool(true) ["fetch_class"]=> string(8) "stdClass" ["persistent"]=> bool(false) ["debug"]=> int(0) ["debug_handler"]=> string(23) "MDB2_defaultDebugOutput" ["debug_expanded_output"]=> bool(false) ["default_text_field_length"]=> int(4096) ["lob_buffer_length"]=> int(8192) ["log_line_break"]=> string(1) " " ["idxname_format"]=> string(6) "%s_idx" ["seqname_format"]=> string(6) "%s_seq" ["savepoint_format"]=> string(17) "MDB2_SAVEPOINT_%s" ["statement_format"]=> string(24) "MDB2_STATEMENT_%1$s_%2$s" ["seqcol_name"]=> string(8) "sequence" ["quote_identifier"]=> bool(false) ["use_transactions"]=> bool(true) ["decimal_places"]=> int(2) ["portability"]=> int(127) ["modules"]=> array(6) { ["ex"]=> string(8) "Extended" ["dt"]=> string(8) "Datatype" ["mg"]=> string(7) "Manager" ["rv"]=> string(7) "Reverse" ["na"]=> string(6) "Native" ["fc"]=> string(8) "Function" } ["emulate_prepared"]=> bool(false) ["datatype_map"]=> array(0) { } ["datatype_map_callback"]=> array(0) { } ["nativetype_map_callback"]=> array(0) { } ["default_table_type"]=> string(0) "" } ["wildcards"]=> array(2) { [0]=> string(1) "%" [1]=> string(1) "_" } ["as_keyword"]=> string(4) " AS " ["warnings"]=> array(0) { } ["debug_output"]=> string(0) "" ["in_transaction"]=> NULL ["nested_transaction_counter"]=> NULL ["has_transaction_error"]=> bool(false) ["offset"]=> int(0) ["limit"]=> int(0) ["phptype"]=> string(6) "mysqli" ["dbsyntax"]=> string(8) "mysqlLog" ["last_query"]=> string(408) "SELECT SQL_CACHE m.model_key, m.make_key, m.raw, COUNT(p.piqid) AS num_piqs FROM exif_model AS m, piqs AS p WHERE p.active = 2 AND m.make_key IN ('100m_3x_digital_camera') AND m.model_key = p.model COLLATE utf8_general_ci GROUP BY p.model HAVING COUNT(p.piqid) > 0 ORDER BY p.model ASC" ["fetchmode"]=> int(2) ["modules"]=> array(1) { ["Datatype"]=> &object(MDB2_Driver_Datatype_mysql)#6 (3) { ["valid_default_values"]=> array(10) { ["text"]=> string(0) "" ["boolean"]=> bool(true) ["integer"]=> int(0) ["decimal"]=> float(0) ["float"]=> float(0) ["timestamp"]=> string(19) "1970-01-01 00:00:00" ["time"]=> string(8) "00:00:00" ["date"]=> string(10) "1970-01-01" ["clob"]=> string(0) "" ["blob"]=> string(0) "" } ["lobs"]=> array(0) { } ["db_index"]=> int(1) } } ["destructor_registered"]=> bool(true) ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(10) "PEAR_Error" ["_expected_errors"]=> array(0) { } ["datatype"]=> &object(MDB2_Driver_Datatype_mysql)#6 (3) { ["valid_default_values"]=> array(10) { ["text"]=> string(0) "" ["boolean"]=> bool(true) ["integer"]=> int(0) ["decimal"]=> float(0) ["float"]=> float(0) ["timestamp"]=> string(19) "1970-01-01 00:00:00" ["time"]=> string(8) "00:00:00" ["date"]=> string(10) "1970-01-01" ["clob"]=> string(0) "" ["blob"]=> string(0) "" } ["lobs"]=> array(0) { } ["db_index"]=> int(1) } ["loaded_version_modules"]=> array(1) { [0]=> string(8) "datatype" } } ["result"]=> object(mysqli_result)#10 (5) { ["current_field"]=> int(0) ["field_count"]=> int(4) ["lengths"]=> NULL ["num_rows"]=> int(0) ["type"]=> int(0) } ["rownum"]=> int(-1) ["types"]=> array(0) { } ["values"]=> array(0) { } ["offset"]=> int(0) ["offset_count"]=> int(0) ["limit"]=> int(0) ["column_names"]=> NULL } MDB2 Error: syntax error