Time : 08:28:29 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:46:51 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' Raw SQL : insert into subscription(PARTY,addresstype,EXECUTIVENAME,INCENTIVEPERCENTAGE,CUSTOMERNATURE,mgznpostbyid,isContinue,AMOUNT,noofissuesforcmplementry,BILLNO,BILLDATE,isEom,MODEOFPAYMENT,INSTRUMENTNO,INSTRUMENTDATE,INCENTIVEAMOUNT,fromDate,toDate,totalAmt,CREATEDDATE,CREATEDBY,UPDATEDBY,UPDATEDDATE) values(:PARTY,:addresstype,:EXECUTIVENAME,:INCENTIVEPERCENTAGE,:CUSTOMERNATURE,:mgznpostbyid,:isContinue,:AMOUNT,:noofissuesforcmplementry,:BILLNO,:BILLDATE,:isEom,:MODEOFPAYMENT,:INSTRUMENTNO,:INSTRUMENTDATE,:INCENTIVEAMOUNT,:fromDate,:toDate,:totalAmt,:CREATEDDATE,:CREATEDBY,:UPDATEDBY,:UPDATEDDATE) Time : 06:42:33 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' Raw SQL : insert into subscription(PARTY,addresstype,EXECUTIVENAME,INCENTIVEPERCENTAGE,CUSTOMERNATURE,mgznpostbyid,isContinue,AMOUNT,noofissuesforcmplementry,BILLNO,BILLDATE,isEom,MODEOFPAYMENT,INSTRUMENTNO,INSTRUMENTDATE,INCENTIVEAMOUNT,fromDate,toDate,totalAmt,CREATEDDATE,CREATEDBY,UPDATEDBY,UPDATEDDATE) values(:PARTY,:addresstype,:EXECUTIVENAME,:INCENTIVEPERCENTAGE,:CUSTOMERNATURE,:mgznpostbyid,:isContinue,:AMOUNT,:noofissuesforcmplementry,:BILLNO,:BILLDATE,:isEom,:MODEOFPAYMENT,:INSTRUMENTNO,:INSTRUMENTDATE,:INCENTIVEAMOUNT,:fromDate,:toDate,:totalAmt,:CREATEDDATE,:CREATEDBY,:UPDATEDBY,:UPDATEDDATE) Time : 06:29:45 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' Raw SQL : insert into subscription(PARTY,addresstype,EXECUTIVENAME,INCENTIVEPERCENTAGE,CUSTOMERNATURE,mgznpostbyid,isContinue,AMOUNT,noofissuesforcmplementry,BILLNO,BILLDATE,isEom,MODEOFPAYMENT,INSTRUMENTNO,INSTRUMENTDATE,INCENTIVEAMOUNT,fromDate,toDate,totalAmt,CREATEDDATE,CREATEDBY,UPDATEDBY,UPDATEDDATE) values(:PARTY,:addresstype,:EXECUTIVENAME,:INCENTIVEPERCENTAGE,:CUSTOMERNATURE,:mgznpostbyid,:isContinue,:AMOUNT,:noofissuesforcmplementry,:BILLNO,:BILLDATE,:isEom,:MODEOFPAYMENT,:INSTRUMENTNO,:INSTRUMENTDATE,:INCENTIVEAMOUNT,:fromDate,:toDate,:totalAmt,:CREATEDDATE,:CREATEDBY,:UPDATEDBY,:UPDATEDDATE) Time : 06:03:34 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' Raw SQL : insert into subscription(PARTY,addresstype,EXECUTIVENAME,INCENTIVEPERCENTAGE,CUSTOMERNATURE,mgznpostbyid,isContinue,AMOUNT,noofissuesforcmplementry,BILLNO,BILLDATE,MODEOFPAYMENT,INSTRUMENTNO,INSTRUMENTDATE,INCENTIVEAMOUNT,fromDate,totalAmt,CREATEDDATE,CREATEDBY,UPDATEDBY,UPDATEDDATE) values(:PARTY,:addresstype,:EXECUTIVENAME,:INCENTIVEPERCENTAGE,:CUSTOMERNATURE,:mgznpostbyid,:isContinue,:AMOUNT,:noofissuesforcmplementry,:BILLNO,:BILLDATE,:MODEOFPAYMENT,:INSTRUMENTNO,:INSTRUMENTDATE,:INCENTIVEAMOUNT,:fromDate,:totalAmt,:CREATEDDATE,:CREATEDBY,:UPDATEDBY,:UPDATEDDATE) Time : 06:01:48 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' Raw SQL : insert into subscription(PARTY,addresstype,EXECUTIVENAME,INCENTIVEPERCENTAGE,CUSTOMERNATURE,mgznpostbyid,isContinue,AMOUNT,noofissuesforcmplementry,BILLNO,BILLDATE,MODEOFPAYMENT,INSTRUMENTNO,INSTRUMENTDATE,INCENTIVEAMOUNT,fromDate,totalAmt,CREATEDDATE,CREATEDBY,UPDATEDBY,UPDATEDDATE) values(:PARTY,:addresstype,:EXECUTIVENAME,:INCENTIVEPERCENTAGE,:CUSTOMERNATURE,:mgznpostbyid,:isContinue,:AMOUNT,:noofissuesforcmplementry,:BILLNO,:BILLDATE,:MODEOFPAYMENT,:INSTRUMENTNO,:INSTRUMENTDATE,:INCENTIVEAMOUNT,:fromDate,:totalAmt,:CREATEDDATE,:CREATEDBY,:UPDATEDBY,:UPDATEDDATE)