Database disk image is malformed

Help & Support
1

not sure what happened. it was working and now it isn’t…
tried following this thread to no avail: http://forums.nzbdrone.com/discussion/577#Item_3

snip of the end of the log file: http://pastebin.com/t3gFefcP

i’d really like to fix the db/nzbdrone as adding 150+ shows again/editing settings is a little time consuming.

let me know if you’d like me to zip up the db file
win7 64bit
chrome browser

cheers

2

If you turn on trace logging you will be able to see the episode its looking for, which has an invalid value for the air date.

The easiest way to fix it would be update all episodes and set their AirDateUtc to either null or a default date, refresh all the series and drone will fix them all. Or figure out what episode(s) is/are affected and fix them up.

I use database4 to manage the DB, but any SQLite3 DB manager should work.

3

unfortunately, i cannot start nzbdrone and only get “require.js : 138” error’s. so turning trace logging on isn’t an option at this point.

so i guess that leaves using database4 to change AirDateUtc to null. it looks like AirDateUtc (datetime, null) is already set. trying to save any changes to the db (in database4) results in ‘database disk image is malformed’ error’s.

let me know if i’m doing something wrong/missing something.

4

PM me a link to your DB and I’ll take a look.