Bug #68715 ERROR 1054 (42S22): Unknown column

• Submitted: 19 Mar 2013 9:33
• Modified: 25 Mar 2013 11:28
• Reporter: rajnish kumar
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.6.10
• OS: Linux (rhel 6)
• CPU Architecture: Any
• Tags: ERROR 1054 (42S22): Unknown column

[19 Mar 2013 9:33] rajnish kumar

Description:
HI team,
yesterday i create a table below are desc for it .
desc t1 ;
+--------+-------------+------+-----+---------+----------------+
| Field  | Type        | Null | Key | Default | Extra          |
+--------+-------------+------+-----+---------+----------------+
| id     | int(11)     | NO   | PRI | NULL    | auto_increment |
| value1 | varchar(30) | YES  |     | NULL    |                |
| value2 | varchar(30) | YES  |     | NULL    |                |
| status | char(1)     | YES  |     | NULL    |                |
+--------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
 yesterday every thing is fine ,now when Today I am going to insert a record in table t1 , i got error , below is the details .

mysql> insert into t1 values  (12,"rere",'rere','Y');
ERROR 1054 (42S22): Unknown column 'valu1' in 'field list'

mysql> insert into t1 (value1,value2,status)values ('rere','rere','Y');
ERROR 1054 (42S22): Unknown column 'valu1' in 'field list'
mysql>

mysql> insert into t1 (id,value1,value2,status)values (122,'rere','rere','Y');
ERROR 1054 (42S22): Unknown column 'valu1' in 'field list'

How to repeat:
HI team,
yesterday i create a table below are desc for it .
desc t1 ;
+--------+-------------+------+-----+---------+----------------+
| Field  | Type        | Null | Key | Default | Extra          |
+--------+-------------+------+-----+---------+----------------+
| id     | int(11)     | NO   | PRI | NULL    | auto_increment |
| value1 | varchar(30) | YES  |     | NULL    |                |
| value2 | varchar(30) | YES  |     | NULL    |                |
| status | char(1)     | YES  |     | NULL    |                |
+--------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
 yesterday every thing is fine ,now when Today I am going to insert a record in table t1 , i got error , below is the details .

mysql> insert into t1 values  (12,"rere",'rere','Y');
ERROR 1054 (42S22): Unknown column 'valu1' in 'field list'

mysql> insert into t1 (value1,value2,status)values ('rere','rere','Y');
ERROR 1054 (42S22): Unknown column 'valu1' in 'field list'
mysql>

mysql> insert into t1 (id,value1,value2,status)values (122,'rere','rere','Y');
ERROR 1054 (42S22): Unknown column 'valu1' in 'field list'

[19 Mar 2013 9:36] rajnish kumar

.

[19 Mar 2013 9:38] MySQL Verification Team

Hi!  This is probably no bug.  Check what trigger is malfunctioning on this table?

[25 Mar 2013 11:28] rajnish kumar

Yes, resolved .
Due to trigger this happens.