Open andrzej-bieniek opened 13 years ago
Hi,
Crash is only with sqlite3, mysql is ok. Select 'Artists' from menu then a specific artist - it crashes with:
params (2,) self <django.db.backends.sqlite3.base.SQLiteCursorWrapper object at 0xa95dedc> e OperationalError('near "1": syntax error',) query u'SELECT ((SELECT count(_) FROM playlist_oldplaylistentry WHERE (playlist_oldplaylistentry.song_id = playlist_song.id) AND (playlist_oldplaylistentry.playtime-0 > NOW()-INTERVAL 1 HOUR))) AS "recently_played", "playlist_song"."id", "playlist_song"."title", "playlist_song"."artist_id", "playlist_song"."album_id", "playlist_song"."composer", "playlist_song"."lyricist", "playlist_song"."remixer", "playlist_song"."genre", "playlist_song"."track", "playlist_song"."length", "playlist_song"."bitrate", "playlist_song"."sha_hash", "playlist_song"."add_date", "playlist_song"."format", "playlist_song"."uploader_id", "playlist_song"."category", "playlist_song"."banned", "playlist_song"."banreason", "playlist_song"."unban_adds", "playlist_song"."location_id", "playlist_song"."avgscore", "playlist_song"."voteno", COUNT("playlist_playlistentry"."id") AS "on_playlist", "playlist_artist"."id", "playlist_artist"."name", "playlist_artist"."sort_name", "playlist_album"."id", "playlist_album"."name" FROM "playlist_song" INNER JOIN "playlist_artist" ON ("playlist_song"."artist_id" = "playlist_artist"."id") LEFT OUTER JOIN "playlist_album" ON ("playlist_song"."album_id" = "playlist_album"."id") LEFT OUTER JOIN "playlist_playlistentry" ON ("playlist_song"."id" = "playlist_playlistentry"."song_id") WHERE "playlist_song"."artist_id" = ? GROUP BY "playlist_song"."id", "playlist_song"."title", "playlist_song"."artist_id", "playlist_song"."album_id", "playlist_song"."composer", "playlist_song"."lyricist", "playlist_song"."remixer", "playlist_song"."genre", "playlist_song"."track", "playlist_song"."length", "playlist_song"."bitrate", "playlist_song"."sha_hash", "playlist_song"."add_date", "playlist_song"."format", "playlist_song"."uploader_id", "playlist_song"."category", "playlist_song"."banned", "playlist_song"."banreason", "playlist_song"."unban_adds", "playlist_song"."location_id", "playlist_song"."avgscore", "playlist_song"."voteno", "playlist_song"."id", "playlist_song"."title", "playlist_song"."artist_id", "playlist_song"."album_id", "playlist_song"."composer", "playlist_song"."lyricist", "playlist_song"."remixer", "playlist_song"."genre", "playlist_song"."track", "playlist_song"."length", "playlist_song"."bitrate", "playlist_song"."sha_hash", "playlist_song"."add_date", "playlist_song"."format", "playlist_song"."uploader_id", "playlist_song"."category", "playlist_song"."banned", "playlist_song"."banreason", "playlist_song"."unban_adds", "playlist_song"."location_id", "playlist_song"."avgscore", "playlist_song"."voteno", "playlist_artist"."id", "playlist_artist"."name", "playlist_artist"."sort_name", "playlist_album"."id", "playlistalbum"."name", ((SELECT count() FROM playlist_oldplaylistentry WHERE (playlist_oldplaylistentry.song_id = playlist_song.id) AND (playlist_oldplaylistentry.playtime-0 > NOW()-INTERVAL 1 HOUR))) ORDER BY "playlist_album"."name" ASC, "playlist_song"."track" ASC'
Hi,
Crash is only with sqlite3, mysql is ok. Select 'Artists' from menu then a specific artist - it crashes with:
params (2,) self <django.db.backends.sqlite3.base.SQLiteCursorWrapper object at 0xa95dedc> e OperationalError('near "1": syntax error',) query u'SELECT ((SELECT count(_) FROM playlist_oldplaylistentry WHERE (playlist_oldplaylistentry.song_id = playlist_song.id) AND (playlist_oldplaylistentry.playtime-0 > NOW()-INTERVAL 1 HOUR))) AS "recently_played", "playlist_song"."id", "playlist_song"."title", "playlist_song"."artist_id", "playlist_song"."album_id", "playlist_song"."composer", "playlist_song"."lyricist", "playlist_song"."remixer", "playlist_song"."genre", "playlist_song"."track", "playlist_song"."length", "playlist_song"."bitrate", "playlist_song"."sha_hash", "playlist_song"."add_date", "playlist_song"."format", "playlist_song"."uploader_id", "playlist_song"."category", "playlist_song"."banned", "playlist_song"."banreason", "playlist_song"."unban_adds", "playlist_song"."location_id", "playlist_song"."avgscore", "playlist_song"."voteno", COUNT("playlist_playlistentry"."id") AS "on_playlist", "playlist_artist"."id", "playlist_artist"."name", "playlist_artist"."sort_name", "playlist_album"."id", "playlist_album"."name" FROM "playlist_song" INNER JOIN "playlist_artist" ON ("playlist_song"."artist_id" = "playlist_artist"."id") LEFT OUTER JOIN "playlist_album" ON ("playlist_song"."album_id" = "playlist_album"."id") LEFT OUTER JOIN "playlist_playlistentry" ON ("playlist_song"."id" = "playlist_playlistentry"."song_id") WHERE "playlist_song"."artist_id" = ? GROUP BY "playlist_song"."id", "playlist_song"."title", "playlist_song"."artist_id", "playlist_song"."album_id", "playlist_song"."composer", "playlist_song"."lyricist", "playlist_song"."remixer", "playlist_song"."genre", "playlist_song"."track", "playlist_song"."length", "playlist_song"."bitrate", "playlist_song"."sha_hash", "playlist_song"."add_date", "playlist_song"."format", "playlist_song"."uploader_id", "playlist_song"."category", "playlist_song"."banned", "playlist_song"."banreason", "playlist_song"."unban_adds", "playlist_song"."location_id", "playlist_song"."avgscore", "playlist_song"."voteno", "playlist_song"."id", "playlist_song"."title", "playlist_song"."artist_id", "playlist_song"."album_id", "playlist_song"."composer", "playlist_song"."lyricist", "playlist_song"."remixer", "playlist_song"."genre", "playlist_song"."track", "playlist_song"."length", "playlist_song"."bitrate", "playlist_song"."sha_hash", "playlist_song"."add_date", "playlist_song"."format", "playlist_song"."uploader_id", "playlist_song"."category", "playlist_song"."banned", "playlist_song"."banreason", "playlist_song"."unban_adds", "playlist_song"."location_id", "playlist_song"."avgscore", "playlist_song"."voteno", "playlist_artist"."id", "playlist_artist"."name", "playlist_artist"."sort_name", "playlist_album"."id", "playlistalbum"."name", ((SELECT count() FROM playlist_oldplaylistentry WHERE (playlist_oldplaylistentry.song_id = playlist_song.id) AND (playlist_oldplaylistentry.playtime-0 > NOW()-INTERVAL 1 HOUR))) ORDER BY "playlist_album"."name" ASC, "playlist_song"."track" ASC'