[27-Jul-2022 17:10:21 America/Los_Angeles] PdoDb - debugger(): UPDATE `si_index` SET WHERE `node` = 'invoice' AND `sub_node` = 1 AND `sub_node_2` = 0 AND `domain_id` = 1 [27-Jul-2022 17:10:21 America/Los_Angeles] PdoDb - query(): Execute error.Array ( [0] => 42000 [1] => 1064 [2] => 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 'WHERE `node` = 'invoice' AND `sub_node` = '1' AND `sub_node_2` = '0' AND `dom' at line 3 ) [27-Jul-2022 17:10:21 America/Los_Angeles] PdoDb - backtrace: Array ( [0] => Array ( [file] => /home/ozwebexp/ozwebexpress.com.au/simpleinvoicesmaster/simpleinvoices-master/include/class/PdoDb.php [line] => 1180 [function] => query [class] => PdoDb [object] => PdoDb Object ( [caseStmts:PdoDb:private] => [debug:PdoDb:private] => [debug_label:PdoDb:private] => [debug_microtime:PdoDb:private] => 0 [distinct:PdoDb:private] => [excludedFields:PdoDb:private] => Array ( [node] => 1 [sub_node] => 1 [sub_node_2] => 1 [domain_id] => 1 ) [fauxPost:PdoDb:private] => Array ( [id] => 565 ) [fieldPrefix:PdoDb:private] => [functions:PdoDb:private] => [groupBy:PdoDb:private] => [havings:PdoDb:private] => [joinStmts:PdoDb:private] => [keyPairs:PdoDb:private] => Array ( [:node_000] => invoice [:sub_node_001] => 1 [:sub_node_2_002] => 0 [:domain_id_003] => 1 ) [lastCommand:PdoDb:private] => [limit:PdoDb:private] => 0 [noErrorLog:PdoDb:private] => [onDuplicateKey:PdoDb:private] => [orderBy:PdoDb:private] => [pdoDb:PdoDb:private] => PDO Object ( ) [pdoDb2:PdoDb:private] => PDO Object ( ) [saveLastCommand:PdoDb:private] => [selectAll:PdoDb:private] => [selectList:PdoDb:private] => [selectStmts:PdoDb:private] => [table_columns:PdoDb:private] => [table_constraints:PdoDb:private] => [table_engine:PdoDb:private] => [table_schema:PdoDb:private] => kerryww3_simpleinvoices [transaction:PdoDb:private] => [usePost:PdoDb:private] => [whereClause:PdoDb:private] => WhereClause Object ( [whereItems:WhereClause:private] => Array ( [0] => WhereItem Object ( [close_paren:WhereItem:private] => [connector:WhereItem:private] => AND [field:WhereItem:private] => node [open_paren:WhereItem:private] => [operator:WhereItem:private] => = [token:WhereItem:private] => :node [value:WhereItem:private] => invoice ) [1] => WhereItem Object ( [close_paren:WhereItem:private] => [connector:WhereItem:private] => AND [field:WhereItem:private] => sub_node [open_paren:WhereItem:private] => [operator:WhereItem:private] => = [token:WhereItem:private] => :sub_node [value:WhereItem:private] => 1 ) [2] => WhereItem Object ( [close_paren:WhereItem:private] => [connector:WhereItem:private] => AND [field:WhereItem:private] => sub_node_2 [open_paren:WhereItem:private] => [operator:WhereItem:private] => = [token:WhereItem:private] => :sub_node_2 [value:WhereItem:private] => 0 ) [3] => WhereItem Object ( [close_paren:WhereItem:private] => [connector:WhereItem:private] => [field:WhereItem:private] => domain_id [open_paren:WhereItem:private] => [operator:WhereItem:private] => = [token:WhereItem:private] => :domain_id [value:WhereItem:private] => 1 ) ) [paren_cnt:WhereClause:private] => 0 [token_cnt:WhereClause:private] => 4 ) ) [type] => -> [args] => Array ( [0] => UPDATE `si_index` SET WHERE `node` = :node_000 AND `sub_node` = :sub_node_001 AND `sub_node_2` = :sub_node_2_002 AND `domain_id` = :domain_id_003 [1] => Array ( [:node_000] => invoice [:sub_node_001] => 1 [:sub_node_2_002] => 0 [:domain_id_003] => 1 ) ) ) [1] => Array ( [file] => /home/ozwebexp/ozwebexpress.com.au/simpleinvoicesmaster/simpleinvoices-master/include/class/Index.php [line] => 63 [function] => request [class] => PdoDb [object] => PdoDb Object ( [caseStmts:PdoDb:private] => [debug:PdoDb:private] => [debug_label:PdoDb:private] => [debug_microtime:PdoDb:private] => 0 [distinct:PdoDb:private] => [excludedFields:PdoDb:private] => Array ( [node] => 1 [sub_node] => 1 [sub_node_2] => 1 [domain_id] => 1 ) [fauxPost:PdoDb:private] => Array ( [id] => 565 ) [fieldPrefix:PdoDb:private] => [functions:PdoDb:private] => [groupBy:PdoDb:private] => [havings:PdoDb:private] => [joinStmts:PdoDb:private] => [keyPairs:PdoDb:private] => Array ( [:node_000] => invoice [:sub_node_001] => 1 [:sub_node_2_002] => 0 [:domain_id_003] => 1 ) [lastCommand:PdoDb:private] => [limit:PdoDb:private] => 0 [noErrorLog:PdoDb:private] => [onDuplicateKey:PdoDb:private] => [orderBy:PdoDb:private] => [pdoDb:PdoDb:private] => PDO Object ( ) [pdoDb2:PdoDb:private] => PDO Object ( ) [saveLastCommand:PdoDb:private] => [selectAll:PdoDb:private] => [selectList:PdoDb:private] => [selectStmts:PdoDb:private] => [table_columns:PdoDb:private] => [table_constraints:PdoDb:private] => [table_engine:PdoDb:private] => [table_schema:PdoDb:private] => kerryww3_simpleinvoices [transaction:PdoDb:private] => [usePost:PdoDb:private] => [whereClause:PdoDb:private] => WhereClause Object ( [whereItems:WhereClause:private] => Array ( [0] => WhereItem Object ( [close_paren:WhereItem:private] => [connector:WhereItem:private] => AND [field:WhereItem:private] => node [open_paren:WhereItem:private] => [operator:WhereItem:private] => = [token:WhereItem:private] => :node [value:WhereItem:private] => invoice ) [1] => WhereItem Object ( [close_paren:WhereItem:private] => [connector:WhereItem:private] => AND [field:WhereItem:private] => sub_node [open_paren:WhereItem:private] => [operator:WhereItem:private] => = [token:WhereItem:private] => :sub_node [value:WhereItem:private] => 1 ) [2] => WhereItem Object ( [close_paren:WhereItem:private] => [connector:WhereItem:private] => AND [field:WhereItem:private] => sub_node_2 [open_paren:WhereItem:private] => [operator:WhereItem:private] => = [token:WhereItem:private] => :sub_node_2 [value:WhereItem:private] => 0 ) [3] => WhereItem Object ( [close_paren:WhereItem:private] => [connector:WhereItem:private] => [field:WhereItem:private] => domain_id [open_paren:WhereItem:private] => [operator:WhereItem:private] => = [token:WhereItem:private] => :domain_id [value:WhereItem:private] => 1 ) ) [paren_cnt:WhereClause:private] => 0 [token_cnt:WhereClause:private] => 4 ) ) [type] => -> [args] => Array ( [0] => UPDATE [1] => si_index ) ) [2] => Array ( [file] => /home/ozwebexp/ozwebexpress.com.au/simpleinvoicesmaster/simpleinvoices-master/include/class/Invoice.php [line] => 170 [function] => increment [class] => Index [type] => :: [args] => Array ( [0] => invoice [1] => 1 [2] => 1 ) ) [3] => Array ( [file] => /home/ozwebexp/ozwebexpress.com.au/simpleinvoicesmaster/simpleinvoices-master/modules/invoices/save.php [line] => 43 [function] => insert [class] => Invoice [type] => :: [args] => Array ( [0] => Array ( [biller_id] => 5 [customer_id] => 81 [type_id] => 1 [preference_id] => 1 [date] => 2022-07-27 [note] => [custom_field1] => [custom_field2] => [custom_field3] => [custom_field4] => [sales_representative] => ) ) ) [4] => Array ( [file] => /home/ozwebexp/ozwebexpress.com.au/simpleinvoicesmaster/simpleinvoices-master/index.php [line] => 283 [args] => Array ( [0] => /home/ozwebexp/ozwebexpress.com.au/simpleinvoicesmaster/simpleinvoices-master/modules/invoices/save.php ) [function] => include ) ) [27-Jul-2022 17:10:21 America/Los_Angeles] modules/invoices/save.php - insert exception error: PdoDb - query(): Execute error. See error_log.