Darrell: That's not my query, it's what CakePHP generated for me. I do believe backticks are ok though.
David: Here is my posts_controller.php model (I took it verbatim from http://book.cakephp.org/view/335/Create-a-Posts-Controller): <?php class PostsController extends AppController { var $name = 'Posts'; function index() { $this->set('posts', $this->Post->find('all')); } } ?> Thanks! On Sep 5, 9:07 pm, "David C. Zentgraf" <[EMAIL PROTECTED]> wrote: > Seems to me you're using the wrong syntax in your $this->Model- > >find(***) call. > Can you paste it in here? > > On 6 Sep 2008, at 07:02, 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 -~----------~----~----~----~------~----~------~--~---
