title: Error HY093 with a MySQL Insert PDO Request
body: <p>After reading all others questions about the HY093, I open this one to figure out why I've got this message too.</p>
  
  <p>Here is my table :
  <img src="https://i.stack.imgur.com/I24XG.jpg" alt="Table PhpMyAdmin screenshot"></p>
  
  <p>And here is my request :
  (Where $conn is my PDO connection) </p>
  
  <pre><code>$sql = $conn-&gt;prepare("INSERT INTO Sites (Email,URL,Title,Description,PageRank,Rewrite,MetaDesc,Origin,BackLink,nbBackLink,RssTitle,RssAddress,SocAddress,SocPostalCode,SocCity,SocCountry,SocTel,Offer,Status,nbHit)
                           VALUES (:Email,:URL,:Title,:Description,:PageRank,:Rewrite,:MetaDesc,:Origin,:BackLink,0,:RssTitle,:RssAddress,:SocAddress,:SocPostalCode,:SocCity,:SocCountry,:SocTel,:Offer,:Status,0)");
  $sql-&gt;setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
  
  $pageRank = new GooglePageRank($_POST["site_url"]);
  
  $sql-&gt;bindParam(":Email",$_POST["submail"],PDO::PARAM_STR);
  $sql-&gt;bindParam(":URL",$_POST["site_url"],PDO::PARAM_STR);
  $sql-&gt;bindParam(":Title",$_POST["site_title"],PDO::PARAM_STR);
  $sql-&gt;bindParam(":Description",$_POST["site_desc"],PDO::PARAM_STR);
  $sql-&gt;bindParam(":PageRank",$pageRank-&gt;PageRank,PDO::PARAM_INT);
  $sql-&gt;bindParam(":Rewrite",stringToRewrite($_POST["site_title"]),PDO::PARAM_STR);
  $sql-&gt;bindParam(":MetaDesc",$_POST["site_desc"],PDO::PARAM_STR);
  $sql-&gt;bindParam(":Origin",$_POST["site_country"],PDO::PARAM_STR);
  $sql-&gt;bindParam(":BackLink",$_POST["site_backlink"],PDO::PARAM_STR);
  $sql-&gt;bindParam(":RssTitle",$_POST["site_rss_title"],PDO::PARAM_STR);
  $sql-&gt;bindParam(":RssAddress",$_POST["site_rss_addr"],PDO::PARAM_STR);
  $sql-&gt;bindParam(":SocAddress",$_POST["soc_addr"],PDO::PARAM_STR);
  $sql-&gt;bindParam(":SocPostalCode",$_POST["soc_cp"],PDO::PARAM_STR);
  $sql-&gt;bindParam(":SocCity",$_POST["soc_city"],PDO::PARAM_STR);
  $sql-&gt;bindParam(":SocCoutry",$_POST["soc_pays"],PDO::PARAM_STR);
  $sql-&gt;bindParam(":SocTel",$_POST["soc_tel"],PDO::PARAM_STR);
  
  $offer = $_POST["offer"] == "premium" ? 1 : 0;
  $status = $_POST["offer"] == "premium" ? 2 : 0;
  
  $sql-&gt;bindParam(":Offer",$offer,PDO::PARAM_INT);
  $sql-&gt;bindParam(":Status",$status,PDO::PARAM_INT);
  
  $sql-&gt;execute();
  var_dump($sql-&gt;errorInfo());
  var_dump($sql-&gt;errorCode());
  </code></pre>
  
  <p>Any idea why I keep have an HY093 error?</p>