PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens
<pre><code>$sql = 'INSERT INTO `' . $table_name . '` '
            . '(`day`, `campaign_name`, `campaign_id`, `views`, `CPM`, `cost`, `currency`, `cost_EUR`) VALUES '
            . '(:day, :campaign_name, :campaign_id, :views, :CPM, :cost, :currency, :cost_EUR)';

$this-&gt;_dbi-&gt;execute($sql, array(
            ':day'        =&gt; $day,
            ':campaign_name'      =&gt; $campaignName,
            ':campaign_id'    =&gt; $campaignID,
            ':views'          =&gt; $views,
            ':CPM'        =&gt; $cpm,
            ':cost'     =&gt; $cost_EUR,
            ':currency'       =&gt; 'EUR',
            ':cost_EUR' =&gt; $cost_EUR
));
</code></pre>

<p>As far as I can tell the number of variables do match the number of tokens.
I just can't figure out the error here.</p>