What version of Cake are you using? The find('all', ...) syntax is
somewhat of a recent development. It certainly wasn't in Cake 1.1.
Seems to me you are using a version of Cake that expects the first
find() parameter to be the condition, hence it puts whatever you put
in there right after 'WHERE'. Look at the documentation for older
versions, or, better, get a recent version from the repository. Even
compared to the 1.2 RC2 release there are a lot new goodies in there
by now. See https://trac.cakephp.org :
svn co https://svn.cakephp.org/repo/branches/1.2.x.x /path/to/save
On 6 Sep 2008, at 12:23, Ryan wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
