Warning: Trying to access array offset on value of type int in /home/hillvall/public_html/itemslist.php on line 97
Warning: Trying to access array offset on value of type null in /home/hillvall/public_html/itemslist.php on line 99
Warning: Trying to access array offset on value of type null in /home/hillvall/public_html/itemslist.php on line 100
Warning: Trying to access array offset on value of type null in /home/hillvall/public_html/itemslist.php on line 100
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] => 156 [function] => getItemCount [class] => Item [object] => Item Object ( [dbconn] => ADODB_mysqli Object ( [dataProvider] => mysql [databaseType] => mysqli [database] => [dsnType] => [host] => [port] => 3306 [user] => [password] => [debug] => [maxblobsize] => 262144 [concat_operator] => + [substr] => substring [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [fmtTimeStamp] => 'Y-m-d H:i:s' [true] => 1 [false] => 0 [replaceQuote] => \' [nameQuote] => ` [leftBracket] => [ [rightBracket] => ] [charSet] => [metaDatabasesSQL] => [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` [identitySQL] => [_genSeqSQL] => create table if not exists %s (id int not null) [_dropSeqSQL] => drop table if exists %s [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [uniqueOrderBy] => [emptyDate] => [emptyTimeStamp] => [lastInsID] => [hasInsertID] => 1 [hasAffectedRows] => 1 [hasTop] => [hasLimit] => 1 [readOnly] => [hasMoveFirst] => 1 [hasGenID] => 1 [hasTransactions] => 1 [genID] => 0 [raiseErrorFn] => [isoDates] => 1 [cacheSecs] => 0 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [memCacheOptions] => Array ( ) [sysDate] => CURDATE() [sysTimeStamp] => NOW() [sysUTimeStamp] => [arrayClass] => ADORecordSet_array_mysqli [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => [poorAffectedRows] => 1 [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => 2 [null2null] => null [bulkBind] => [connectStmt] => [_oldRaiseFn] => [_transOK] => [_connectionID] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 8.1.30 [client_version] => 80130 [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] => 10.6.19-MariaDB-cll-lve [server_version] => 100619 [sqlstate] => 42000 [protocol_version] => 10 [thread_id] => 5712245 [warning_count] => 0 ) [_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] => 0 [_queryID] => [_isPersistentConnection] => [_bindInputArray] => [evalAll] => [_affected] => [_logsql] => [_transmode] => [connectionParameters:protected] => Array ( ) [customActualTypes] => Array ( ) [customMetaTypes] => Array ( ) [_metars] => [locale] => [forceNewConnect] => [clientFlags] => 0 [socket] => [optionFlags] => Array ( ) [multiQuery] => [ssl_key] => [ssl_cert] => [ssl_ca] => [ssl_capath] => [ssl_cipher] => [usePreparedStatement:ADODB_mysqli:private] => [useLastInsertStatement:ADODB_mysqli:private] => [usingBoundVariables:ADODB_mysqli:private] => [statementAffectedRows:ADODB_mysqli:private] => -1 [isSelectStatement:ADODB_mysqli:private] => 1 [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) ) ) [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 ) )