title: Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY093]'
body: <p>for some reason i keep getting the 'SQLSTATE[HY093] error. the solution must be simple but im just no seeing it. The error says that it is in line 83 (included below) of ControllerStore.php and on line 55 of store_update.php (also included below)</p>
  
  <p><strong>ControllerStore.php</strong></p>
  
  <pre><code>public function updateStore($itm) 
  {
      $stmt = $this-&gt;pdo-&gt;prepare('UPDATE tbl_storefinder_stores
  
                                      SET store_name = :store_name,                                             
                                          store_desc = :store_desc, 
                                          lat = :lat, 
                                          lon = :lon,                                                                                     
                                          phone_no = :phone_no, 
                                          email = :email,                                              
                                          category_id = :category_id, 
                                          created_at = :created_at, 
                                          updated_at = :updated_at,
                                          is_deleted = :is_deleted,                                  
  
                                          idade = :idade,
                                          peso = :peso,
                                          oral = :oral,
                                          anal = :anal,
                                          dom = :dom,
                                          eles = :eles,
                                          elas = :elas,
                                          casais = :casais,
                                          acessorios = :acessorios,
                                          eventos = :eventos,
                                          viagens = :viagens,
                                          idiomas = :idiomas,
                                          horarios = :horarios,
                                          hora = :hora,
                                          locais = :locais,
                                          kiss = :kiss
  
  
                                      WHERE store_id = :store_id');
  
      $result = $stmt-&gt;execute(
                          array('store_name' =&gt; $itm-&gt;store_name,
  
                                  'store_desc' =&gt; $itm-&gt;store_desc,
                                  'lat' =&gt; $itm-&gt;lat,
                                  'lon' =&gt; $itm-&gt;lon,                                                                 
                                  'phone_no' =&gt; $itm-&gt;phone_no,
                                  'email' =&gt; $itm-&gt;email,                                    
                                  'category_id' =&gt; $itm-&gt;category_id,
                                  'created_at' =&gt; $itm-&gt;created_at,
                                  'updated_at' =&gt; $itm-&gt;updated_at,  
                                  'is_deleted' =&gt; $itm-&gt;is_deleted,                                  
                                  'idade' =&gt; $itm-&gt;idade, 
                                  'peso' =&gt; $itm-&gt;peso, 
                                  'oral' =&gt; $itm-&gt;oral, 
                                  'anal' =&gt; $itm-&gt;anal, 
                                  'dom' =&gt; $itm-&gt;dom, 
                                  'eles' =&gt; $itm-&gt;eles, 
                                  'elas' =&gt; $itm-&gt;elas, 
                                  'casais' =&gt; $itm-&gt;casais, 
                                  'acessorios' =&gt; $itm-&gt;acessorios, 
                                  'eventos' =&gt; $itm-&gt;eventos, 
                                  'viagens' =&gt; $itm-&gt;viagens, 
                                  'idiomas' =&gt; $itm-&gt;idiomas, 
                                  'horarios' =&gt; $itm-&gt;horarios, 
                                  'hora' =&gt; $itm-&gt;hora, 
                                  'locais' =&gt; $itm-&gt;locais, 
                                  'kiss' =&gt; $itm-&gt;kiss
  
                                  ));
  
      return $result ? true : false;
  
  }
  </code></pre>
  
  <p><strong>store_update.php</strong></p>
  
  <pre><code>if($store_id != null) {
  
      $store = $controller-&gt;getStoreByStoreId($store_id);
  
      if( isset($_POST['submit']) ) {
  
           $itm = new Store();
  $itm-&gt;store_name = htmlspecialchars(trim(strip_tags($_POST['store_name'])));
  $store_desc = preg_replace('~[\r\n]+~', '', $_POST['store_desc']);
  $itm-&gt;store_desc = htmlspecialchars(trim(strip_tags($store_desc)));    
  $itm-&gt;lat = trim(strip_tags($_POST['lat']));
  $itm-&gt;lon = htmlspecialchars(trim(strip_tags($_POST['lon'])), ENT_QUOTES);
  $itm-&gt;created_at = time();      
  $itm-&gt;phone_no = htmlspecialchars(trim(strip_tags($_POST['phone_no'])), ENT_QUOTES);
  $itm-&gt;email = trim(strip_tags($_POST['email']));
  $itm-&gt;category_id = trim(strip_tags($_POST['category_id']));
  $itm-&gt;updated_at = time();    
  $itm-&gt;is_deleted = trim(strip_tags($_POST['is_deleted']));
  $itm-&gt;idade = trim(strip_tags($_POST['idade']));
  $itm-&gt;peso = trim(strip_tags($_POST['peso']));
  $itm-&gt;oral = trim(strip_tags($_POST['oral']));
  $itm-&gt;anal = trim(strip_tags($_POST['anal']));
  $itm-&gt;dom = trim(strip_tags($_POST['dom']));
  $itm-&gt;eles = trim(strip_tags($_POST['eles']));
  $itm-&gt;elas = trim(strip_tags($_POST['elas']));
  $itm-&gt;casais = trim(strip_tags($_POST['casais']));
  $itm-&gt;acessorios = trim(strip_tags($_POST['acessorios']));
  $itm-&gt;eventos = trim(strip_tags($_POST['eventos']));
  $itm-&gt;viagens = trim(strip_tags($_POST['viagens']));
  $itm-&gt;idiomas = trim(strip_tags($_POST['idiomas']));
  $itm-&gt;horarios = trim(strip_tags($_POST['horarios']));
  $itm-&gt;hora = trim(strip_tags($_POST['hora']));
  $itm-&gt;locais = trim(strip_tags($_POST['locais']));
  $itm-&gt;kiss = trim(strip_tags($_POST['kiss']));
  
  
          $controller-&gt;updateStore($itm);
          echo "&lt;script type='text/javascript'&gt;location.href='stores.php';  &lt;/script&gt;";
        }
    }
    else {
        echo "&lt;script type='text/javascript'&gt;location.href='403.php';&lt;/script&gt;";
    }
  </code></pre>