Time : 20:40:52 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 : 15:36: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 '' at line 1 Raw SQL : select ipaddress from p_customers where customerid= Time : 12:30:26 SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'addedby' cannot be null Raw SQL : insert into p_vacancy(title,description,category_id,start_date,end_date,customer_id,status,adddate,addedby,lastmodifiedby,lastmodifieddate) values(:title,:description,:category_id,:start_date,:end_date,:customer_id,:status,:adddate,:addedby,:lastmodifiedby,:lastmodifieddate) Time : 12:02: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 : 11:50:59 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL and PARTYID in ( select partyid from productmapping where chennalid in(3)) and certifiedBy in(203) and PARTYID in ( select PARTY from dealsin where DEALSIN in(195)) order by NAME asc Time : 11:47:44 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL and PARTYID in ( select partyid from productmapping where chennalid in(1)) and certifiedBy in(204) and PARTYID in ( select PARTY from dealsin where DEALSIN in(195)) order by NAME asc Time : 11:31:29 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:59 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL and PARTYID in ( select partyid from productmapping where categoryid in(10)) order by NAME asc Time : 11:20:29 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL and PARTYID in ( select partyid from productmapping where categoryid in(10)) order by NAME asc Time : 11:18:14 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL and PARTYID in ( select partyid from productmapping where productid in(14)) and PARTYID in ( select partyid from productmapping where categoryid in(10)) order by NAME asc Time : 11:17:14 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL and PARTYID in ( select partyid from productmapping where productid in(15)) and PARTYID in ( select partyid from productmapping where categoryid in(10)) order by partydetail.NAME asc Time : 11:16:29 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL and PARTYID in ( select partyid from productmapping where productid in(15)) and PARTYID in ( select partyid from productmapping where categoryid in(10)) order by partydetail.NAME asc Time : 11:15:44 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL and PARTYID in ( select partyid from productmapping where productid in(15)) and PARTYID in ( select partyid from productmapping where categoryid in(10)) order by partydetail.NAME asc Time : 11:14:29 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL and PARTYID in ( select partyid from productmapping where productid in(15)) and PARTYID in ( select partyid from productmapping where categoryid in(10)) order by partydetail.NAME asc Time : 11:13:14 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL and PARTYID in ( select partyid from productmapping where productid in(15)) and PARTYID in ( select partyid from productmapping where categoryid in(10)) order by partydetail.NAME asc Time : 11:10:29 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL and PARTYID in ( select partyid from productmapping where productid in(15)) and PARTYID in ( select partyid from productmapping where categoryid in(10)) order by partydetail.NAME asc Time : 11:09:29 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL and PARTYID in ( select partyid from productmapping where productid in(15)) and PARTYID in ( select partyid from productmapping where categoryid in(10)) order by partydetail.NAME asc Time : 11:08:44 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL and PARTYID in ( select partyid from productmapping where productid in(15)) and PARTYID in ( select partyid from productmapping where categoryid in(10)) order by partydetail.NAME asc Time : 11:04:14 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL and PARTYID in ( select PARTYID from productmapping where productid in(15)) and PARTYID in ( select PARTYID from productmapping where categoryid in(10)) order by partydetail.NAME asc Time : 11:03:29 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL and PARTYID in ( select PARTYID from productmapping where categoryid in(10,13)) order by partydetail.NAME asc Time : 11:02:56 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 COUNTRYSTATECITYID,NAME from countrystatecity where PARENTID= Time : 10:53:56 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'adddate' in 'order clause' Raw SQL : select count(PARTYID) as totalnew_vacancy from partydetail where PARTYID in (12429,9639,15715,14986,14986,14986,10196,4643) order by adddate desc Time : 10:52:42 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'adddate' in 'order clause' Raw SQL : select count(PARTYID) as totalnew_vacancy from partydetail where PARTYID in (12429,9639,15715,14986,14986,14986,10196,4643) order by adddate desc Time : 10:49: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 '' at line 1 Raw SQL : select distinct PARTYID,WEBSITE,PARTYCODE,EMAIL,NAME,logo from partydetail where NAME!='' and NAME is not NULL and PARTYID in (select PARTY from contact where CITY in (1474)) and PARTYID in ( select PARTYID from productmapping where categoryid in(4)) order by partydetail.NAME asc limit 0, Time : 10:48: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 '' at line 1 Raw SQL : select ipaddress from p_customers where customerid= Time : 10:48: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 '' at line 1 Raw SQL : select ipaddress from p_customers where customerid= Time : 08:49: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 '1' at line 1 Raw SQL : select count(p_vacancy.vacancy_id) as totalnew_vacancy 1 Time : 08:46:27 SQLSTATE[42S02]: Base table or view not found: 1109 Unknown table 'p_vacancy' in field list Raw SQL : select count(p_vacancy.vacancy_id) as totalnew_vacancy Time : 08:40: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 'p_vacancy.end_date>2016-08-25' at line 1 Raw SQL : select count(p_vacancy.vacancy_id) as totalnew_vacancy from p_vacancy,p_vacancycat where p_vacancy.status=1 and p_vacancy.category_id=p_vacancycat.category_id p_vacancy.end_date>2016-08-25 Time : 08:28:42 SQLSTATE[HY000] [2002] No such file or directory Time : 06:37:09 SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'adddate' in order clause is ambiguous Raw SQL : select p_vacancy.status,vacancy_id,title,description,fullname,category_name,customerid from p_vacancy,p_customers,p_vacancycat where p_vacancy.category_id=p_vacancycat.category_id and p_vacancy.customer_id=p_customers.customerid order by adddate DESC limit 0,20 Time : 06:13: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 'des limit 0,20' at line 1 Raw SQL : select p_vacancy.adddate,p_vacancy.status,vacancy_id,title,description,fullname,category_name,start_date,end_date from p_vacancy,p_customers,p_vacancycat where p_vacancy.category_id=p_vacancycat.category_id and p_vacancy.customer_id=p_customers.customerid and p_customers.customerid=1 and p_customers.party_id>0 order by adddate des limit 0,20 Time : 06:06:37 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 'des' at line 1 Raw SQL : select count(vacancy_id) as totalnew_vacancy from p_vacancy,p_customers,p_vacancycat where p_vacancy.category_id=p_vacancycat.category_id and p_vacancy.customer_id=p_customers.customerid and p_customers.customerid=1 and p_customers.party_id>0 order by adddate des Time : 05:22:35 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'parivahansampdadb.ratings' doesn't exist Raw SQL : select rating from ratings where party_id=998 and customer_id=1 Time : 05:21:08 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'parivahansampdadb.ratings' doesn't exist Raw SQL : select rating from ratings where party_id=998 and customer_id=1 Time : 02:31:04 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=