New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Error client_desktop using postgresql #46

Open

GoogleCodeExporter opened this issue Jul 15, 2015 · 1 comment

Labels

auto-migrated Priority-Medium Type-Defect

GoogleCodeExporter commented Jul 15, 2015

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

The text was updated successfully, but these errors were encountered:

Author

GoogleCodeExporter commented Jul 15, 2015

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

Changed state: Accepted

GoogleCodeExporter added Priority-Medium Type-Defect auto-migrated labels

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment