Time : 12:35:31 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-31 18:05:31' where SUBORDERSID=18764' at line 1 Raw SQL : update suborders set TARRIF='5',AMOUNT=' 7000',discount='30.00',discountamount='2100',netamount='4900',MAGZINEEDITIONS='163',ISPAGEFIX=,PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-10-31 18:05:31' where SUBORDERSID=18764 Time : 12:33:20 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-31 18:03:20' where SUBORDERSID=18764' at line 1 Raw SQL : update suborders set TARRIF='5',AMOUNT=' 7000',discount='30.00',discountamount='2100',netamount='4900',MAGZINEEDITIONS='163',ISPAGEFIX=,PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-10-31 18:03:20' where SUBORDERSID=18764 Time : 12:32:25 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 '' at line 1 Raw SQL : select * from tarrifdetail tf inner join pagedetail pd on pd.PAGEDETAILID=tf.PAGEDETAIL where tf.ID= Time : 12:32:24 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-31 18:02:24' where SUBORDERSID=18764' at line 1 Raw SQL : update suborders set TARRIF='7',AMOUNT='4000',discount='30.00',discountamount='1200.00',netamount='2800.00',MAGZINEEDITIONS='163',ISPAGEFIX=,PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-10-31 18:02:24' where SUBORDERSID=18764 Time : 12:32:07 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-31 18:02:07' where SUBORDERSID=18764' at line 1 Raw SQL : update suborders set TARRIF='5',AMOUNT=' 7000',discount='30.00',discountamount='2100',netamount='4900',MAGZINEEDITIONS='164',ISPAGEFIX=,PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-10-31 18:02:07' where SUBORDERSID=18764 Time : 12:31:48 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 '' at line 4 Raw SQL : select sos.SUBORDERSID,ab.PAYMENTNOOFISSUES,sos.TARRIF,sos.AMOUNT,sos.discount,sos.discountamount,sos.netamount,sos.MAGZINEEDITIONS from advertisementbooking ab inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID inner join magzineeditions me on me.MAGZINEEDITIONSID=sos.MAGZINEEDITIONS where sos.SUBORDERSID=