Notice: Trying to access array offset on value of type int in /home/hillvall/public_html/itemslist.php on line 96
Notice: Trying to access array offset on value of type null in /home/hillvall/public_html/itemslist.php on line 98
Notice: Trying to access array offset on value of type null in /home/hillvall/public_html/itemslist.php on line 99
Notice: Trying to access array offset on value of type null in /home/hillvall/public_html/itemslist.php on line 99
DEBUG MODE
Array ( [0] => Array ( [file] => /home/hillvall/public_html/modul/item.php [line] => 29 [function] => onError [args] => Array ( [0] => /home/hillvall/public_html/modul/item.php [1] => 28 [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 MariaDB 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] => /home/hillvall/public_html/itemslist.php [line] => 155 [function] => getItemCount [class] => Item [object] => Item Object ( [dbconn] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => mysql [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= [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] => 3306 [socket] => [_bindInputArray] => [nameQuote] => ` [optionFlags] => Array ( ) [arrayClass] => ADORecordSet_array_mysqli [multiQuery] => [ssl_key] => [ssl_cert] => [ssl_ca] => [ssl_capath] => [ssl_cipher] => [_connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 7.4.33 [client_version] => 70433 [connect_errno] => 0 [connect_error] => [errno] => 1064 [error] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB 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 MariaDB server version for the right syntax to use near 'or titemcategory.parent_id=)' at line 1 ) ) [field_count] => 20 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.5-10.5.21-MariaDB-cll-lve [server_version] => 100521 [sqlstate] => 42000 [protocol_version] => 10 [thread_id] => 10896219 [warning_count] => 0 ) [usePreparedStatement:ADODB_mysqli:private] => [useLastInsertStatement:ADODB_mysqli:private] => [usingBoundVariables:ADODB_mysqli:private] => [statementAffectedRows:ADODB_mysqli:private] => -1 [isSelectStatement:ADODB_mysqli:private] => 1 [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table if not exists %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table if exists %s [database] => [dsnType] => [host] => [user] => [password] => [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [leftBracket] => [ [rightBracket] => ] [charSet] => [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => [cacheSecs] => 0 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [memCacheOptions] => Array ( ) [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] => [_errorMsg] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'or titemcategory.parent_id=)' at line 1 [_errorCode] => [_queryID] => [_isPersistentConnection] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [connectionParameters:protected] => Array ( ) [customActualTypes] => Array ( ) [customMetaTypes] => Array ( ) [databaseName] => hillvall_shop ) ) [type] => -> [args] => Array ( [0] => titem.active=1 and (titem.itemcategory_id= or titemcategory.parent_id=) ) ) [2] => Array ( [file] => /home/hillvall/public_html/index.php [line] => 152 [args] => Array ( [0] => /home/hillvall/public_html/itemslist.php ) [function] => include_once ) )