I am not sure why the query is failing. If you have that column in
gallery_picture then it should be fine. Have you played with the query in
mysql directly and tried to figure out what is wrong with it? Maybe that
group by column needs to be in the select?
- Jon
On Mon, Sep 29, 2008 at 12:50 PM, Bertrand Zuchuat
<[EMAIL PROTECTED]>wrote:
>
> The log:
>
> Sep 29 19:48:45 symfony [info] {sfDoctrine Query} executeQuery :
> SELECT COUNT(DISTINCT g.id) AS num_results, COUNT(g2.gallery_id) AS
> g2__0 FROM gallery g LEFT JOIN gallery_picture g2 ON g.id =
> g2.gallery_id GROUP BY g2.gallery_id
> Sep 29 19:48:45 symfony [info] {sfDoctrine Query} executeQuery :
> 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'
>
> Thanks
>
> Bertrand
>
> Le 29 sept. 08 à 19:34, Jonathan Wage a écrit :
>
> > You will need to use mysql query logging or the doctrine connection
> > profiler to view the sql it executes.
>
>
> >
>
--
Jonathan H. Wage
Open Source Software Developer & Evangelist
http://www.jwage.com
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
