Time : 10:55:22 SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'segmentid' cannot be null Raw SQL : insert into productmapping(partyId,createdDate,createdBy,updatedBy,updatedDate,chennalId,brandId,categoryId,productId,categoryUsedIn,segmentid,productUsedIn) values(:partyId,:createdDate,:createdBy,:updatedBy,:updatedDate,:chennalId,:brandId,:categoryId,:productId,:categoryUsedIn,:segmentid,:productUsedIn) Time : 10:53:38 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'undefined' in 'where clause' Raw SQL : select * from partydetail where PARTYID=undefined Time : 10:44:40 SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'segmentid' cannot be null Raw SQL : insert into productmapping(partyId,createdDate,createdBy,updatedBy,updatedDate,chennalId,brandId,categoryId,productId,categoryUsedIn,segmentid,productUsedIn) values(:partyId,:createdDate,:createdBy,:updatedBy,:updatedDate,:chennalId,:brandId,:categoryId,:productId,:categoryUsedIn,:segmentid,:productUsedIn) Time : 09:46: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 'order by categoryName' at line 1 Raw SQL : select categoryId,categoryName from category where ismake=1 and segmentid= order by categoryName Time : 06:47: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 productId,productName from product where category= Time : 06:47: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 '' at line 1 Raw SQL : select productId,productName from product where category= Time : 06:39: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 'order by categoryName' at line 1 Raw SQL : select categoryId,categoryName from category where ismake=1 and segmentid= order by categoryName Time : 06:36: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 'order by categoryName' at line 1 Raw SQL : select categoryId,categoryName from category where ismake=1 and segmentid= order by categoryName Time : 06:33: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 'order by categoryName' at line 1 Raw SQL : select categoryId,categoryName from category where ismake=1 and segmentid= order by categoryName Time : 06:22:28 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 categoryName' at line 1 Raw SQL : select categoryId,categoryName from category where ismake=1 and segmentid= order by categoryName