Time : 10:48:12 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ISCANCEL' in 'field list' Raw SQL : update advertisementbooking set ISCANCEL=:ISCANCEL,CANCELDATE=:CANCELDATE where ADVERTISEMENTBOOKINGID=:ADVERTISEMENTBOOKINGID Time : 10:31: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 'order by SUBSCRIPTIONID ASC limit 0,20' at line 1 Raw SQL : select SUBSCRIPTIONID,CUSTOMERNATURE from subscription where order by SUBSCRIPTIONID ASC limit 0,20 Time : 10:23: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 'orderby SUBSCRIPTIONID ASC' at line 1 Raw SQL : select SUBSCRIPTIONID,CUSTOMERNATURE from subscription where SUBSCRIPTIONID<5000 orderby SUBSCRIPTIONID ASC Time : 10:22: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 'orderby SUBSCRIPTIONID ASC' at line 1 Raw SQL : select SUBSCRIPTIONID,CUSTOMERNATURE from subscription where SUBSCRIPTIONID<5000 orderby SUBSCRIPTIONID ASC Time : 10:22:11 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 'orderby SUBSCRIPTIONID ASC' at line 1 Raw SQL : select SUBSCRIPTIONID,CUSTOMERNATURE from subscription where SUBSCRIPTIONID<5000 orderby SUBSCRIPTIONID ASC Time : 10:21: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 'SUBSCRIPTIONID ASC where SUBSCRIPTIONID<5000' at line 1 Raw SQL : select SUBSCRIPTIONID,CUSTOMERNATURE from subscription orderby SUBSCRIPTIONID ASC where SUBSCRIPTIONID<5000 Time : 09:45:39 SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'noofdownloads' cannot be null Raw SQL : insert into p_perdaydownloads(customerid,noofdownloads,donwloaddate) values(:customerid,:noofdownloads,:donwloaddate) Time : 09:42: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 '' at line 1 Raw SQL : select ipaddress from p_customers where customerid= Time : 09:20: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 'CONTACTID asc' at line 1 Raw SQL : select CONTACTID,CITY from contact orderby CONTACTID asc