Time : 12:55:55 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 ''1','2020-11-04','2020-11-04',5,5)' at line 1 Raw SQL : insert into invoicedetail(REFERENCENO,ADJUSTMENTDATE,adjustmentamount,ADJUSTMENTMETHODID,TRANSACTIONID,LEDGER,PARENTINVOICE,DRCR,CREATEDDATE,UPDATEDDATE,CREATEDBY,UPDATEDBY) values ('','2020-11-02','','23','119656','',,'1','2020-11-04','2020-11-04',5,5) Time : 09:15:32 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 ipaddress from p_customers where customerid= Time : 06:03:39 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 ipaddress from p_customers where customerid=