mysql - ERROR 1136: Column count doesn't match value count at row 1

Question

I get the Error:

Column count doesn't match value count at row 1.

But I've checked and rechecked my query and everything seems ok:

UPDATE
    table
SET
    col = 'enum(''FOO'',''BAR'')'
WHERE
    col1 = ''
AND
    col2 = 'val2'
AND
    col3 = 3;

I thought the table could have some triggers that were generating the error –I didn't design the system– but I can't find any.

I've found the same error with at least three different tables.

Note. The "enum" on line three is really supposed to be a string, not an enum type.

Answer 1

It could be a few things, but here are two ideas:

-There is a trigger that needs to be changed/removed.

-The value that you are updating the cell to exceeds the column length. Article on this.