Remove the backticks ( ` ), you can replace it with a single parenthesis ( ' ) if necessary, but it should only be necessary if a field name is two words like 'book title'.
Ryan wrote: > I am just getting started with Cake. Impressed so far! Trying out the > blog tutorial from the Cookbook (http://book.cakephp.org/view/219/ > Blog) and getting this error. > > Query: SELECT `Post`.`id`, `Post`.`title`, `Post`.`body`, > `Post`.`created`, `Post`.`modified` FROM `posts` AS `Post` WHERE all > LIMIT 1 > Warning: SQL Error: 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 'all LIMIT 1' at line 1 in /web/php/balistik/cake/ > libs/model/datasources/dbo_source.php on line 440 > > I am running MySQL 5.0.45. I thought Cake supported MySQL 4+ so seems > like I should be ok. > > Thanks in advance for the help. > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
