[ubuntu-mono] [Bug 330281] Re: Migrate to Smart Playlists; System.NullReferenceException

[Daniel van Eeden]

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 MOTU Mono
Team, which is subscribed to banshee in ubuntu.