Time : 11:14:00 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 ad.*,p.NAME from advertisementbooking ad inner join partydetail p on p.PARTYID=ad.PARTY where ADVERTISEMENTBOOKINGID= Time : 11:13:14 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 'and MAGZINEEDITIONS>=2134' at line 1 Raw SQL : update suborders set ISCANCEL=1,CANCELDATE='',UPDATEDDATE='2017-12-01 16:43:14' where ADVERTISEBOOKINGID= and MAGZINEEDITIONS>=2134