title: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1
body: <p>I see a lot of people having this issue but all the answers always point to the count not matching the value count but they both have 9 items so not sure why its giving me such an error? Guess i've missed the obvious? </p>
  
  <pre><code>    $sth = "INSERT INTO `docs` (title, ref, rev, content, owner, contract_id, cat_id, created, updated)
                  VALUES (:title, :ref, :rev, :content, :owner, :contract :cat, NOW(), NOW())";
      $q = $conn-&gt;prepare($sth);
      $q-&gt;execute(array(':title'=&gt;$title, ':ref'=&gt;$ref, ':rev'=&gt;$rev, ':content'=&gt;$contnet, ':owner'=&gt;$owner, ':contract'=&gt;$contract, ':cat'=&gt;$cat));
  </code></pre>