DatabaseError: malformed database schema (author_insert_trg) - no such table: authors
Kovid,
So the question is ... what caused the db corruption? Especially since the restored db quickly became corrupted again.
I'm running Windows 7 attached to Windows Server - the My Documents folder gets synchronized to server storage using a Sync Center app in the Control Panel. The Calibre Library location is a network url eg //<machine>/<user>/My Documents/Calibre Library but it's stored on the local machine.
metadata.db is part of the sync but yields a sync error 'The process cannot access the file because it is being used by another process'. That happens sometimes with open documents etc and isn't usually a problem.
But for some reason this is a problem with Calibre and the db keeps getting corrupted. Maybe something to do with the file/db lock?
I'll fix this by moving the Calibre Library to a non-sync'd location which isn't optimal but will do.
But I thought you should know in case it happens to others.
Cheers,
Peter D/
|