Time : 12:33:07 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 '.EMAIL order by partydetail.NAME asc' at line 1 Raw SQL : select count(partydetail.PARTYID) as totalnew_contact from dealsin,contact,partydetail,productmapping where partydetail.PARTYID=dealsin.PARTY and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID=productmapping.partyid and contact.STATE=7 and LOWER(partydetail.EMAIL) like :partydetail.EMAIL order by partydetail.NAME asc Time : 12:21: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 ': www.akshaybearing.com order by partydetail.NAME asc' at line 1 Raw SQL : select count(partydetail.PARTYID) as totalnew_contact from dealsin,contact,partydetail,productmapping where partydetail.PARTYID=dealsin.PARTY and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID=productmapping.partyid and contact.STATE=7 and LOWER(partydetail.EMAIL) like : www.akshaybearing.com order by partydetail.NAME asc Time : 12:18:19 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 ': EMAIL order by partydetail.NAME asc' at line 1 Raw SQL : select count(partydetail.PARTYID) as totalnew_contact from dealsin,contact,partydetail,productmapping where partydetail.PARTYID=dealsin.PARTY and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID=productmapping.partyid and contact.STATE=7 and LOWER(partydetail.EMAIL) like : EMAIL order by partydetail.NAME asc Time : 12:16: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 ': EMAIL order by partydetail.NAME asc' at line 1 Raw SQL : select count(partydetail.PARTYID) as totalnew_contact from dealsin,contact,partydetail,productmapping where partydetail.PARTYID=dealsin.PARTY and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID=productmapping.partyid and contact.STATE=7 and LOWER(partydetail.EMAIL) like : EMAIL order by partydetail.NAME asc Time : 12:08: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 '.EMAIL order by partydetail.NAME asc' at line 1 Raw SQL : select count(partydetail.PARTYID) as totalnew_contact from dealsin,contact,partydetail,productmapping where partydetail.PARTYID=dealsin.PARTY and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID=productmapping.partyid and contact.STATE=7 and LOWER(partydetail.EMAIL) like :partydetail.EMAIL order by partydetail.NAME asc Time : 12:06: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 '.EMAIL order by partydetail.NAME asc' at line 1 Raw SQL : select count(partydetail.PARTYID) as totalnew_contact from dealsin,contact,partydetail,productmapping where partydetail.PARTYID=dealsin.PARTY and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID=productmapping.partyid and contact.STATE=7 and LOWER(partydetail.EMAIL) like :partydetail.EMAIL order by partydetail.NAME asc Time : 12:04: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 '.EMAIL order by partydetail.NAME asc' at line 1 Raw SQL : select count(partydetail.PARTYID) as totalnew_contact from dealsin,contact,partydetail,productmapping where partydetail.PARTYID=dealsin.PARTY and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID=productmapping.partyid and LOWER(partydetail.EMAIL) like :partydetail.EMAIL order by partydetail.NAME asc Time : 11:34: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 ipaddress from p_customers where customerid= Time : 11:13: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 ') order by partydetail.NAME asc' at line 1 Raw SQL : select count(partydetail.PARTYID) as totalnew_contact from dealsin,contact,partydetail,productmapping where partydetail.PARTYID=dealsin.PARTY and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID=productmapping.partyid and dealsin.DEALSIN in() order by partydetail.NAME asc Time : 09:46:54 SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'subject' in field list is ambiguous Raw SQL : select partyname,city,edition,pageno,requestdate,subject,message from p_requests as pr,p_subjects as ps where pr.subject=ps.subjectid and requesttype=2 and customerid=:custid order by requestdate desc Time : 07:28:00 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 '.EMAIL order by partydetail.NAME asc' at line 1 Raw SQL : select count(partydetail.PARTYID) as totalnew_contact from dealsin,contact,partydetail,productmapping where partydetail.PARTYID=dealsin.PARTY and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID=productmapping.partyid and LOWER(partydetail.EMAIL) like :partydetail.EMAIL order by partydetail.NAME asc Time : 07:25:05 SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'EMAIL' in where clause is ambiguous Raw SQL : select count(partydetail.PARTYID) as totalnew_contact from dealsin,contact,partydetail,productmapping where partydetail.PARTYID=dealsin.PARTY and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID=productmapping.partyid and LOWER(EMAIL) like :EMAIL order by partydetail.NAME asc Time : 07:20:20 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 '.EMAIL order by partydetail.NAME asc' at line 1 Raw SQL : select count(partydetail.PARTYID) as totalnew_contact from dealsin,contact,partydetail,productmapping where partydetail.PARTYID=dealsin.PARTY and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID=productmapping.partyid and LOWER(partydetail.EMAIL) like :partydetail.EMAIL order by partydetail.NAME asc Time : 07:20:12 SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'EMAIL' in where clause is ambiguous Raw SQL : select count(partydetail.PARTYID) as totalnew_contact from dealsin,contact,partydetail,productmapping where partydetail.PARTYID=dealsin.PARTY and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID=productmapping.partyid and LOWER(EMAIL) like :EMAIL order by partydetail.NAME asc Time : 07:16:25 SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'EMAIL' in where clause is ambiguous Raw SQL : select count(partydetail.PARTYID) as totalnew_contact from dealsin,contact,partydetail,productmapping where partydetail.PARTYID=dealsin.PARTY and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID=productmapping.partyid and LOWER(EMAIL) like :EMAIL order by partydetail.NAME asc Time : 06:29:23 SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'EMAIL' in where clause is ambiguous Raw SQL : select count(partydetail.PARTYID) as totalnew_contact from dealsin,contact,partydetail,productmapping where partydetail.PARTYID=dealsin.PARTY and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID=productmapping.partyid and LOWER(EMAIL) like :EMAIL order by partydetail.NAME asc