Friday, February 20, 2015

Problem increment field


$this->Word->updateAll(array('Word.count' => 'Word.count + 1'), array( 'Word.id' => $word['Word']['id']));

Database Error

Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Word.word_id' in 'on clause'

SQL Query: UPDATE `dictionary2`.`words` AS `Word` LEFT JOIN `dictionary2`.`languages` AS `Language` ON (`Word`.`language_id` = `Language`.`id`) LEFT JOIN `dictionary2`.`flags` AS `Flag` ON (`Word`.`flag_id` = `Flag`.`id`) LEFT JOIN `dictionary2`.`users` AS `User` ON (`Word`.`word_id` = `User`.`id`) LEFT JOIN `dictionary2`.`sentiments` AS `Sentiment` ON (`Word`.`sentiment_id` = `Sentiment`.`id`) SET `Word`.`count` = `Words`.count + 1 WHERE `Word`.`id` = '54e6c25c-cef4-4e72-b764-10d400089a90'

Notice: If you want to customize this error message, create app\View\Errors\pdo_error.ctp

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.

No comments: