Time : 12:00:09 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 COUNTRYSTATECITYID,NAME from countrystatecity where PARENTID= Time : 08:48:34 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 SUBORDERSID,PAGENO,MAGZINEEDITIONS,ADVERTISEBOOKINGID,ORDERNO,PARTY from suborders,advertisementbooking where suborders.ADVERTISEBOOKINGID=advertisementbooking.ADVERTISEMENTBOOKINGID and PAGENO=4 and MAGZINEEDITIONS=147 and PAGETITLE= Time : 07:31:06 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' Raw SQL : insert into contact(PARTY,CREATEDDATE,CREATEDBY,UPDATEDBY,UPDATEDDATE,addresstype,ADD1,ADD2,CITY,DISTRICT,STATE,COUNTRY,PINCODE,STDCODE,PHONE,PHONE2,FAX,MOBILE,MOBILENO) values(:PARTY,:CREATEDDATE,:CREATEDBY,:UPDATEDBY,:UPDATEDDATE,:addresstype,:ADD1,:ADD2,:CITY,:DISTRICT,:STATE,:COUNTRY,:PINCODE,:STDCODE,:PHONE,:PHONE2,:FAX,:MOBILE,:MOBILENO) Time : 07:11:03 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' Raw SQL : insert into contact(PARTY,CREATEDDATE,CREATEDBY,UPDATEDBY,UPDATEDDATE,addresstype,ADD1,ADD2,CITY,DISTRICT,STATE,COUNTRY,PINCODE,STDCODE,PHONE,PHONE2,FAX,MOBILE,MOBILENO) values(:PARTY,:CREATEDDATE,:CREATEDBY,:UPDATEDBY,:UPDATEDDATE,:addresstype,:ADD1,:ADD2,:CITY,:DISTRICT,:STATE,:COUNTRY,:PINCODE,:STDCODE,:PHONE,:PHONE2,:FAX,:MOBILE,:MOBILENO) Time : 06:25:45 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'noofissuesforcmplementry' in 'field list' Raw SQL : insert into subscription(PARTY,addresstype,EXECUTIVENAME,INCENTIVEPERCENTAGE,CUSTOMERNATURE,mgznpostbyid,isContinue,AMOUNT,noofissuesforcmplementry,BILLNO,BILLDATE,MODEOFPAYMENT,INSTRUMENTNO,INSTRUMENTDATE,INCENTIVEAMOUNT,fromDate,toDate,totalAmt,CREATEDDATE,CREATEDBY,UPDATEDBY,UPDATEDDATE) values(:PARTY,:addresstype,:EXECUTIVENAME,:INCENTIVEPERCENTAGE,:CUSTOMERNATURE,:mgznpostbyid,:isContinue,:AMOUNT,:noofissuesforcmplementry,:BILLNO,:BILLDATE,:MODEOFPAYMENT,:INSTRUMENTNO,:INSTRUMENTDATE,:INCENTIVEAMOUNT,:fromDate,:toDate,:totalAmt,:CREATEDDATE,:CREATEDBY,:UPDATEDBY,:UPDATEDDATE) Time : 06:13:11 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 SUBORDERSID,PAGENO,MAGZINEEDITIONS,ADVERTISEBOOKINGID,ORDERNO,PARTY from suborders,advertisementbooking where suborders.ADVERTISEBOOKINGID=advertisementbooking.ADVERTISEMENTBOOKINGID and PAGENO=4 and MAGZINEEDITIONS=148 and PAGETITLE= Time : 06:01: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 '' at line 1 Raw SQL : select SUBORDERSID,PAGENO,MAGZINEEDITIONS,ADVERTISEBOOKINGID,ORDERNO,PARTY from suborders,advertisementbooking where suborders.ADVERTISEBOOKINGID=advertisementbooking.ADVERTISEMENTBOOKINGID and PAGENO=4 and MAGZINEEDITIONS=148 and PAGETITLE=