Re: cant find the problem: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE pageID = '1'' at line 1

Hi there,

I think there's one extra, spurious comma in the UPDATE after :pageText (right before WHERE as the SQL error message tells you):

On Saturday, July 5, 2014 3:52:34 PM UTC+2, Pascal Houtenbos wrote:

$stmt = $db->prepare('UPDATE page SET pageTitle = :pageTitle, pageText = :pageText, WHERE pageID = :pageID') ;

 

--
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.