Time : 07:08:05 SQLSTATE[42000]: Syntax error or access violation: 1064 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 'PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-08-10 12:38:05' where SUBORDERSID=17837' at line 1 Raw SQL : update suborders set TARRIF='24',AMOUNT='6000',discount='50.00',discountamount='3000.00',netamount='3000.00',MAGZINEEDITIONS='154',ISPAGEFIX=,PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-08-10 12:38:05' where SUBORDERSID=17837 Time : 07:03:23 SQLSTATE[42000]: Syntax error or access violation: 1064 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 'PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-08-10 12:33:23' where SUBORDERSID=16415' at line 1 Raw SQL : update suborders set TARRIF='12',AMOUNT='1200',discount='58.00',discountamount='696.00',netamount='504.00',MAGZINEEDITIONS='154',ISPAGEFIX=,PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-08-10 12:33:23' where SUBORDERSID=16415 Time : 06:59:38 SQLSTATE[42000]: Syntax error or access violation: 1064 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 'PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-08-10 12:29:38' where SUBORDERSID=17837' at line 1 Raw SQL : update suborders set TARRIF='24',AMOUNT='6000',discount='50.00',discountamount='3000.00',netamount='3000.00',MAGZINEEDITIONS='154',ISPAGEFIX=,PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-08-10 12:29:38' where SUBORDERSID=17837 Time : 06:58:30 SQLSTATE[42000]: Syntax error or access violation: 1064 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 'PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-08-10 12:28:30' where SUBORDERSID=17837' at line 1 Raw SQL : update suborders set TARRIF='24',AMOUNT='6000',discount='50.00',discountamount='3000.00',netamount='3000.00',MAGZINEEDITIONS='154',ISPAGEFIX=,PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-08-10 12:28:30' where SUBORDERSID=17837 Time : 06:58:03 SQLSTATE[42000]: Syntax error or access violation: 1064 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 'PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-08-10 12:28:03' where SUBORDERSID=17837' at line 1 Raw SQL : update suborders set TARRIF='24',AMOUNT='6000',discount='50.00',discountamount='3000.00',netamount='3000.00',MAGZINEEDITIONS='154',ISPAGEFIX=,PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-08-10 12:28:03' where SUBORDERSID=17837 Time : 06:57:30 SQLSTATE[42000]: Syntax error or access violation: 1064 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 ''1','2017-08-10','2017-08-10',5,5)' at line 1 Raw SQL : insert into invoicedetail(REFERENCENO,ADJUSTMENTDATE,adjustmentamount,ADJUSTMENTMETHODID,TRANSACTIONID,LEDGER,PARENTINVOICE,DRCR,CREATEDDATE,UPDATEDDATE,CREATEDBY,UPDATEDBY) values ('','2017-08-10','','23','91119','',,'1','2017-08-10','2017-08-10',5,5)