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 [SQL]UPDATE product SET p_id = NULL, p_parent_id = '1', p_name = 'sdfs' WHERE SQLSTATE[HY000]: General error: 1364 Field 'p_parent_id' doesn't have a default value [SQL]INSERT INTO product () VALUES () SQLSTATE[HY000]: General error: 1364 Field 'p_parent_id' doesn't have a default value [SQL]INSERT INTO product () VALUES () SQLSTATE[HY000]: General error: 1364 Field 'p_parent_id' doesn't have a default value [SQL]INSERT INTO product () VALUES () 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 'from (SELECT *,(SELECT p_name FROM product WHERE p_id=p.p_parent_id) p_parent_na' at line 1 [SQL]select from (SELECT *,(SELECT p_name FROM product WHERE p_id=p.p_parent_id) p_parent_name FROM product p WHERE p_parent_id>0) t_ where p_id='' limit 0,1 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 'from (SELECT *,(SELECT p_name FROM product WHERE p_id=p.p_parent_id) p_parent_na' at line 1 [SQL]select from (SELECT *,(SELECT p_name FROM product WHERE p_id=p.p_parent_id) p_parent_name FROM product p WHERE p_parent_id>0) t_ where p_id='' limit 0,1 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 'from (SELECT *,(SELECT p_name FROM product WHERE p_id=p.p_parent_id) p_parent_na' at line 1 [SQL]select from (SELECT *,(SELECT p_name FROM product WHERE p_id=p.p_parent_id) p_parent_name FROM product p WHERE p_parent_id>0) t_ where p_id='' limit 0,1 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 'from (SELECT *,(SELECT p_name FROM product WHERE p_id=p.p_parent_id) p_parent_na' at line 1 [SQL]select from (SELECT *,(SELECT p_name FROM product WHERE p_id=p.p_parent_id) p_parent_name FROM product p WHERE p_parent_id>0) t_ where p_id='' limit 0,1 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 'from (SELECT *,(SELECT p_name FROM product WHERE p_id=p.p_parent_id) p_parent_na' at line 1 [SQL]select from (SELECT *,(SELECT p_name FROM product WHERE p_id=p.p_parent_id) p_parent_name FROM product p WHERE p_parent_id>0) t_ where p_id='' limit 0,1 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 'select = NULL, textarea = NULL WHERE p_id=''4''' at line 1 [SQL]UPDATE product SET p_id = '\'4\'', checkbox = NULL, p_parent_id = '\'1\'', p_name = '\'test\'', select = NULL, textarea = NULL WHERE p_id=''4'' 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 'select = NULL, textarea = NULL WHERE p_id='4'' at line 1 [SQL]UPDATE product SET p_id = '4', checkbox = NULL, p_parent_id = '1', p_name = 'test', select = NULL, textarea = NULL WHERE p_id='4' 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 'select = NULL, textarea = NULL WHERE p_id='4'' at line 1 [SQL]UPDATE product SET p_id = '4', checkbox = NULL, p_parent_id = '2', p_name = 'test', select = NULL, textarea = NULL WHERE p_id='4' 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 'select = NULL, textarea = NULL WHERE p_id='4'' at line 1 [SQL]UPDATE product SET p_id = '4', checkbox = NULL, p_parent_id = '2', p_name = 'test', select = NULL, textarea = NULL WHERE p_id='4' 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 'select = NULL, textarea = NULL WHERE p_id='4'' at line 1 [SQL]UPDATE product SET p_id = '4', checkbox = NULL, p_parent_id = '2', p_name = 'test', select = NULL, textarea = NULL WHERE p_id='4' SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pname' in 'order clause' [SQL]SELECT *,(SELECT p_name FROM product WHERE p_id=p.p_parent_id) p_parent_name FROM product p WHERE p_parent_id>0 ORDER BY p_parent_name,pname SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pname' in 'order clause' [SQL]SELECT *,(SELECT p_name FROM product WHERE p_id=p.p_parent_id) p_parent_name FROM product p WHERE p_parent_id>0 ORDER BY p_parent_name,pname limit 0,20 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '12' for key 'PRIMARY' [SQL]INSERT INTO product (p_id, p_parent_id, p_name) VALUES ('12', '2', 'A3333') SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '12' for key 'PRIMARY' [SQL]INSERT INTO product (p_id, p_parent_id, p_name) VALUES ('12', '2', 'A3333') SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '12' for key 'PRIMARY' [SQL]INSERT INTO product (p_id, p_parent_id, p_name) VALUES ('12', '2', 'A3333') 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 '(product) where p_id=''' at line 1 [SQL]delete from (product) where p_id='' 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 '(product) where p_id=''' at line 1 [SQL]delete from (product) where p_id=''