Hi Jon,
This part isn't good. Look in GROUP BY, g4 isn't exist in FROM (g3).
I use Doctrine_Pager with the same query and it work.
Thanks
Bertrand
Le 30 sept. 08 à 18:57, Jonathan Wage a écrit :
> SELECT DISTINCT g3.id FROM gallery g3 GROUP BY g4.gallery_id LIMIT 5
> Sep 29 19:48:45 symfony [err] {Doctrine_Connection_Mysql_Exception}
> SQLSTATE[42S22]: Column not found: 1054 Unknown column 'g4.gallery_id'
> in 'group statement'
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" 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/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
