SQLSTATE[42S22]: Column not found: 1054 Unknown column 's_object_text' in 'where clause'
[SQL]SELECT *,(SELECT s_name FROM `subject` WHERE s_id=s.s_parent_id) s_parent FROM `subject` s WHERE 1=1 AND s_object_text like '%部门%' ORDER BY s_lft asc
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's_object_text' in 'where clause'
[SQL]SELECT *,(SELECT s_name FROM `subject` WHERE s_id=s.s_parent_id) s_parent FROM `subject` s WHERE 1=1 AND s_object_text like '%部门%' ORDER BY s_lft asc limit 0,10000
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's_object_text' in 'where clause'
[SQL]SELECT *,(SELECT s_name FROM `subject` WHERE s_id=s.s_parent_id) s_parent FROM `subject` s WHERE 1=1 AND s_name like '%b1%' AND s_object_text like '%部门%' ORDER BY s_lft asc
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's_object_text' in 'where clause'
[SQL]SELECT *,(SELECT s_name FROM `subject` WHERE s_id=s.s_parent_id) s_parent FROM `subject` s WHERE 1=1 AND s_name like '%b1%' AND s_object_text like '%部门%' ORDER BY s_lft asc limit 0,10000
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 's_object' cannot be null
[SQL]INSERT INTO subject (s_id, s_parent_id, s_name, s_dict, s_object, s_lft, s_rgt, s_level, create_time, update_time) VALUES (NULL, '1', 'A3', 'c', NULL, '6', '7', '1', '2020-03-19 13:12:05', '2020-03-19 13:12:05')
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'update_time' in 'field list'
[SQL]UPDATE bank SET b_id = '1', b_name = '现金帐号', b_account = NULL, b_remark = NULL, update_time = '2020-03-19 14:07:12' WHERE b_id='1'
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'update_time' in 'field list'
[SQL]UPDATE bank SET b_id = '1', b_name = '现金帐号', b_account = NULL, b_remark = NULL, update_time = '2020-03-19 14:07:21' WHERE b_id='1'
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'update_time' in 'field list'
[SQL]UPDATE product SET p_id = '1029', p_parent_id = '1', p_name = '专版网站', update_time = '2020-03-19 14:08:21' WHERE p_id='1029'
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's_name' in 'field list'
[SQL]SELECT *,(SELECT s_name FROM `object` WHERE o_id=o.o_parent_id) o_parent FROM `object` o WHERE 1=1 ORDER BY o_lft asc
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's_name' in 'field list'
[SQL]SELECT *,(SELECT s_name FROM `object` WHERE o_id=o.o_parent_id) o_parent FROM `object` o WHERE 1=1 ORDER BY o_lft asc limit 0,10000
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's_object' in 'field list'
[SQL]UPDATE object SET o_id = '4', o_parent_id = '1', o_name = 'A2', s_object = '0', update_time = '2020-03-19 17:52:35' WHERE o_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 'ORDER BY o_lft asc' at line 1
[SQL]SELECT *,(SELECT o_name FROM `object` WHERE o_id=o.o_parent_id) o_parent FROM `object` o WHERE 1=1 AND o_lft>0 AND o_rgt< ORDER BY o_lft asc
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 o_lft asc limit 0,10000' at line 1
[SQL]SELECT *,(SELECT o_name FROM `object` WHERE o_id=o.o_parent_id) o_parent FROM `object` o WHERE 1=1 AND o_lft>0 AND o_rgt< ORDER BY o_lft asc limit 0,10000