title: Error: Integrity constraint violation: 1052 Column
body: <p>why I'm getting this?</p>
  
  <p>Error: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'favorites' in field list is ambiguous</p>
  
  <pre><code>SQL Query: UPDATE `twitter`.`tractions` AS `Traction` LEFT JOIN `twitter`.`profiles` AS `Profile` ON (`Traction`.`profile_id` = `Profile`.`id`) SET `Traction`.`favorites` = `favorites` + 1, `Traction`.`errors` = `errors` + 0 WHERE `Traction`.`profile_id` = 4 AND `Traction`.`date` = '2013-01-11'
  </code></pre>
  
  <p>CakePHP code: </p>
  
  <pre><code>$this-&gt;Traction-&gt;updateAll(array(
                  "Traction.favorites"=&gt;"`favorites` + $favorites",
                  "Traction.errors"=&gt;"`errors` + $errors"
                  ), array(
                  'Traction.profile_id'=&gt;$profile['Profile']['id'],
                  'Traction.date'=&gt;date('Y-m-d')
              ));
  </code></pre>
  
  <p>-- Table structure for table <code>tractions</code></p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `tractions` (
    `id` int(10) NOT NULL auto_increment,
    `date` date default NULL,
    `profile_id` int(10) default NULL,
    `followings` int(10) default '0',
    `unfollowings` int(10) default '0',
    `favorites` int(10) default '0',
    `retweets` int(10) default '0',
    `thanks` int(10) default '0',
    `errors` int(10) default '0',
    PRIMARY KEY  (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
  </code></pre>