Quote:
Originally Posted by chaley
Restore database restores the custom columns. If they are gone, then more than the database is messed up. The .opf files in the book directories are also corrupted.I said "strongly suggests", not "must be".
Are you sure that SQLiteExpress does not try to open/load the views? If it does, then it will fail, because the functions are not available. SQLiteSpy (at least V1.8.12) does not open the views when it opens the DB.
|
Starting backward.
Husband says that yes, SQLiteExpert is trying to open/load the views. So... mystery solved, I guess. But the problem remains that Calibre2opds cannot open my metadata.db file and if neither the tool nor the developer can open it *and* it was working in December and I've changed nothing except update Calibre, then it seems like something is wrong.
Restore database retained my custom columns, but lost all the tagging data associated with them. So custom column "Source" was still there, but the actual data that X book was Source --> Amazon was gone. You say this means that the opf files are corrupt. Yay?
I have 1,000+ in my Calibre library. I hope there's a way to solve/fix this without having to re-input every single one. Because that would make me very sad indeed.