A Replay of the SQL statements: $ sqlite3 .config/banshee-1/banshee.db SQLite version 3.5.9 Enter ".help" for instructions sqlite> BEGIN; sqlite> SELECT SmartPlaylistID, Name, Condition, OrderBy, LimitNumber, LimitCriterion FROM CoreSmartPlaylists; 1|Unheard| (NumberOfPlays = 0) ||| 2|High Rating| (Rating > 3) ||| 3|Songs from the 90's| (Year BETWEEN 1990 AND 1999) AND (lower(Title) LIKE '%%') AND (lower(AlbumTitle) LIKE '%%') AND (lower(Genre) LIKE '%%') ||| 4|Songs from the 80's| (Year BETWEEN 1980 AND 1989) ||| 5|Favorites|<request><query banshee-version="1"><greaterThanEquals><field name="rating" /><int>4</int></greaterThanEquals></query></request>||| 6|Unwatched|<request><query banshee-version="1"><equals><field name="playcount" /><int>0</int></equals></query></request>||| sqlite> UPDATE CoreSmartPlaylists ...> SET Name = 'Unheard', ...> Condition = '<request><query banshee-version="1"><equals><field ...> name="playcount" /><int>0</int></equals></query></request>', ...> OrderBy = NULL, ...> LimitNumber = NULL, ...> LimitCriterion = 'songs' ...> WHERE SmartPlaylistID = 1; sqlite> UPDATE CoreSmartPlaylists ...> SET Name = 'High Rating', ...> Condition = '<request><query banshee-version="1"><greaterThan><field name="rating" /><int>3</int></greaterThan></query></request>', ...> OrderBy = NULL, ...> LimitNumber = NULL, ...> LimitCriterion = 'songs' ...> WHERE SmartPlaylistID = 2; sqlite> SELECT * FROM CoreSmartPlaylists; 1|1|Unheard|<request><query banshee-version="1"><equals><field name="playcount" /><int>0</int></equals></query></request>|||songs|6729|0 1|2|High Rating|<request><query banshee-version="1"><greaterThan><field name="rating" /><int>3</int></greaterThan></query></request>|||songs|6729|0 1|3|Songs from the 90's| (Year BETWEEN 1990 AND 1999) AND (lower(Title) LIKE '%%') AND (lower(AlbumTitle) LIKE '%%') AND (lower(Genre) LIKE '%%') ||||6729|0 1|4|Songs from the 80's| (Year BETWEEN 1980 AND 1989) ||||6729|0 3|5|Favorites|<request><query banshee-version="1"><greaterThanEquals><field name="rating" /><int>4</int></greaterThanEquals></query></request>||||0|0 3|6|Unwatched|<request><query banshee-version="1"><equals><field name="playcount" /><int>0</int></equals></query></request>||||1|0 sqlite> ROLLBACK; sqlite> SELECT * FROM CoreSmartPlaylists; 1|1|Unheard| (NumberOfPlays = 0) ||||6729|0 1|2|High Rating| (Rating > 3) ||||6729|0 1|3|Songs from the 90's| (Year BETWEEN 1990 AND 1999) AND (lower(Title) LIKE '%%') AND (lower(AlbumTitle) LIKE '%%') AND (lower(Genre) LIKE '%%') ||||6729|0 1|4|Songs from the 80's| (Year BETWEEN 1980 AND 1989) ||||6729|0 3|5|Favorites|<request><query banshee-version="1"><greaterThanEquals><field name="rating" /><int>4</int></greaterThanEquals></query></request>||||0|0 3|6|Unwatched|<request><query banshee-version="1"><equals><field name="playcount" /><int>0</int></equals></query></request>||||1|0
-- Migrate to Smart Playlists; System.NullReferenceException https://bugs.launchpad.net/bugs/330281 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
