Thanks guys.
There seems to be two version of the Blog tutorial floating around and
I was looking at the 1.2 version as opposed to the
1.1.x. When I get home today I'll upgrade and see if I run into the
same issue.
But that being said...i'm surprsied 1.2 is creating SQL that does not
run in MySQL properly. Shouldn't cake be producing rather similar SQL
from 1.1 to 1.2? It's a simple query after all.
Or are there strict version compatibilities between Cake versions and
MySQL versions? Is that documented?
I
On Apr 15, 4:37 am, Stephen Orr <[EMAIL PROTECTED]> wrote:
> 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 theMySQLerror 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 sqlsyntacerror 1064 for the simplest
> > > of queries. I'm runningMySql5.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.
>
> > > WhatMySqlversions 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 cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
