[Linux] Upgraded today, now can't access UI, db error

Help & Support
1

I upgraded NzbDrone today and now, even though it says it’s running, I can’t get the UI to load using the localhost url (or any other, for that matter). When I attempted to start using command line (mono /opt/NzbDrone/NzbDrone.exe) I got this error:

[Fatal] ConsoleApp: EPIC FAIL!

System.Exception: SQL logic error or missing database
duplicate column name: Items
While Processing:
“ALTER TABLE “QualityProfiles” ADD COLUMN “Items” TEXT” —> System.Data.SQLite.SQLiteException: SQL logic error or missing database
duplicate column name: Items
at System.Data.SQLite.SQLite3.Prepare (System.Data.SQLite.SQLiteConnection cnn, System.String strSql, System.Data.SQLite.SQLiteStatement previous, UInt32 timeoutMS, System.String& strRemain) [0x00000] in :0
at System.Data.SQLite.SQLiteCommand.BuildNextCommand () [0x00000] in :0
— End of inner exception stack trace —
at FluentMigrator.Runner.Processors.Sqlite.SqliteProcessor.ExecuteNonQuery (System.String sql) [0x00000] in :0
at FluentMigrator.Runner.Processors.Sqlite.SqliteProcessor.Process (System.String sql) [0x00000] in :0
at FluentMigrator.Runner.Processors.ProcessorBase.Process (FluentMigrator.Expressions.CreateColumnExpression expression) [0x00000] in :0
at FluentMigrator.Expressions.CreateColumnExpression.ExecuteWith (IMigrationProcessor processor) [0x00000] in :0
at FluentMigrator.Runner.MigrationRunner+<>c__DisplayClass18.b__15 () [0x00000] in :0
at FluentMigrator.Runner.StopWatch.Time (System.Action action) [0x00000] in :0
at FluentMigrator.Runner.MigrationRunner.AnnounceTime (System.String message, System.Action action) [0x00000] in :0
at FluentMigrator.Runner.MigrationRunner.ExecuteExpressions (ICollection`1 expressions) [0x00000] in :0

So I stopped the service, rebooted, and tried starting it again. This time it started just fine, but when I got to the URL it gives me the “You must be new around here, You should add some series.” message!?! So my question is, can I possibly access my previous series and application settings? I’d hate to have to go through and re-setup everything… Are these backed up somewhere in a flat file or something I could “import” back in?

Any idea what could have happened?

Thanks for your help!
Ed

2

Same issue: http://forums.nzbdrone.com/discussion/1040/error-trying-to-start-drone#Item_11

Not sure how the DB would have been reset unless it was deleted (which wouldn’t happen automatically) or you’re running it as a different user (stored in /home/<user>/.config/NzbnDrone.

There is no backup stored on disk in a flat file or any other format.

3

Thanks Markus - the update worked for me and got me back to my original config.