GNOME Bugzilla – Bug 611128
Exception executing command: DELETE FROM CoreSmartPlaylistEntries
Last modified: 2010-03-09 01:37:39 UTC
just migrated from 1.5.3 to 1.5.4 and after playing one song banshe is crashing. Run with --debug options gives: [Debug 00:20:35.858] Exception executing command: DELETE FROM CoreSmartPlaylistEntries WHERE SmartPlaylistID = 21; INSERT INTO CoreSmartPlaylistEntries (EntryID, SmartPlaylistID, TrackID) SELECT NULL, 21 as SmartPlaylistID, TrackId FROM CoreTracks,CoreArtists,CoreAlbums WHERE CoreArtists.ArtistID = CoreTracks.ArtistID AND CoreAlbums.AlbumID = CoreTracks.AlbumID AND CoreTracks.PrimarySourceID = 1 AND ((CoreTracks.PlayCount > 5 AND CoreTracks.PlayCount IS NOT NULL)) ORDER BY CoreTracks.Rating DESC, LIMIT 1000 Unhandled 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] note: there is coma after "CoreTracks.Rating DESC". Don't know sqlite sql dialect but this is probably wrong
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.
*** Bug 611377 has been marked as a duplicate of this bug. ***
*** Bug 611506 has been marked as a duplicate of this bug. ***
*** Bug 611509 has been marked as a duplicate of this bug. ***
*** Bug 611487 has been marked as a duplicate of this bug. ***
Is there a chance for a quick "1.5.4.1" release with the fix, or an update to Banshee PPA?
*** Bug 611530 has been marked as a duplicate of this bug. ***
(In reply to comment #6) > Is there a chance for a quick "1.5.4.1" release with the fix, or an update to > Banshee PPA? We are releasing 1.5.5 in about a week. You can try to ask hyperair on IRC.
*** Bug 611640 has been marked as a duplicate of this bug. ***
*** Bug 611864 has been marked as a duplicate of this bug. ***
Banshee is unusable in the meantime. That sucks. Couldn't you push a quick fix as the other reporter suggested?
(In reply to comment #11) > Banshee is unusable in the meantime. That sucks. Couldn't you push a quick > fix as the other reporter suggested? Thomas, Indeed, it is not possible to listen music using Banshee until the next release. However, you can build your own patched version. The recipe for a Debian based distro is more or less the following: $ sudo apt-get build-dep banshee $ apt-get source banshee $ wget -O fix-next-song.diff "http://git.gnome.org/browse/banshee/patch/?id=854fe2820efc62b8dfea1a560bad5447e3adf1c4" $ cd banshee-1.5.4 $ patch -p1 < fix-next-song.diff $ dpkg-buildpackage -rfakeroot -uc -b $ cd .. $ sudo dpkg -i banshee_1.5.4-1~hyper1~karmic_i386.deb The architecture may be different (instead of _i386 may be something different). If you are using i386 and do not want to build it by yourself, you may download it from http://people.gnome.org/~gpoo/bag/deb/ Please note that I did not change the Changelog, neither the version. It is just an ugly workaround until the next week release.
Yes, I know how to compile from source myself. I don't want to have to bother. It's absurd that the latest release of a media player effectively _can't_ _play_ _any_ _media_! I don't understand why a major crasher (easily fixed) in the latest release of a popular piece of software remains unfixed because a new release isn't planned until 10 March.
Thomas: I apologize that this bug got into 1.5.4 - we should have done more testing before the release - we usually do, and we will for 1.5.5 and beyond. That said, this is a beta release, and you can always downgrade to 1.5.3 or some other version. Additionally, I think hyperair might have packaged the fix (which was committed 2 days after 1.5.4 was released, I believe) in the Ubuntu PPA. Anyway, it's only another 3 days now until 1.5.5; please be patient or avail yourself to the many options you have.
First, sorry for getting riled up. It's just a frustrating situation for a piece of software that normally works quite well without issue. For the record, I'm using the latest version from the PPA (banshee 1.5.4-1~hyper1~jaunty) but still experiencing the crash when I try to view a smart playlist.