Time : 12:20:50 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-10-04 17:50:50' where SUBORDERSID=16064' at line 1 Raw SQL : update suborders set TARRIF='12',AMOUNT=' 1200',discount='50',discountamount='600',netamount='600',MAGZINEEDITIONS='159',ISPAGEFIX=,PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-10-04 17:50:50' where SUBORDERSID=16064 Time : 12:20:17 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-10-04 17:50:17' where SUBORDERSID=16064' at line 1 Raw SQL : update suborders set TARRIF='12',AMOUNT=' 1200',discount='50',discountamount='600',netamount='600',MAGZINEEDITIONS='157',ISPAGEFIX=,PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-10-04 17:50:17' where SUBORDERSID=16064 Time : 12:18:52 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-10-04','2017-10-04',5,5)' at line 1 Raw SQL : insert into invoicedetail(REFERENCENO,ADJUSTMENTDATE,adjustmentamount,ADJUSTMENTMETHODID,TRANSACTIONID,LEDGER,PARENTINVOICE,DRCR,CREATEDDATE,UPDATEDDATE,CREATEDBY,UPDATEDBY) values ('','2017-10-04','','23','93339','',,'1','2017-10-04','2017-10-04',5,5)