Time : 13:36:53 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 NAME from countrystatecity where COUNTRYSTATECITYID= Time : 11:25:30 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 ss.ISCANCEL is null and co.STATE=26 and co.addresstype=350 group by ' at line 8 Raw SQL : select p.PARTYCODE, p.NAME,co.ADD1,co.ADD2,co.ADD3,co.PINCODE,co.PHONE,cscc.NAME as cityname,cscd.NAME as districtname,cscc.CODE,cscs.shortname ,cscs.NAME as statename,cscco.NAME as countryname, cp.NAME as cpname,cp.MOBILENO from partydetail p inner join subscription ss on ss.PARTY=p.PARTYID inner join contact co on p.PARTYID=co.PARTY left outer join contactperson cp on cp.PARTY=p.PARTYID left outer join countrystatecity cscc on cscc.COUNTRYSTATECITYID=co.CITY left outer join countrystatecity cscd on cscd.COUNTRYSTATECITYID=co.DISTRICT left outer join countrystatecity cscs on cscs.COUNTRYSTATECITYID=co.STATE left outer join countrystatecity cscco on cscco.COUNTRYSTATECITYID=co.COUNTRY where 1=1 and ((ss.renewalEditions is null and ss.toDate is null) or (ss.fromDate!='' and ss.toDate is null) or ss.renewalEditions>=) and ss.ISCANCEL is null and co.STATE=26 and co.addresstype=350 group by p.PARTYID order by cscs.CODE,cscc.CODE asc Time : 10:24: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 workerid,workername from p_workers where workerid= Time : 09:44:34 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 'order by NAME asc' at line 1 Raw SQL : select COUNTRYSTATECITYID,NAME from countrystatecity where PARENTID= order by NAME asc Time : 08:37:02 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 : 08:36: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=