Time : 12:39:10 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'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=1854 and NAME='Hardeo Motor'S' Time : 12:39: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'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=1854 and NAME='Hardeo Motor'S' Time : 12:38: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'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=1854 and NAME='Hardeo Motor'S' Time : 12:37: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'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=1854 and NAME='Hardeo Motor'S' Time : 12:33:15 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'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=1854 and NAME='Hardeo Motor'S' Time : 12:33: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 'S'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=1854 and NAME='Hardeo Motor'S' Time : 12:33: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 'S'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=1854 and NAME='Hardeo Motor'S' Time : 12:33: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 'S'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=1854 and NAME='Hardeo Motor'S' Time : 12:33: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'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=1854 and NAME='Hardeo Motor'S' Time : 12:30: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'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=1854 and NAME='Hardeo Motor'S' Time : 12:29: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'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=1854 and NAME='Hardeo Motor'S' Time : 12:29: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'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=1854 and NAME='Hardeo Motor'S' Time : 08:57:05 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'PARTYID' in 'where clause' Raw SQL : delete from businesstype where PARTYID=11801 Time : 08:35: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 'LIKE '%[0-9]%'' at line 1 Raw SQL : SELECT MAX(PARTYCODE) as max FROM partydetail PARTYCODE LIKE '%[0-9]%' Time : 08:34:58 SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION parivzeo_neworcl.ISNUMERIC does not exist Raw SQL : SELECT MAX(PARTYCODE) as max FROM partydetail WHERE ISNUMERIC(PARTYCODE)=1 AND PARTYCODE LIKE '%[0-9]%' Time : 08:33:51 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 'Int)) FROM partydetail WHERE ISNUMERIC(PARTYCODE)=1 AND PARTYCODE LIKE '%[0-9]%'' at line 1 Raw SQL : SELECT MAX(CAST(PARTYCODE AS Int)) FROM partydetail WHERE ISNUMERIC(PARTYCODE)=1 AND PARTYCODE LIKE '%[0-9]%' Time : 07:45:55 SQLSTATE[08004] [1040] Too many connections Time : 07:45:06 SQLSTATE[08004] [1040] Too many connections Time : 07:43:51 SQLSTATE[08004] [1040] Too many connections Time : 07:43:25 SQLSTATE[HY000] [1040] Too many connections Time : 07:41:17 SQLSTATE[08004] [1040] Too many connections Time : 07:38:22 SQLSTATE[08004] [1040] Too many connections Time : 07:21:17 SQLSTATE[08004] [1040] Too many connections Time : 07:20:37 SQLSTATE[08004] [1040] Too many connections Time : 07:18:16 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 'Int)) FROM partydetail WHERE ISNUMERIC(PARTYCODE)=1 AND PARTYCODE LIKE '%[0-9]%'' at line 1 Raw SQL : SELECT MAX(CAST(PARTYCODE AS Int)) FROM partydetail WHERE ISNUMERIC(PARTYCODE)=1 AND PARTYCODE LIKE '%[0-9]%' Time : 07:14:46 SQLSTATE[HY000] [1040] Too many connections Time : 07:09:13 SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION parivzeo_neworcl.ISNUMERIC does not exist Raw SQL : select MAX(PARTYCODE) from partydetail WHERE PARTYCODE NOT LIKE '%[a-z]%' AND ISNUMERIC(PARTYCODE) = 1 Time : 07:08: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 'Int)) from partydetail WHERE PARTYCODE NOT LIKE '%[a-z]%' AND ISNUMERIC(PARTYCOD' at line 1 Raw SQL : select MAX(CAST(PARTYCODE AS Int)) from partydetail WHERE PARTYCODE NOT LIKE '%[a-z]%' AND ISNUMERIC(PARTYCODE) = 1 Time : 07:06: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 'Int)) as max from partydetail WHERE PARTYCODE NOT LIKE '%[a-z]%' AND ISNUMERIC(P' at line 1 Raw SQL : select MAX(CAST(PARTYCODE AS Int)) as max from partydetail WHERE PARTYCODE NOT LIKE '%[a-z]%' AND ISNUMERIC(PARTYCODE) = 1 Time : 05:55:34 SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'NAME' in field list is ambiguous Raw SQL : select CONTACTPERSONID,PARTYCODE,p.NAME as partyname,NAME,DESIGNATION,dob,MOBILENO,EMAILID from partydetail as p,contactperson as cp where p.PARTYID=cp.PARTY and dob BETWEEN '1967-03-01 00:00:00' AND '2017-03-24 00:00:00' order by dob asc limit 0,20 Time : 05:54:35 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'partydetail.NAME' in 'field list' Raw SQL : select CONTACTPERSONID,PARTYCODE,partydetail.NAME as partyname,NAME,DESIGNATION,dob,MOBILENO,EMAILID from partydetail as p,contactperson as cp where p.PARTYID=cp.PARTY and dob BETWEEN '1967-03-01 00:00:00' AND '2017-03-24 00:00:00' order by dob asc limit 0,20 Time : 05:52:26 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contactperson.NAME' in 'order clause' Raw SQL : select count(CONTACTPERSONID) as totalnew_parties from partydetail as p,contactperson as cp where p.PARTYID=cp.PARTY order by contactperson.NAME asc Time : 05:50:59 SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'NAME' in order clause is ambiguous Raw SQL : select count(CONTACTPERSONID) as totalnew_parties from partydetail as p,contactperson as cp where p.PARTYID=cp.PARTY order by NAME asc Time : 05:50:15 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'SUBSCRIPTIONID' in 'field list' Raw SQL : select count(SUBSCRIPTIONID) as totalnew_parties from partydetail as p,contactperson as cp where p.PARTYID=cp.PARTY order by NAME asc Time : 03:23:36 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' Raw SQL : insert into contact(PARTY,CREATEDDATE,CREATEDBY,UPDATEDBY,UPDATEDDATE,addresstype,ADD1,ADD2,CITY,DISTRICT,STATE,COUNTRY,PINCODE,STDCODE,PHONE,PHONE2,FAX,MOBILE,MOBILENO) values(:PARTY,:CREATEDDATE,:CREATEDBY,:UPDATEDBY,:UPDATEDDATE,:addresstype,:ADD1,:ADD2,:CITY,:DISTRICT,:STATE,:COUNTRY,:PINCODE,:STDCODE,:PHONE,:PHONE2,:FAX,:MOBILE,:MOBILENO) Time : 03:11:49 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' Raw SQL : insert into contact(PARTY,CREATEDDATE,CREATEDBY,UPDATEDBY,UPDATEDDATE,addresstype,ADD1,ADD2,CITY,DISTRICT,STATE,COUNTRY,PINCODE,STDCODE,PHONE,PHONE2,FAX,MOBILE,MOBILENO) values(:PARTY,:CREATEDDATE,:CREATEDBY,:UPDATEDBY,:UPDATEDDATE,:addresstype,:ADD1,:ADD2,:CITY,:DISTRICT,:STATE,:COUNTRY,:PINCODE,:STDCODE,:PHONE,:PHONE2,:FAX,:MOBILE,:MOBILENO) Time : 03:06:14 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' Raw SQL : insert into contact(PARTY,CREATEDDATE,CREATEDBY,UPDATEDBY,UPDATEDDATE,addresstype,ADD1,ADD2,CITY,DISTRICT,STATE,COUNTRY,PINCODE,STDCODE,PHONE,PHONE2,FAX,MOBILE,MOBILENO) values(:PARTY,:CREATEDDATE,:CREATEDBY,:UPDATEDBY,:UPDATEDDATE,:addresstype,:ADD1,:ADD2,:CITY,:DISTRICT,:STATE,:COUNTRY,:PINCODE,:STDCODE,:PHONE,:PHONE2,:FAX,:MOBILE,:MOBILENO) Time : 03:01:23 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' Raw SQL : insert into contact(PARTY,CREATEDDATE,CREATEDBY,UPDATEDBY,UPDATEDDATE,addresstype,ADD1,ADD2,CITY,DISTRICT,STATE,COUNTRY,PINCODE,STDCODE,PHONE,PHONE2,FAX,MOBILE,MOBILENO) values(:PARTY,:CREATEDDATE,:CREATEDBY,:UPDATEDBY,:UPDATEDDATE,:addresstype,:ADD1,:ADD2,:CITY,:DISTRICT,:STATE,:COUNTRY,:PINCODE,:STDCODE,:PHONE,:PHONE2,:FAX,:MOBILE,:MOBILENO)