错误1136:列计数与第1行的值计数不匹配

我收到错误消息:

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.