DEBUG MODE
Array
(
[0] => Array
(
[file] => /www/www/hillvalley.hu/modul/item.php
[line] => 39
[function] => onError
[args] => Array
(
[0] => /www/www/hillvalley.hu/modul/item.php
[1] => 38
[2] => Query error in Datagrid source item count function getItemCount<br />
ADOdb said: <i>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 'or titemcategory.parent_id=)' at line 1</i>
[3] => Array
(
[Query] => SELECT COUNT(*) AS count1 FROM items AS titem LEFT JOIN itemcategory AS titemcategory ON titemcategory.id=titem.itemcategory_id WHERE titem.deleted=0 and titem.active=1 and (titem.itemcategory_id= or titemcategory.parent_id=)
)
)
)
[1] => Array
(
[file] => /www/www/hillvalley.hu/itemslist.php
[line] => 150
[function] => getItemCount
[class] => Item
[object] => Item Object
(
[dbconn] => ADODB_mysqli Object
(
[databaseType] => mysqli
[dataProvider] => native
[hasInsertID] => 1
[hasAffectedRows] => 1
[metaTablesSQL] => SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=SCHEMA()
[metaColumnsSQL] => SHOW COLUMNS FROM `%s`
[fmtTimeStamp] => 'Y-m-d H:i:s'
[hasLimit] => 1
[hasMoveFirst] => 1
[hasGenID] => 1
[isoDates] => 1
[sysDate] => CURDATE()
[sysTimeStamp] => NOW()
[hasTransactions] => 1
[forceNewConnect] =>
[poorAffectedRows] => 1
[clientFlags] => 0
[substr] => substring
[port] =>
[socket] =>
[_bindInputArray] =>
[nameQuote] => `
[optionFlags] => Array
(
[0] => Array
(
[0] => 5
[1] => 0
)
)
[arrayClass] => ADORecordSet_array_mysqli
[multiQuery] =>
[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);
[_genSeqSQL] => create table %s (id int not null)
[_genSeqCountSQL] => select count(*) from %s
[_genSeq2SQL] => insert into %s values (%s)
[_dropSeqSQL] => drop table %s
[database] =>
[host] =>
[user] =>
[password] =>
[debug] =>
[maxblobsize] => 262144
[concat_operator] => +
[length] => length
[random] => rand()
[upperCase] => upper
[fmtDate] => 'Y-m-d'
[true] => 1
[false] => 0
[replaceQuote] => \'
[charSet] =>
[metaDatabasesSQL] =>
[uniqueOrderBy] =>
[emptyDate] =>
[emptyTimeStamp] =>
[lastInsID] =>
[hasTop] =>
[readOnly] =>
[genID] => 0
[raiseErrorFn] =>
[cacheSecs] => 0
[memCache] =>
[memCacheHost] =>
[memCachePort] => 11211
[memCacheCompress] =>
[sysUTimeStamp] =>
[noNullStrings] =>
[numCacheHits] => 0
[numCacheMisses] => 0
[pageExecuteCountRows] => 1
[uniqueSort] =>
[leftOuter] =>
[rightOuter] =>
[ansiOuter] =>
[autoRollback] =>
[fnExecute] =>
[fnCacheExecute] =>
[blobEncodeType] =>
[rsPrefix] => ADORecordSet_
[autoCommit] => 1
[transOff] => 0
[transCnt] => 0
[fetchMode] => 2
[null2null] => null
[bulkBind] =>
[_oldRaiseFn] =>
[_transOK] =>
[_connectionID] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 15d5c781cfcad91193dceae1d2cdd127674ddb3e $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 1064
[error] => 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 'or titemcategory.parent_id=)' at line 1
[error_list] => Array
(
[0] => Array
(
[errno] => 1064
[sqlstate] => 42000
[error] => 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 'or titemcategory.parent_id=)' at line 1
)
)
[field_count] => 19
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.6.40
[server_version] => 50640
[stat] => Uptime: 2647528 Threads: 5 Questions: 39706072 Slow queries: 54 Opens: 1402643 Flush tables: 1 Open tables: 64 Queries per second avg: 14.997
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 1562518
[warning_count] => 0
)
[_errorMsg] => 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 'or titemcategory.parent_id=)' at line 1
[_errorCode] =>
[_queryID] =>
[_isPersistentConnection] =>
[_evalAll] =>
[_affected] =>
[_logsql] =>
[_transmode] =>
[databaseName] => hillvalley
)
)
[type] => ->
[args] => Array
(
[0] => titem.active=1 and (titem.itemcategory_id= or titemcategory.parent_id=)
)
)
[2] => Array
(
[file] => /www/www/hillvalley.hu/index.php
[line] => 165
[args] => Array
(
[0] => /www/www/hillvalley.hu/itemslist.php
)
[function] => include_once
)
)