Array
(
[0] => Array
(
[file] => /home/mission/public_html/includes/adodblite/adodbSQL_drivers/mysql/mysql_driver.inc
[line] => 341
[function] => ADODB_Error_Handler
[args] => Array
(
[0] => mysql
[1] => EXECUTE
[2] => 1064
[3] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[4] => SELECT * FROM pmd_images WHERE firmselector=NULL ORDER BY ordering LIMIT
[5] => Array
(
[0] => Array
(
[0] =>
)
)
[6] => pear_ADOConnection Object
(
[metaTablesSQL] => SHOW TABLES
[metaColumnsSQL] => SHOW COLUMNS FROM %s
[upperCase] => upper
[substr] => substring
[tablesSQL] => show table status
[createTableSQL] => CREATE TABLE adodb_logsql (
created datetime NOT NULL,
sql0 varchar(250) NOT NULL,
sql1 text NOT NULL,
params text NOT NULL,
tracer text NOT NULL,
timer decimal(16,6) NOT NULL
)
[settings] => Array
(
[0] => Ratios
[MyISAM cache hit ratio] => Array
(
[0] => RATIO
[1] => =GetKeyHitRatio
[2] => =WarnCacheRatio
)
[InnoDB cache hit ratio] => Array
(
[0] => RATIO
[1] => =GetInnoDBHitRatio
[2] => =WarnCacheRatio
)
[data cache hit ratio] => Array
(
[0] => HIDE
[1] => =FindDBHitRatio
[2] => =WarnCacheRatio
)
[sql cache hit ratio] => Array
(
[0] => RATIO
[1] => =GetQHitRatio
[2] =>
)
[1] => IO
[data reads] => Array
(
[0] => IO
[1] => =GetReads
[2] => Number of selects (Key_reads is not accurate)
)
[data writes] => Array
(
[0] => IO
[1] => =GetWrites
[2] => Number of inserts/updates/deletes * coef (Key_writes is not accurate)
)
[2] => Data Cache
[MyISAM data cache size] => Array
(
[0] => DATAC
[1] => Array
(
[0] => show variables
[1] => key_buffer_size
)
[2] =>
)
[BDB data cache size] => Array
(
[0] => DATAC
[1] => Array
(
[0] => show variables
[1] => bdb_cache_size
)
[2] =>
)
[InnoDB data cache size] => Array
(
[0] => DATAC
[1] => Array
(
[0] => show variables
[1] => innodb_buffer_pool_size
)
[2] =>
)
[3] => Memory Usage
[read buffer size] => Array
(
[0] => CACHE
[1] => Array
(
[0] => show variables
[1] => read_buffer_size
)
[2] => (per session)
)
[sort buffer size] => Array
(
[0] => CACHE
[1] => Array
(
[0] => show variables
[1] => sort_buffer_size
)
[2] => Size of sort buffer (per session)
)
[table cache] => Array
(
[0] => CACHE
[1] => Array
(
[0] => show variables
[1] => table_cache
)
[2] => Number of tables to keep open
)
[4] => Connections
[current connections] => Array
(
[0] => SESS
[1] => Array
(
[0] => show status
[1] => Threads_connected
)
[2] =>
)
[max connections] => Array
(
[0] => SESS
[1] => Array
(
[0] => show variables
[1] => max_connections
)
[2] =>
)
[5] =>
)
[optimizeTableLow] => CHECK TABLE %s FAST QUICK
[optimizeTableHigh] => OPTIMIZE TABLE %s
[color] => #F0F0F0
[table] =>
[titles] => | Parameter | Value | Description |
[warnRatio] => 90
[cliFormat] => %32s => %s
[sql1] => sql1
[explain] => 1
[helpurl] => LogSQL help
[maxLength] => 2000
[_logsql] =>
[_lastload] =>
[genID] => 0
[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);
[_genSeqSQL] => create table %s (id int not null)
[_genSeq2SQL] => insert into %s values (%s)
[_dropSeqSQL] => drop table %s
[nameQuote] => `
[sysDate] => CURDATE()
[sysTimeStamp] => NOW()
[connectionId] => Resource id #17
[record_set] =>
[database] => mission_new
[dbtype] => mysql
[dataProvider] => mysql
[host] => localhost
[open] =>
[password] => m3dus8
[username] => mission_terry
[persistent] =>
[debug] =>
[debug_console] =>
[debug_echo] => 1
[debug_output] =>
[forcenewconnection] =>
[createdatabase] =>
[last_module_name] => pear
[socket] =>
[port] =>
[clientFlags] => 0
[sql] => SELECT * FROM pmd_images WHERE firmselector=NULL ORDER BY ordering LIMIT
[raiseErrorFn] => ADODB_Error_Handler
[query_count] => 6
[query_time_total] => 0.00304961204529
[query_list] => Array
(
)
[query_list_time] => Array
(
)
[query_list_errors] => Array
(
)
)
)
)
[1] => Array
(
[file] => /home/mission/public_html/includes/adodblite/adodb.inc.php
[line] => 316
[function] => do_query
[class] => mysql_driver_ADOConnection
[object] => pear_ADOConnection Object
(
[metaTablesSQL] => SHOW TABLES
[metaColumnsSQL] => SHOW COLUMNS FROM %s
[upperCase] => upper
[substr] => substring
[tablesSQL] => show table status
[createTableSQL] => CREATE TABLE adodb_logsql (
created datetime NOT NULL,
sql0 varchar(250) NOT NULL,
sql1 text NOT NULL,
params text NOT NULL,
tracer text NOT NULL,
timer decimal(16,6) NOT NULL
)
[settings] => Array
(
[0] => Ratios
[MyISAM cache hit ratio] => Array
(
[0] => RATIO
[1] => =GetKeyHitRatio
[2] => =WarnCacheRatio
)
[InnoDB cache hit ratio] => Array
(
[0] => RATIO
[1] => =GetInnoDBHitRatio
[2] => =WarnCacheRatio
)
[data cache hit ratio] => Array
(
[0] => HIDE
[1] => =FindDBHitRatio
[2] => =WarnCacheRatio
)
[sql cache hit ratio] => Array
(
[0] => RATIO
[1] => =GetQHitRatio
[2] =>
)
[1] => IO
[data reads] => Array
(
[0] => IO
[1] => =GetReads
[2] => Number of selects (Key_reads is not accurate)
)
[data writes] => Array
(
[0] => IO
[1] => =GetWrites
[2] => Number of inserts/updates/deletes * coef (Key_writes is not accurate)
)
[2] => Data Cache
[MyISAM data cache size] => Array
(
[0] => DATAC
[1] => Array
(
[0] => show variables
[1] => key_buffer_size
)
[2] =>
)
[BDB data cache size] => Array
(
[0] => DATAC
[1] => Array
(
[0] => show variables
[1] => bdb_cache_size
)
[2] =>
)
[InnoDB data cache size] => Array
(
[0] => DATAC
[1] => Array
(
[0] => show variables
[1] => innodb_buffer_pool_size
)
[2] =>
)
[3] => Memory Usage
[read buffer size] => Array
(
[0] => CACHE
[1] => Array
(
[0] => show variables
[1] => read_buffer_size
)
[2] => (per session)
)
[sort buffer size] => Array
(
[0] => CACHE
[1] => Array
(
[0] => show variables
[1] => sort_buffer_size
)
[2] => Size of sort buffer (per session)
)
[table cache] => Array
(
[0] => CACHE
[1] => Array
(
[0] => show variables
[1] => table_cache
)
[2] => Number of tables to keep open
)
[4] => Connections
[current connections] => Array
(
[0] => SESS
[1] => Array
(
[0] => show status
[1] => Threads_connected
)
[2] =>
)
[max connections] => Array
(
[0] => SESS
[1] => Array
(
[0] => show variables
[1] => max_connections
)
[2] =>
)
[5] =>
)
[optimizeTableLow] => CHECK TABLE %s FAST QUICK
[optimizeTableHigh] => OPTIMIZE TABLE %s
[color] => #F0F0F0
[table] =>
[titles] => | Parameter | Value | Description |
[warnRatio] => 90
[cliFormat] => %32s => %s
[sql1] => sql1
[explain] => 1
[helpurl] => LogSQL help
[maxLength] => 2000
[_logsql] =>
[_lastload] =>
[genID] => 0
[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);
[_genSeqSQL] => create table %s (id int not null)
[_genSeq2SQL] => insert into %s values (%s)
[_dropSeqSQL] => drop table %s
[nameQuote] => `
[sysDate] => CURDATE()
[sysTimeStamp] => NOW()
[connectionId] => Resource id #17
[record_set] =>
[database] => mission_new
[dbtype] => mysql
[dataProvider] => mysql
[host] => localhost
[open] =>
[password] => m3dus8
[username] => mission_terry
[persistent] =>
[debug] =>
[debug_console] =>
[debug_echo] => 1
[debug_output] =>
[forcenewconnection] =>
[createdatabase] =>
[last_module_name] => pear
[socket] =>
[port] =>
[clientFlags] => 0
[sql] => SELECT * FROM pmd_images WHERE firmselector=NULL ORDER BY ordering LIMIT
[raiseErrorFn] => ADODB_Error_Handler
[query_count] => 6
[query_time_total] => 0.00304961204529
[query_list] => Array
(
)
[query_list_time] => Array
(
)
[query_list_errors] => Array
(
)
)
[type] => ->
[args] => Array
(
[0] => SELECT * FROM pmd_images WHERE firmselector=? ORDER BY ordering LIMIT
[1] => -1
[2] => -1
[3] => Array
(
[0] =>
)
)
)
[2] => Array
(
[file] => /home/mission/public_html/includes/adodblite/adodbSQL_drivers/mysql/mysql_driver.inc
[line] => 267
[function] => Execute
[class] => ADOConnection
[object] => pear_ADOConnection Object
(
[metaTablesSQL] => SHOW TABLES
[metaColumnsSQL] => SHOW COLUMNS FROM %s
[upperCase] => upper
[substr] => substring
[tablesSQL] => show table status
[createTableSQL] => CREATE TABLE adodb_logsql (
created datetime NOT NULL,
sql0 varchar(250) NOT NULL,
sql1 text NOT NULL,
params text NOT NULL,
tracer text NOT NULL,
timer decimal(16,6) NOT NULL
)
[settings] => Array
(
[0] => Ratios
[MyISAM cache hit ratio] => Array
(
[0] => RATIO
[1] => =GetKeyHitRatio
[2] => =WarnCacheRatio
)
[InnoDB cache hit ratio] => Array
(
[0] => RATIO
[1] => =GetInnoDBHitRatio
[2] => =WarnCacheRatio
)
[data cache hit ratio] => Array
(
[0] => HIDE
[1] => =FindDBHitRatio
[2] => =WarnCacheRatio
)
[sql cache hit ratio] => Array
(
[0] => RATIO
[1] => =GetQHitRatio
[2] =>
)
[1] => IO
[data reads] => Array
(
[0] => IO
[1] => =GetReads
[2] => Number of selects (Key_reads is not accurate)
)
[data writes] => Array
(
[0] => IO
[1] => =GetWrites
[2] => Number of inserts/updates/deletes * coef (Key_writes is not accurate)
)
[2] => Data Cache
[MyISAM data cache size] => Array
(
[0] => DATAC
[1] => Array
(
[0] => show variables
[1] => key_buffer_size
)
[2] =>
)
[BDB data cache size] => Array
(
[0] => DATAC
[1] => Array
(
[0] => show variables
[1] => bdb_cache_size
)
[2] =>
)
[InnoDB data cache size] => Array
(
[0] => DATAC
[1] => Array
(
[0] => show variables
[1] => innodb_buffer_pool_size
)
[2] =>
)
[3] => Memory Usage
[read buffer size] => Array
(
[0] => CACHE
[1] => Array
(
[0] => show variables
[1] => read_buffer_size
)
[2] => (per session)
)
[sort buffer size] => Array
(
[0] => CACHE
[1] => Array
(
[0] => show variables
[1] => sort_buffer_size
)
[2] => Size of sort buffer (per session)
)
[table cache] => Array
(
[0] => CACHE
[1] => Array
(
[0] => show variables
[1] => table_cache
)
[2] => Number of tables to keep open
)
[4] => Connections
[current connections] => Array
(
[0] => SESS
[1] => Array
(
[0] => show status
[1] => Threads_connected
)
[2] =>
)
[max connections] => Array
(
[0] => SESS
[1] => Array
(
[0] => show variables
[1] => max_connections
)
[2] =>
)
[5] =>
)
[optimizeTableLow] => CHECK TABLE %s FAST QUICK
[optimizeTableHigh] => OPTIMIZE TABLE %s
[color] => #F0F0F0
[table] =>
[titles] => | Parameter | Value | Description |
[warnRatio] => 90
[cliFormat] => %32s => %s
[sql1] => sql1
[explain] => 1
[helpurl] => LogSQL help
[maxLength] => 2000
[_logsql] =>
[_lastload] =>
[genID] => 0
[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);
[_genSeqSQL] => create table %s (id int not null)
[_genSeq2SQL] => insert into %s values (%s)
[_dropSeqSQL] => drop table %s
[nameQuote] => `
[sysDate] => CURDATE()
[sysTimeStamp] => NOW()
[connectionId] => Resource id #17
[record_set] =>
[database] => mission_new
[dbtype] => mysql
[dataProvider] => mysql
[host] => localhost
[open] =>
[password] => m3dus8
[username] => mission_terry
[persistent] =>
[debug] =>
[debug_console] =>
[debug_echo] => 1
[debug_output] =>
[forcenewconnection] =>
[createdatabase] =>
[last_module_name] => pear
[socket] =>
[port] =>
[clientFlags] => 0
[sql] => SELECT * FROM pmd_images WHERE firmselector=NULL ORDER BY ordering LIMIT
[raiseErrorFn] => ADODB_Error_Handler
[query_count] => 6
[query_time_total] => 0.00304961204529
[query_list] => Array
(
)
[query_list_time] => Array
(
)
[query_list_errors] => Array
(
)
)
[type] => ->
[args] => Array
(
[0] => SELECT * FROM pmd_images WHERE firmselector=? ORDER BY ordering LIMIT
[1] => Array
(
[0] =>
)
)
)
[3] => Array
(
[file] => /home/mission/public_html/includes/adodblite/adodbSQL_drivers/mysql/mysql_driver.inc
[line] => 253
[function] => GetArray
[class] => mysql_driver_ADOConnection
[object] => pear_ADOConnection Object
(
[metaTablesSQL] => SHOW TABLES
[metaColumnsSQL] => SHOW COLUMNS FROM %s
[upperCase] => upper
[substr] => substring
[tablesSQL] => show table status
[createTableSQL] => CREATE TABLE adodb_logsql (
created datetime NOT NULL,
sql0 varchar(250) NOT NULL,
sql1 text NOT NULL,
params text NOT NULL,
tracer text NOT NULL,
timer decimal(16,6) NOT NULL
)
[settings] => Array
(
[0] => Ratios
[MyISAM cache hit ratio] => Array
(
[0] => RATIO
[1] => =GetKeyHitRatio
[2] => =WarnCacheRatio
)
[InnoDB cache hit ratio] => Array
(
[0] => RATIO
[1] => =GetInnoDBHitRatio
[2] => =WarnCacheRatio
)
[data cache hit ratio] => Array
(
[0] => HIDE
[1] => =FindDBHitRatio
[2] => =WarnCacheRatio
)
[sql cache hit ratio] => Array
(
[0] => RATIO
[1] => =GetQHitRatio
[2] =>
)
[1] => IO
[data reads] => Array
(
[0] => IO
[1] => =GetReads
[2] => Number of selects (Key_reads is not accurate)
)
[data writes] => Array
(
[0] => IO
[1] => =GetWrites
[2] => Number of inserts/updates/deletes * coef (Key_writes is not accurate)
)
[2] => Data Cache
[MyISAM data cache size] => Array
(
[0] => DATAC
[1] => Array
(
[0] => show variables
[1] => key_buffer_size
)
[2] =>
)
[BDB data cache size] => Array
(
[0] => DATAC
[1] => Array
(
[0] => show variables
[1] => bdb_cache_size
)
[2] =>
)
[InnoDB data cache size] => Array
(
[0] => DATAC
[1] => Array
(
[0] => show variables
[1] => innodb_buffer_pool_size
)
[2] =>
)
[3] => Memory Usage
[read buffer size] => Array
(
[0] => CACHE
[1] => Array
(
[0] => show variables
[1] => read_buffer_size
)
[2] => (per session)
)
[sort buffer size] => Array
(
[0] => CACHE
[1] => Array
(
[0] => show variables
[1] => sort_buffer_size
)
[2] => Size of sort buffer (per session)
)
[table cache] => Array
(
[0] => CACHE
[1] => Array
(
[0] => show variables
[1] => table_cache
)
[2] => Number of tables to keep open
)
[4] => Connections
[current connections] => Array
(
[0] => SESS
[1] => Array
(
[0] => show status
[1] => Threads_connected
)
[2] =>
)
[max connections] => Array
(
[0] => SESS
[1] => Array
(
[0] => show variables
[1] => max_connections
)
[2] =>
)
[5] =>
)
[optimizeTableLow] => CHECK TABLE %s FAST QUICK
[optimizeTableHigh] => OPTIMIZE TABLE %s
[color] => #F0F0F0
[table] =>
[titles] => | Parameter | Value | Description |
[warnRatio] => 90
[cliFormat] => %32s => %s
[sql1] => sql1
[explain] => 1
[helpurl] => LogSQL help
[maxLength] => 2000
[_logsql] =>
[_lastload] =>
[genID] => 0
[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);
[_genSeqSQL] => create table %s (id int not null)
[_genSeq2SQL] => insert into %s values (%s)
[_dropSeqSQL] => drop table %s
[nameQuote] => `
[sysDate] => CURDATE()
[sysTimeStamp] => NOW()
[connectionId] => Resource id #17
[record_set] =>
[database] => mission_new
[dbtype] => mysql
[dataProvider] => mysql
[host] => localhost
[open] =>
[password] => m3dus8
[username] => mission_terry
[persistent] =>
[debug] =>
[debug_console] =>
[debug_echo] => 1
[debug_output] =>
[forcenewconnection] =>
[createdatabase] =>
[last_module_name] => pear
[socket] =>
[port] =>
[clientFlags] => 0
[sql] => SELECT * FROM pmd_images WHERE firmselector=NULL ORDER BY ordering LIMIT
[raiseErrorFn] => ADODB_Error_Handler
[query_count] => 6
[query_time_total] => 0.00304961204529
[query_list] => Array
(
)
[query_list_time] => Array
(
)
[query_list_errors] => Array
(
)
)
[type] => ->
[args] => Array
(
[0] => SELECT * FROM pmd_images WHERE firmselector=? ORDER BY ordering LIMIT
[1] => Array
(
[0] =>
)
)
)
[4] => Array
(
[file] => /home/mission/public_html/listing_gallery.php
[line] => 22
[function] => GetAll
[class] => mysql_driver_ADOConnection
[object] => pear_ADOConnection Object
(
[metaTablesSQL] => SHOW TABLES
[metaColumnsSQL] => SHOW COLUMNS FROM %s
[upperCase] => upper
[substr] => substring
[tablesSQL] => show table status
[createTableSQL] => CREATE TABLE adodb_logsql (
created datetime NOT NULL,
sql0 varchar(250) NOT NULL,
sql1 text NOT NULL,
params text NOT NULL,
tracer text NOT NULL,
timer decimal(16,6) NOT NULL
)
[settings] => Array
(
[0] => Ratios
[MyISAM cache hit ratio] => Array
(
[0] => RATIO
[1] => =GetKeyHitRatio
[2] => =WarnCacheRatio
)
[InnoDB cache hit ratio] => Array
(
[0] => RATIO
[1] => =GetInnoDBHitRatio
[2] => =WarnCacheRatio
)
[data cache hit ratio] => Array
(
[0] => HIDE
[1] => =FindDBHitRatio
[2] => =WarnCacheRatio
)
[sql cache hit ratio] => Array
(
[0] => RATIO
[1] => =GetQHitRatio
[2] =>
)
[1] => IO
[data reads] => Array
(
[0] => IO
[1] => =GetReads
[2] => Number of selects (Key_reads is not accurate)
)
[data writes] => Array
(
[0] => IO
[1] => =GetWrites
[2] => Number of inserts/updates/deletes * coef (Key_writes is not accurate)
)
[2] => Data Cache
[MyISAM data cache size] => Array
(
[0] => DATAC
[1] => Array
(
[0] => show variables
[1] => key_buffer_size
)
[2] =>
)
[BDB data cache size] => Array
(
[0] => DATAC
[1] => Array
(
[0] => show variables
[1] => bdb_cache_size
)
[2] =>
)
[InnoDB data cache size] => Array
(
[0] => DATAC
[1] => Array
(
[0] => show variables
[1] => innodb_buffer_pool_size
)
[2] =>
)
[3] => Memory Usage
[read buffer size] => Array
(
[0] => CACHE
[1] => Array
(
[0] => show variables
[1] => read_buffer_size
)
[2] => (per session)
)
[sort buffer size] => Array
(
[0] => CACHE
[1] => Array
(
[0] => show variables
[1] => sort_buffer_size
)
[2] => Size of sort buffer (per session)
)
[table cache] => Array
(
[0] => CACHE
[1] => Array
(
[0] => show variables
[1] => table_cache
)
[2] => Number of tables to keep open
)
[4] => Connections
[current connections] => Array
(
[0] => SESS
[1] => Array
(
[0] => show status
[1] => Threads_connected
)
[2] =>
)
[max connections] => Array
(
[0] => SESS
[1] => Array
(
[0] => show variables
[1] => max_connections
)
[2] =>
)
[5] =>
)
[optimizeTableLow] => CHECK TABLE %s FAST QUICK
[optimizeTableHigh] => OPTIMIZE TABLE %s
[color] => #F0F0F0
[table] =>
[titles] => | Parameter | Value | Description |
[warnRatio] => 90
[cliFormat] => %32s => %s
[sql1] => sql1
[explain] => 1
[helpurl] => LogSQL help
[maxLength] => 2000
[_logsql] =>
[_lastload] =>
[genID] => 0
[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);
[_genSeqSQL] => create table %s (id int not null)
[_genSeq2SQL] => insert into %s values (%s)
[_dropSeqSQL] => drop table %s
[nameQuote] => `
[sysDate] => CURDATE()
[sysTimeStamp] => NOW()
[connectionId] => Resource id #17
[record_set] =>
[database] => mission_new
[dbtype] => mysql
[dataProvider] => mysql
[host] => localhost
[open] =>
[password] => m3dus8
[username] => mission_terry
[persistent] =>
[debug] =>
[debug_console] =>
[debug_echo] => 1
[debug_output] =>
[forcenewconnection] =>
[createdatabase] =>
[last_module_name] => pear
[socket] =>
[port] =>
[clientFlags] => 0
[sql] => SELECT * FROM pmd_images WHERE firmselector=NULL ORDER BY ordering LIMIT
[raiseErrorFn] => ADODB_Error_Handler
[query_count] => 6
[query_time_total] => 0.00304961204529
[query_list] => Array
(
)
[query_list_time] => Array
(
)
[query_list_errors] => Array
(
)
)
[type] => ->
[args] => Array
(
[0] => SELECT * FROM pmd_images WHERE firmselector=? ORDER BY ordering LIMIT
[1] => Array
(
[0] =>
)
)
)
)
Fatal error: mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1] in EXECUTE("SELECT * FROM pmd_images WHERE firmselector=NULL ORDER BY ordering LIMIT ")
in /home/mission/public_html/includes/adodblite/adodb-errorhandler.inc.php on line 79