Time : 12:38:58 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 cscs.CODE,cscc.CODE asc' 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 left outer 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 co.addresstype=350 group by order by cscs.CODE,cscc.CODE asc Time : 12:34:44 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 cscs.CODE,cscc.CODE asc' 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 left outer 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 co.addresstype=350 group by order by cscs.CODE,cscc.CODE asc Time : 12:06:45 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ab.ISITCANCEL' in 'where clause' 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 left outer 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 ab.ISITCANCEL is null and so.MAGZINEEDITIONS=150 group by p.PARTYID order by cscs.CODE,cscc.CODE asc Time : 12:05:50 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ab.ISITCANCEL' in 'where clause' 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 left outer 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 ab.ISITCANCEL is null and so.MAGZINEEDITIONS=150 group by p.PARTYID order by cscs.CODE,cscc.CODE asc Time : 12:02:31 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ab.ISITCANCEL' in 'where clause' 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 left outer 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 ab.ISITCANCEL is null and so.MAGZINEEDITIONS=150 group by p.PARTYID order by cscs.CODE,cscc.CODE asc Time : 11:38:29 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ab.mgznpostbyid' in 'where clause' 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 left outer 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>=150 or (ss.fromDate!='' and ss.toDate is null)) and ss.ISCANCEL is null and ss.mgznpostbyid=1 and ab.mgznpostbyid=1 and co.addresstype=350 group by p.PARTYID order by cscs.CODE,cscc.CODE asc Time : 11:29:22 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'co.ADD1' in 'field list' 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 where 1=1 group by p.PARTYID order by cscs.CODE,cscc.CODE asc Time : 11:28:50 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'co.ADD1' in 'field list' 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 advertisementbooking ab on ab.PARTY=p.PARTYID left outer join suborders so on so.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID where 1=1 and ab.ISITCANCEL is null and so.MAGZINEEDITIONS=150 group by p.PARTYID order by cscs.CODE,cscc.CODE asc Time : 11:27: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 'inner join advertisementbooking ab on ab.PARTY=p.PARTYID left outer join suborde' at line 1 Raw SQL : inner join advertisementbooking ab on ab.PARTY=p.PARTYID left outer join suborders so on so.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID where 1=1 and ab.ISITCANCEL is null and so.MAGZINEEDITIONS=150 group by p.PARTYID order by cscs.CODE,cscc.CODE asc Time : 11:25:25 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ab.ISITCANCEL' in 'where clause' 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 left outer 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>=150 or (ss.fromDate!='' and ss.toDate is null)) and ss.ISCANCEL is null and ab.ISITCANCEL is null and so.MAGZINEEDITIONS=150 and co.addresstype=350 group by p.PARTYID order by cscs.CODE,cscc.CODE asc Time : 11:25:06 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 NAME='Mahavir Auto's'' at line 1 Raw SQL : select NAME,CITY,PARTYID from partydetail,contact where PARTYID=PARTY and CITY= and NAME='Mahavir Auto's' Time : 11:25:03 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:25: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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:25: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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:25: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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:25:01 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:24: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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:24:58 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:24:58 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:24:58 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:24: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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:24:54 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:24:54 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:24:54 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:24:54 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:24:54 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:24: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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:24: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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:24:26 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:24:26 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:24:26 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:24:26 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:24:26 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:24:25 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:23:47 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:23:47 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:23:47 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:23:46 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:23:45 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:22:25 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:22:24 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:22:24 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:22:24 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:22:23 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:22:23 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:22:23 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:22:14 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:22:13 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:22:13 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:22:13 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:22: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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:20:44 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 NAME='Mahavir Auto's'' at line 1 Raw SQL : select NAME,CITY,PARTYID from partydetail,contact where PARTYID=PARTY and CITY= and NAME='Mahavir Auto's' Time : 11:20:33 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:20:18 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:20: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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:19:25 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 11:19:18 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 's' and ADD1='10,Vijay Plot, Gondal Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=784 and NAME='Mahavir Auto's' and ADD1='10,Vijay Plot, Gondal Road' Time : 10:40:27 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 'or (ss.fromDate!='' and ss.toDate is null)) and ss.ISCANCEL is null and ab.ISI' 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 left outer join advertisementbooking ab on ab.PARTY=p.PARTYID left outer join suborders so on so.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID inner join contact co on p.PARTYID=co.PARTY inner 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 inner join countrystatecity cscco on cscco.COUNTRYSTATECITYID=co.COUNTRY where 1=1 and (ss.renewalEditions>= or (ss.fromDate!='' and ss.toDate is null)) and ss.ISCANCEL is null and ab.ISITCANCEL is null and so.MAGZINEEDITIONS= and ss.CUSTOMERNATURE=14 and co.addresstype=350 order by cscs.CODE,cscc.CODE asc Time : 10:40:10 SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'CREATEDBY' cannot be null Raw SQL : insert into businesstype(CREATEDDATE,CREATEDBY,UPDATEDBY,UPDATEDDATE,PARTY,BUSINESSTYPE) values(:CREATEDDATE,:CREATEDBY,:UPDATEDBY,:UPDATEDDATE,:PARTY,:BUSINESSTYPE) Time : 10:33:50 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 'or (ss.fromDate!='' and ss.toDate is null)) and ss.ISCANCEL is null and ab.ISI' 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 left outer join advertisementbooking ab on ab.PARTY=p.PARTYID left outer join suborders so on so.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID inner join contact co on p.PARTYID=co.PARTY inner 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 inner join countrystatecity cscco on cscco.COUNTRYSTATECITYID=co.COUNTRY where 1=1 and (ss.renewalEditions>= or (ss.fromDate!='' and ss.toDate is null)) and ss.ISCANCEL is null and ab.ISITCANCEL is null and so.MAGZINEEDITIONS= and co.STATE=30 and co.addresstype=350 order by cscs.CODE,cscc.CODE asc Time : 08:53:46 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 'DATEOFEDITIONS']' and ss.toDate is null)) and ss.ISCANCEL is null and ss.CUS' 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 inner 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 inner join countrystatecity cscco on cscco.COUNTRYSTATECITYID=co.COUNTRY where 1=1 and (ss.fromDate>='2017-06-30 00:00:00' and ss.toDate<='2017-06-30 00:00:00' or (ss.fromDate>='Array['DATEOFEDITIONS']' and ss.toDate is null)) and ss.ISCANCEL is null and ss.CUSTOMERNATURE=14 and co.addresstype=350 group by p.PARTYID order by cscs.CODE,cscc.CODE asc Time : 08:00: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 productId,productName from product where category= Time : 07:59:47 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 cscs.CODE,cscc.CODE asc' at line 9 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 left outer join advertisementbooking ab on ab.PARTY=p.PARTYID left outer join suborders so on so.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID left outer 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>=150 or (ss.fromDate!='' and ss.toDate is null)) and ss.ISCANCEL is null and ab.ISITCANCEL is null and so.MAGZINEEDITIONS=150 and co.addresstype=350 group by order by cscs.CODE,cscc.CODE asc Time : 07:54:21 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'so.PARTY' in 'group statement' 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 left outer 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>=150 or (ss.fromDate!='' and ss.toDate is null)) and ss.ISCANCEL is null and ss.CUSTOMERNATURE=14 and co.addresstype=350 group by so.PARTY,ab.PARTY order by cscs.CODE,cscc.CODE asc Time : 07:54:00 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'so.PARTY' in 'group statement' 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 left outer join advertisementbooking ab on ab.PARTY=p.PARTYID left outer join suborders so on so.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID left outer 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>=150 or (ss.fromDate!='' and ss.toDate is null)) and ss.ISCANCEL is null and ab.ISITCANCEL is null and so.MAGZINEEDITIONS=150 and ss.CUSTOMERNATURE=17 and co.addresstype=350 group by so.PARTY,ab.PARTY order by cscs.CODE,cscc.CODE asc Time : 06:45:38 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cscs.statename' in 'order clause' 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 subscription sssp on sssp.PARTY=p.PARTYID left outer 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>=150 or (ss.fromDate!='' and ss.toDate is null)) and ss.ISCANCEL is null and sssp.CUSTOMERNATURE=8 and co.addresstype=350 group by p.PARTYID order by cscs.statename,cscc.CODE asc