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

[Daniel van Eeden]

A dump from the table which is having the issues:

$ sqlite3 .config/banshee-1/banshee.db 
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> .dump CoreSmartPlaylists
BEGIN TRANSACTION;
CREATE TABLE CoreSmartPlaylists (
                    PrimarySourceID     INTEGER,
                    SmartPlaylistID     INTEGER PRIMARY KEY,
                    Name                TEXT NOT NULL,
                    Condition           TEXT,
                    OrderBy             TEXT,
                    LimitNumber         TEXT,
                    LimitCriterion      TEXT,
                    CachedCount         INTEGER
                , IsTemporary INTEGER DEFAULT 0);
INSERT INTO "CoreSmartPlaylists" VALUES(1,1,'Unheard',' (NumberOfPlays = 0) ',NULL,NULL,NULL,6729,0);
INSERT INTO "CoreSmartPlaylists" VALUES(1,2,'High Rating',' (Rating > 3) ',NULL,NULL,NULL,6729,0);
INSERT INTO "CoreSmartPlaylists" VALUES(1,3,'Songs from the 90''s',' (Year BETWEEN 1990 AND 1999) AND (lower(Title) LIKE ''%%'') AND (lower(AlbumTitle) LIKE ''%%'') AND (lower(Genre) LIKE ''%%'') ',NULL,NULL,NULL,6729,0);
INSERT INTO "CoreSmartPlaylists" VALUES(1,4,'Songs from the 80''s',' (Year BETWEEN 1980 AND 1989) ',NULL,NULL,NULL,6729,0);
INSERT INTO "CoreSmartPlaylists" VALUES(3,5,'Favorites','<request><query banshee-version="1"><greaterThanEquals><field name="rating" /><int>4</int></greaterThanEquals></query></request>',NULL,NULL,NULL,0,0);
INSERT INTO "CoreSmartPlaylists" VALUES(3,6,'Unwatched','<request><query banshee-version="1"><equals><field name="playcount" /><int>0</int></equals></query></request>',NULL,NULL,NULL,1,0);
COMMIT;
sqlite> .quit

-- 
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.