Code: Select all
*Error in database query: 'SELECT se_num,se_title,se_trigtype,se_trignum FROM ut_special ORDER BY se_num'
1054: Unknown column 'se_trigtype' in 'field list'
Code: Select all
mysql> describe ut_special;
+----------+-----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-----------------------+------+-----+---------+----------------+
| se_num | smallint(5) unsigned | NO | PRI | NULL | auto_increment |
| se_title | varchar(30) | NO | MUL | | |
| se_desc | varchar(175) | NO | | | |
| se_total | mediumint(8) unsigned | NO | | 0 | |
+----------+-----------------------+------+-----+---------+----------------+
Thanks in advice.