GNOME Bugzilla – Bug 611487
Last Played smart playlist - sqlite error crashes banshee
Last modified: 2010-03-01 22:22:37 UTC
A malformed INSERT statement for the Recently Played playlist is crashing banshee whenever I try to play a song: [Debug 10:17:59.737] Exception executing command: DELETE FROM CoreSmartPlaylistEntries WHERE SmartPlaylistID = 22; INSERT INTO CoreSmartPlaylistEntries (EntryID, SmartPlaylistID, TrackID) SELECT NULL, 22 as SmartPlaylistID, TrackId FROM CoreTracks,CoreArtists,CoreAlbums WHERE CoreArtists.ArtistID = CoreTracks.ArtistID AND CoreAlbums.AlbumID = CoreTracks.AlbumID AND CoreTracks.PrimarySourceID = 1 ORDER BY CoreTracks.LastPlayedStamp DESC, LIMIT 100 Exception in Gtk# callback delegate Note: Applications can use GLib.ExceptionManager.UnhandledException to handle the exception. Mono.Data.Sqlite.SqliteException: Sqlite error near "LIMIT": syntax error at Mono.Data.Sqlite.Sqlite3.Prepare (System.String strSql, Mono.Data.Sqlite.SqliteStatement previous, System.String& strRemain) [0x00000] at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () [0x00000] at GLib.ExceptionManager.RaiseUnhandledException(System.Exception e, Boolean is_terminal) at Gtk.Widget.buttonpressevent_cb(IntPtr widget, IntPtr evnt) at Gtk.Application.gtk_main() at Gtk.Application.Run() at Banshee.Gui.GtkBaseClient.Run() at Banshee.Gui.GtkBaseClient.Startup() at Hyena.Gui.CleanRoomStartup.Startup(Hyena.Gui.StartupInvocationHandler startup) at Banshee.Gui.GtkBaseClient.Startup() at Banshee.Gui.GtkBaseClient.Startup(System.String[] args) at Nereid.Client.Main(System.String[] args) at System.AppDomain.ExecuteAssembly(System.Reflection.Assembly , System.String[] ) at System.AppDomain.ExecuteAssemblyInternal(System.Reflection.Assembly a, System.String[] args) at System.AppDomain.ExecuteAssembly(System.String assemblyFile, System.Security.Policy.Evidence assemblySecurity, System.String[] args) at System.AppDomain.ExecuteAssembly(System.String assemblyFile) at Booter.Booter.BootClient(System.String clientName) at Booter.Booter.Main() The problem appears to be the comma following DESC, since the command itself works just fine in sqlite without the comma.
Thanks for taking the time to report this bug. This particular bug has already been reported into our bug tracking system, but we are happy to tell you that the problem has already been fixed. It should be solved in the next software version. You may want to check for a software upgrade. *** This bug has been marked as a duplicate of bug 611128 ***