Time : 12:25:10 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 accountledger where ACCOUNTLEDGERID= Time : 11:12:17 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pereditionaverageprice' in 'field list' Raw SQL : insert into invoicedetail(REFERENCENO,invoicefromdate,invoicetodate,TRANSACTIONID,ADJUSTMENTMETHODID,ADJUSTMENTDATE,adjustmentamount,DRCR,pereditionaverageprice,CREATEDDATE,CREATEDBY,UPDATEDBY,UPDATEDDATE,LEDGER) values(:REFERENCENO,:invoicefromdate,:invoicetodate,:TRANSACTIONID,:ADJUSTMENTMETHODID,:ADJUSTMENTDATE,:adjustmentamount,:DRCR,:pereditionaverageprice,:CREATEDDATE,:CREATEDBY,:UPDATEDBY,:UPDATEDDATE,:LEDGER)