MySQL Error Code: 1054 Unknown column 'field' in 'field list'

mysql sql mysql-error-1054
masha picture masha · Nov 3, 2016 · Viewed 13.9k times · Source

I keep getting

Error Code: 1054 Unknown column 'originalFieldName' in 'field list'

when trying to insert a new record to a table. This still happens even when I am not inserting any value to this problematic column 'originalFieldName'. Renaming the field and ensuring I don't have unprintable characters like suggested in solutions to this question does not help either.

I have since reduced my query to INSERT INTO incoming(receiptDate) VALUES(NOW()); and deleted some fields to remain with below table: table description but this error 1054 keeps popping up

Answer

masha picture masha · Nov 4, 2016

The error was caused by a trigger which was doing a comparison on 'originalFieldName'. I had forgotten to specify it as new.originalFieldName to refer to the newly inserted value in that field and thus MySQL reported it as unknown column.

Related questions

Unknown column in 'field list' error on MySQL Update query

I keep getting MySQL error #1054, when trying to perform this update query: UPDATE MASTER_USER_PROFILE, TRAN_USER_BRANCH SET MASTER_USER_PROFILE.fellow=`y` WHERE MASTER_USER_PROFILE.USER_ID = TRAN_USER_BRANCH.USER_ID AND TRAN_USER_BRANCH.…

Read More
Unknown Column In Where Clause

I have a simple query: SELECT u_name AS user_name FROM users WHERE user_name = "john"; I get Unknown Column 'user_name' in where clause. Can I not refer to 'user_name' in other parts of the statement even …

Read More
Using column alias in WHERE clause of MySQL query produces an error

The query I'm running is as follows, however I'm getting this error: #1054 - Unknown column 'guaranteed_postcode' in 'IN/ALL/ANY subquery' SELECT `users`.`first_name`, `users`.`last_name`, `users`.`email`, SUBSTRING(`locations`.`raw`,-6,4) AS `guaranteed_postcode` FROM `users` …

Read More