Time : 13:53:41 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:41 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ps' in 'where clause' Raw SQL : select count(DISPATCHREGISTERID) as totalnew_parties from dispatchregister as ab,partydetail as p,(select PARTY as prty,CITY,addresstype from contact ) as c where p.PARTYID=ab.FIRMNAME and p.PARTYID=c.prty and ab.addresstype=c.addresstype and docketNo=ps and ab.UPDATEDBY=31 order by DISPATCHDATE DESC Time : 05:44:44 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ps' in 'where clause' Raw SQL : select count(DISPATCHREGISTERID) as totalnew_parties from dispatchregister as ab,partydetail as p,(select PARTY as prty,CITY,addresstype from contact ) as c where p.PARTYID=ab.FIRMNAME and p.PARTYID=c.prty and ab.addresstype=c.addresstype and docketNo=ps order by DISPATCHDATE DESC Time : 05:43:12 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ps' in 'where clause' Raw SQL : select count(DISPATCHREGISTERID) as totalnew_parties from dispatchregister as ab,partydetail as p,(select PARTY as prty,CITY,addresstype from contact ) as c where p.PARTYID=ab.FIRMNAME and p.PARTYID=c.prty and ab.addresstype=c.addresstype and docketNo=ps order by DISPATCHDATE DESC Time : 04:00:28 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=156 and PAGETITLE=