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