search

eddylecca / streeme

Automatically exported from code.google.com/p/streeme
MIT License
0 stars 0 forks source link

Error client_desktop using postgresql #46

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
If you are using postgresql, the acces to the desktop player will produce a SQL 
error ("field blabla must appear in the GROUP BY clause or be ...").

You can fix it with MAX aggregate fonction. So yo have to modify the 
lib/model/doctrine/SongGenresTable.class.php and replace at line 19 :

      ->select( 'sg.genre_id, g.name' )

by 

      ->select( 'MAX(sg.genre_id), MAX(g.name)' )

Original issue reported on code.google.com by marminth...@gmail.com on 5 Mar 2012 at 6:24

GoogleCodeExporter commented 9 years ago 
Good find. I'll probably patch this in the new data model in the next big 
release.

Original comment by chaffn...@gmail.com on 6 Mar 2012 at 4:32