HELP, Controller displaying multiple duplicate rows

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 `users` AS `User`
4. --- ON (`Pdffile`.`user_id` = `User`.`id`) LEFT JOIN `comments` AS `Comment`
5. ON (`Comment`.`pdffile_id` = `Pdffile`.`id`) LEFT 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('conditions' => $parsedConditions, 'limit' => '50', 'order' => array('Pdffile.timestamp' => 'desc'));
4. $this->set('pdffiles', $this->paginate());
5.  
6. ON (`Pdffile`.`statuses_id` = `Statuses`.`id`) LEFT JOIN `users` AS `User`
7. --- ON (`Pdffile`.`user_id` = `User`.`id`) LEFT JOIN `comments` AS `Comment`
8. ON (`Comment`.`pdffile_id` = `Pdffile`.`id`) LEFT 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 (lmiranda@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
-~----------~----~----~----~------~----~------~--~---