hi
I'm using 1.2 and have a strange problem.
there are three models:
Author
Theme
Post which belongs to Author and Theme
now i want to get the Posts but with recursive =-1.
when i put:
$this->paginate['recursive']=-1;
$items = $this->paginate($this->modelClass,$scope);
i have an error:
SQL Error: 1051: Unknown table 'Theme'
and query looks like this:
Query: SELECT `Post`.*, `Theme`.*, `Author`.*,
`I18n__title`.`content`, `I18n__description`.`content` FROM `posts` AS
`Post` LEFT JOIN `i18n` AS `I18n__title` ON (`Post`.`id` =
`I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Post' AND
`I18n__title`.`field` = 'title') LEFT JOIN `i18n` AS
`I18n__description` ON (`Post`.`id` =
`I18n__description`.`foreign_key` AND `I18n__description`.`model` =
'Post' AND `I18n__description`.`field` = 'description') WHERE
`I18n__title`.`locale` = 'eng' AND `I18n__description`.`locale` =
'eng' ORDER BY `Post`.`place` ASC
the same query i get if i put:
$this->Post->contain();
$t=$this->Post->find('all');
or:
$t=$this->Post->find('all',array('recursive'=>-1));
why does it look for Theme and Author??!!! It shouldn't do so, no?
If I don't mention contain or recursive -> it's ok: it finds all the
data. But if I try to get nice queries just with data that I need, it
doesn't work...
Can anyone help me please?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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
-~----------~----~----~----~------~----~------~--~---
