Time : 12:04: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 1 Raw SQL : select * from tarrifdetail tf inner join pagedetail pd on pd.PAGEDETAILID=tf.PAGEDETAIL where tf.ID= Time : 12:04:46 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-29 17:34:46' where SUBORDERSID=17600' at line 1 Raw SQL : update suborders set TARRIF='5',AMOUNT='7000',discount='40.00',discountamount='2800.00',netamount='4200.00',MAGZINEEDITIONS='164',ISPAGEFIX=,PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-08-29 17:34:46' where SUBORDERSID=17600 Time : 12:04: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-08-29 17:34:24' where SUBORDERSID=17599' at line 1 Raw SQL : update suborders set TARRIF='5',AMOUNT='7000',discount='40.00',discountamount='2800.00',netamount='4200.00',MAGZINEEDITIONS='161',ISPAGEFIX=,PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-08-29 17:34:24' where SUBORDERSID=17599 Time : 12:04: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-08-29 17:34:07' where SUBORDERSID=17599' at line 1 Raw SQL : update suborders set TARRIF='5',AMOUNT='7000',discount='40.00',discountamount='2800.00',netamount='4200.00',MAGZINEEDITIONS='162',ISPAGEFIX=,PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-08-29 17:34:07' where SUBORDERSID=17599