Time : 12:17:55 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 from contact) as c where p.PARTYID=ab.FIRMNAME and p.PARTYID=c.prty and docketNo=ps order by DISPATCHDATE DESC Time : 07:45:38 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 'where PAGENO=9 and MAGZINEEDITIONS=145' at line 1 Raw SQL : select SUBORDERSID,ADVERTISEBOOKINGID,ORDERNO,PARTY from suborders,advertisementbooking where suborders.ADVERTISEBOOKINGID=advertisementbooking.ADVERTISEMENTBOOKINGID where PAGENO=9 and MAGZINEEDITIONS=145 Time : 07:41:36 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 : 07:34:08 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 : 07:34:05 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 : 07:17:59 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 'WHERE partydetail.PARTYID=10155' at line 1 Raw SQL : select NAME,CITY from partydetail,contact where partydetail.PARTYID=contact.PARTY WHERE partydetail.PARTYID=10155 Time : 07:16:42 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 'WHERE PARTYID=10155' at line 1 Raw SQL : select NAME,CITY from partydetail.contact where partydetail.PARTYID=contact.PARTY WHERE PARTYID=10155 Time : 06:49:22 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 'and MAGZINEEDITIONS=145' at line 1 Raw SQL : select SUBORDERSID from suborders where PAGENO= and MAGZINEEDITIONS=145 Time : 06:27:17 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:20:48 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 AMOUNT from tarrifdetail where ID= Time : 06:12:37 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ORD170000106' in 'where clause' Raw SQL : select ORDERNO from advertisementbooking where ORDERNO=ORD170000106