Time : 15:40: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 'and PARTYID!=17834 and NAME='Sharma Auto Agencie'' at line 1 Raw SQL : select NAME from partydetail,contact where PARTYID=PARTY and CITY= and PARTYID!=17834 and NAME='Sharma Auto Agencie' Time : 13:23: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 'CITY=1493 and NAME='prahalad'' at line 1 Raw SQL : select NAME,CITY,PARTYID from partydetail,contact where PARTYID=PARTY CITY=1493 and NAME='prahalad' Time : 12:41:58 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'new_parivahan_orcl.contacts' doesn't exist Raw SQL : select NAME from partydetail,contacts where CITY=1474 and NAME='prahalad' Time : 12:41:02 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'new_parivahan_orcl.contacts' doesn't exist Raw SQL : select NAME from partydetail,contacts where CITY=1474 and NAME='prahalad' Time : 12:26: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 'and NAME='prahalad'' at line 1 Raw SQL : select NAME from partydetail,contacts where CITY= and NAME='prahalad' Time : 11:47: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 'and NAME='prahalad'' at line 1 Raw SQL : select NAME from partydetail where CITY= and NAME='prahalad' Time : 09:45:36 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'parivahansampdadb.p_worker' doesn't exist Raw SQL : select workerid,workername from p_worker Time : 09:45:09 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'new_parivahan_orcl.p_worker' doesn't exist Raw SQL : select workerid,workername from p_worker Time : 09:24: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 '' at line 1 Raw SQL : select NAME from partydetail where PARTYID= Time : 09:24: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 '' at line 1 Raw SQL : select NAME from partydetail where PARTYID= Time : 09:24: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 '' at line 1 Raw SQL : select NAME from partydetail where PARTYID= Time : 09:24:43 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 partydetail where PARTYID= Time : 09:24: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 NAME from partydetail where PARTYID= Time : 09:24: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 '' at line 1 Raw SQL : select NAME from partydetail where PARTYID= Time : 09:23:15 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'CREATEDDATE' in 'field list' Raw SQL : insert into businesstype(CREATEDDATE,CREATEDBY,UPDATEDBY,UPDATEDDATE,PARTY,BUSINESSTYPE) values(:CREATEDDATE,:CREATEDBY,:UPDATEDBY,:UPDATEDDATE,:PARTY,:BUSINESSTYPE) Time : 09:08: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 '' at line 1 Raw SQL : select NAME from partydetail where PARTYID= Time : 09:07: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 '' at line 1 Raw SQL : select NAME from partydetail where PARTYID= Time : 08:59:47 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tran' in 'where clause' Raw SQL : select count(PARTYID) as totalnew_parties from partydetail as p where NAME!='' and PARTYID in ( select PARTY from contact where ADD1 like tran) order by NAME asc Time : 08:56:32 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'CREATEDDATE' in 'field list' Raw SQL : insert into businesstype(CREATEDDATE,CREATEDBY,UPDATEDBY,UPDATEDDATE,PARTY,BUSINESSTYPE) values(:CREATEDDATE,:CREATEDBY,:UPDATEDBY,:UPDATEDDATE,:PARTY,:BUSINESSTYPE) Time : 06:51: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 'gate) order by NAME asc' at line 1 Raw SQL : select count(PARTYID) as totalnew_parties from partydetail as p where NAME!='' and PARTYID in (select PARTY from contact where CITY=1930) and PARTYID in ( select PARTY from contact where ADD1 like kashmere gate) order by NAME asc Time : 05:24:32 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tran' in 'where clause' Raw SQL : select count(PARTYID) as totalnew_parties from partydetail as p where NAME!='' and PARTYID in ( select PARTY from contact where ADD1 like tran) order by NAME asc Time : 05:23: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 '%tran%) order by NAME asc' at line 1 Raw SQL : select count(PARTYID) as totalnew_parties from partydetail as p where NAME!='' and PARTYID in ( select PARTY from contact where ADD1 like %tran%) order by NAME asc