title: ERROR 1136: Column count doesn't match value count at row 1
body: <p>I get the Error: </p>
  
  <pre><code>Column count doesn't match value count at row 1.
  </code></pre>
  
  <p>But I've checked and rechecked my query and everything seems ok:</p>
  
  <pre><code>UPDATE
      table
  SET
      col = 'enum(''FOO'',''BAR'')'
  WHERE
      col1 = ''
  AND
      col2 = 'val2'
  AND
      col3 = 3;
  </code></pre>
  
  <p>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.  </p>
  
  <p>I've found the same error with at least three different tables.  </p>
  
  <p>Note. The "enum" on line three is really supposed to be a string, not an enum type.</p>