database disk image is malformed

Report your bugs here - if someone else has already mentioned the same bug, just add on to their post with as much info as possible to make the hunting easier.

database disk image is malformed

Postby aioman » Sun Oct 25, 2015 9:40 am

hi Support

somehow my database of bookpedia (the wishlist) got corrupted.

crash report in console:

Code: Select all
Bookpedia[1225]   Fatal error.  The database at /Users/helgebaurecker2014/Library/Application Support/Bookpedia/Database.bookpd is corrupted.  SQLite error code:11, 'database disk image is malformed'


the wishlist was partly not editable anymore. i could navigate through the books but no edit them normally. so i deleted all books in the wishlist, one by one, use key shortcuts and it worked - but the list was empty but still amount 1 book - but the book itself in the list was visible anymore. and now i'm blocked, cant open any list anymore, blocked in the wishlist.

is there a way to clean the database?

using latest version of bookpedia and OX X 10.10.5 (iMac 27" from 2009), >3'500 books in my library...
aioman
Inductee
Inductee
 
Posts: 1
Joined: Sun Oct 25, 2015 9:30 am

Re: database disk image is malformed

Postby Conor » Mon Oct 26, 2015 4:26 am

Thank you for the clear explanation and bug report. OS X should protect from incomplete changes being written to the database file, although rare anything can still happen. Bookpedia has a hidden "Verify Database" command that will go through and check the entire database. You can find it by holding down the option key and clicking on the "Help" menu in Bookpedia. Do run it, might get the missing book to show up, but better yet do also send me the database file and I can make sure everything is okay by exporting it and reimporting into a text SQL format that I can read and double check. Select /Users/helgebaurecker2014/Library/Application Support/Bookpedia/Database.bookpd and use the "File -> Compress" command and you can email the zip version.

Alternatively you can also restore that Database.bookpd from a few days before from a backup without Bookpedia running. If you take this route, do run the "Verify Database" as well just to make sure the error was not earlier and simply hiding in your wish list until you went to use it.
User avatar
Conor
Top Dog
 
Posts: 5212
Joined: Sat Jul 03, 2004 12:58 pm


Return to Bug Reports