title: Unknown column 'value2' in 'field list'
body: <p>I am recieving an error in my Codeigniter Model which is inserting a single row in a MySQL table. Here is a description of the error</p>
  
  <pre><code>A Database Error Occurred
  
  Error Number: 1054
  
  Unknown column 'value2' in 'field list'
  
  INSERT INTO `tablename` (`column1`, `column2`) VALUES (value1, value2)
  
  Filename: path\to\DB_driver.php
  
  Line Number: 330
  </code></pre>
  
  <p>Both the columns are varchar columns.Does anyone know of this error?</p>
  
  <p>The error message is verbatim copy pasted. My Controller code is as follows:</p>
  
  <pre><code>$deviceID=$xmlString-&gt;deviceID;
  $appType=$xmlString-&gt;appType;
  $data = array( 'deviceIdentifier' =&gt; $deviceID, 'installType'=&gt;$appType );
  $this-&gt;device_model-&gt;insert_new_device($data);
  </code></pre>
  
  <p>My model code is as follows </p>
  
  <pre><code>class device_model extends CI_Model {
      function insert_new_device($lData) { 
          $this-&gt;db-&gt;insert('devices', $lData);
          return $this-&gt;db-&gt;insert_id();
      } 
  }
  </code></pre>