It looks like you are trying to left join the statuses table twice!
Enjoy,
John
On Apr 1, 6:18 am, Louie Miranda <lmira...@gmail.com> wrote:
> Hello,
>
> I think there is a problem on my parameter on the controller. Because once
> my other tables has multiple entries, the data on the row is duplicated for
> my main controller.
>
> See my code and parameter and the SQL query cakephp produces.http://bin.cakephp.org/saved/44445
>
> The default for cakephp
>
> 1. *$this->set('pdffiles', $this->paginate());*
> 2.
> 3. ON (`Pdffile`.`statuses_id` = `Statuses`.`id`) LEFT
> JOIN<http://www.php.net/join>`users`
> AS `User`
> 4. --- ON (`Pdffile`.`user_id` = `User`.`id`) LEFT
> JOIN<http://www.php.net/join>`comments`
> AS `Comment`
> 5. ON (`Comment`.`pdffile_id` = `Pdffile`.`id`) LEFT
> JOIN<http://www.php.net/join>`statuses`
> AS `Status`
> 6. *ON (`Status`.`pdffile_id` = `Pdffile`.`id`) WHERE 1 = 1 LIMIT 20*
>
> The modified, under controller
>
> 1. $this->Pdffile->recursive = 0;
> 2. *$parsedConditions['Pdffile.user_id'] = $this->Auth->User('id');*
> 3. $this->paginate['Pdffile'] = array <http://www.php.net/array>(
> 'conditions' => $parsedConditions, 'limit' => '50', 'order' =>
> array<http://www.php.net/array>
> ('Pdffile.timestamp' => 'desc'));
> 4. $this->set('pdffiles', $this->paginate());
> 5.
> 6. ON (`Pdffile`.`statuses_id` = `Statuses`.`id`) LEFT
> JOIN<http://www.php.net/join>`users`
> AS `User`
> 7. --- ON (`Pdffile`.`user_id` = `User`.`id`) LEFT
> JOIN<http://www.php.net/join>`comments`
> AS `Comment`
> 8. ON (`Comment`.`pdffile_id` = `Pdffile`.`id`) LEFT
> JOIN<http://www.php.net/join>`statuses`
> AS `Status`
> 9. ON (`Status`.`pdffile_id` = `Pdffile`.`id`) WHERE `Pdffile`.`user_id`
> = 17
> 10. ORDER BY `Pdffile`.`timestamp` desc LIMIT 50
>
> Missing where 1 = 1?
>
> How could this be fixed?
> --
> Louie Miranda (lmira...@gmail.com)http://www.louiemiranda.net
>
> Quality Web Hosting -www.axishift.com
> Pinoy Web Hosting, Web Hosting Philippines
--~--~---------~--~----~------------~-------~--~----~
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 cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---