What it sounds like is that he's trying to use the updated $this-
>Model->find('all'.....) syntax from Cake 1.2 in the older version.
Best bet is to either upgrade, or use the old $this->Model-
>findAll($conditions) syntax.
Steve
On Apr 15, 8:44 am, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
> "... where all ..." doesn't look right to me.
>
> What does your find-statement look like?
> Are you adding "where" to your condition in Cake? It should just be
> $this->Model->find('title = '.$title) or something similar.
> What does the MySQL error say? (can be seen in Cakes debug message or
> just run that query "manually" to get the error)
>
> /Martin
>
> On Apr 15, 6:26 am, developer01 <[EMAIL PROTECTED]> wrote:
>
> > New to Cake and hoping someone can answer this.
>
> > I am running into all bunch of sql syntac error 1064 for the simplest
> > of queries. I'm running MySql 5.0.51a, php 5.2.5, both installed via
> > XAMPP, Mac 10.5. A lot of the queries are generated by cake
> > internally so it doesn't make sense to rewrite anything there.
>
> > What MySql versions are best with my cake version of 1.1.9.6305?
>
> > For example, this simple sql does not work:
>
> > SELECT `Post`.`id`, `Post`.`title`, `Post`.`body`, `Post`.`created`,
> > `Post`.`modified` FROM `posts` AS `Post` where all LIMIT 1
>
> > The DB table posts is indeed there and the fields all exist and there
> > are values. Cake is producing this code, not me, and it seems to look
> > legit.
>
> > Am I missing something here?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
