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: 8043373 Threads: 6 Questions: 79088238 Slow queries: 497 Opens: 2688382 Flush tables: 1 Open tables: 64 Queries per second avg: 9.832 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2995557 [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] => test ) ) [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 ) )
Hill Valley Webáruház Kft.