sonata-project/SonataDoctrineORMAdminBundle — pull request #359 by silvioq (2014-06-06 02:25:13+00:00)
Title: Fix another order by bug (pgsql)

Without this reset, a sonata sandbox launchs this exception ....

An exception has been thrown during the rendering of a template ("An exception occurred while executing 'SELECT DISTINCT n0_.id AS id0 FROM news__post n0_ LEFT JOIN news__post_tag n2_ ON n0_.id = n2_.post_id LEFT JOIN classification__tag c1_ ON c1_.id = n2_.tag_id LEFT JOIN fos_user_user f3_ ON n0_.author_id = f3_.id ORDER BY n0_.publication_date_start DESC':

SQLSTATE[42P10]: Invalid column reference: 7 ERROR: para SELECT DISTINCT, las expresiones en ORDER BY deben aparecer en la lista de resultados
LINE 1: ..._user_user f3_ ON n0_.author_id = f3_.id ORDER BY n0_.public...
^") in SonataNewsBundle:Block:recent_posts.html.twig at line 22.