#75 GreatNews: database upgrade fails

[denis hainsworth]

going from version 1.0.0.386 to 1.0.396 copied over my newsfeed.db and ran exe. got popup to upgrade database. clicked ok. got error stating bloglines_account was not found. i think there is an error with your sql in upgrader 109. the keys are explicit values but not single quoted and so sqlite thinks they are column names. here's what i ran myself

sqlite3 newsfeed.db

sqlite> BEGIN EXCLUSIVE TRANSACTION;
sqlite> CREATE TABLE configuration(key VARCHAR(50) NOT NULL UNIQUE, value VARCHAR(250));
sqlite> INSERT INTO configuration SELECT 'bloglines_account' AS key, options7 AS value FROM configurations LIMIT 1;
sqlite> INSERT INTO configuration SELECT 'bloglines_password' AS key, options8 AS value FROM configurations LIMIT 1;
sqlite> INSERT INTO configuration SELECT 'bloglines_dontmarkread' AS key, options6 AS value FROM configurations LIMIT 1;
sqlite> INSERT INTO configuration SELECT 'last_start' AS key, options1 AS value FROM configurations LIMIT 1;
sqlite> INSERT INTO configuration SELECT 'last_shutdown' AS key, options2 AS value FROM configurations LIMIT 1;
sqlite> INSERT INTO configuration values('db_version',109);
sqlite> DROP TABLE configurations;
sqlite> COMMIT TRANSACTION;

then copied the newsfeed.db back to the directory. ran new binary and now everything seems to work as normal.

[Nikkho]

Thank you for your tip.
When I took the project I remember GreatNewsUpdater was not building for some reason, so I did not updated it.

[denis hainsworth]

ah i see. well thank you for the changes you did make. i wish i could edit the ticket name. it turned out not to be strictly related to bloglines accounts. if you are bored and can delete "if you do not have a bloglines account" that would be more accurate if anyone else hits this

[Nikkho]

Title changed.