SQL logic error or missing database no such column: t0.Protocol

Well, looks like I mucked up my nzbdrone install. I wanted to update Mono to a newer version, and in doing so it looks like I seriously messed up something (I think its because after I removed the repository-installed mono, I apt-get autoremove’d nzbdrone. Not smart).

So I updated mono (to 3.8, probably not a good version either), reinstalled nzbddrone, and now I’m getting these errors:

    System.Data.SQLite.SQLiteException: SQL logic error or missing database
no such column: t0.Protocol
  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 <filename unknown>:0 
  at System.Data.SQLite.SQLiteCommand.BuildNextCommand () [0x00000] in <filename unknown>:0 

A bunch of them. So I tried rolling back to the original version of Mono, and still get the errors. Is this a db corruption? Oye!

Thanks for any help.

Ok, I fixed it. Completely my bad.

In case anyone else runs into this issue, I think this is what happened…

When I reinstalled drone, it was an older version in the repo. My DB, however, was updated for a newer version. So I created a backup of my appdata directory, killed the DB and config.xml, started up drone, and tried to update. But no matter what I did it just wasn’t updating. After a lot of trial and error, it turned out to be a permissions issue. In order to fix it, I just chmod’d the /opt/NzbDrone directory 777. Update went fine. Stopped drone, copied my old config and DB back over, and restarted. Now I’m up and running (and with mono 3.8).

Fingers crossed everything continues to work!