CODEWITHSUNDEEP
phpmysql
CalebB
CalebB

Reputation: 607

unable to modify specific column in mysql table

I seem to be having an issue when updating records on a specific table.

For reference here is an example of the query that throws an error:

UPDATE `dbname`.`tblname` SET `CustomerID` = '543' WHERE `tblname`.`Issue_ID` = 440

I am able to insert, delete and query rows, as well as update other columns however whenever trying to update the CustomerID field (int, non-null) it throws an error saying:

#1054 - Unknown column 'Revision' in 'field list'

I have all rights to both the database and table however while trying to update the CustomerID column on any rows, ever when Revision isn't even in the query I get the same error.

I looked around a great deal into the issue using a regex in my php code to remove all non-printable characters however even when running the query from phpMyAdmin the same error is thrown.

If anyone has insight into this error it would be greatly appreciated.

Table description:

enter image description here

Upvotes: 4

Views: 398

Answers (1)

BuvinJ
BuvinJ

Reputation: 11046

You may possibly encounter this if you have an update trigger firing off which is referencing a column that does not exist. May be the offending trigger is not even trying to read/write to this table! As such, that column may not exist where it is trying to reference it. Further, you could kick off a cascade of such triggers, and have this buried more than one layer deep.

To show triggers:

http://dev.mysql.com/doc/refman/5.7/en/show-triggers.html

To modify them:

http://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html

Upvotes: 3

Related Questions