MobileRead Forums - View Single Post - Corrupt database and no metadata_pre_restore.db'

helibird · 02-24-2019, 02:08 PM

Help, I've screwed things up!
I opened Calibre, All books appeared OK with their metadata but when I tried to update one I got the following
calibre, version 3.30.0
ERROR: Failed to set data: Could not set data, click Show Details to see why.

Traceback (most recent call last):
File "site-packages\calibre\gui2\library\models.py", line 1091, in setData
File "site-packages\calibre\gui2\library\models.py", line 1117, in _set_data
File "site-packages\calibre\gui2\library\models.py", line 1080, in set_custom_column_data
File "site-packages\calibre\db\legacy.py", line 659, in set_custom
File "site-packages\calibre\db\cache.py", line 1092, in set_field
File "site-packages\calibre\db\write.py", line 544, in set_books
File "site-packages\calibre\db\write.py", line 228, in one_one_in_other
File "site-packages\calibre\db\backend.py", line 855, in executemany
File "c:\t\t\apsw-bdov6u\apsw-3.23.1-r1\src\cursor.c", line 236, in resetcursor
CantOpenError: CantOpenError: unable to open database file

I tried several times to restore the database and finally spotted I had another Calibre Library with one author.
I told it to forget this library but the database is still coming up corrupt.
The restore is coming up with
ERROR: Failed: Restoring database failed, click Show details to see details

Traceback (most recent call last):
File "site-packages\calibre\db\restore.py", line 127, in run
File "site-packages\calibre\db\restore.py", line 279, in replace_db
File "shutil.py", line 83, in copyfile
IOError: [Errno 2] No such file or directory: u'C:\\Users\\helen\\Documents\\MyBooks\\Calibre Library\\metadata_pre_restore.db'
and it is right there is no such file in either of the Calibre libraries
The restore creates a tiny db file and when I click to open Calibre it flashed up something and then closes. If I put the old db back I get back to the original postion - can see all my books but can't save anything!

I assume I will have to create a new blank library somewhere else and re import all my books (only about 3500 so not too bad).
Will I lose my user meta data (telling be which ones I've read and their rating).
Can someone poit me at where I can find instructions for the best way to get Calibre back up with minimal loss.

02-24-2019, 02:08 PM	#1
helibird Member Posts: 13 Karma: 10 Join Date: Feb 2019 Location: UK Device: dell netbook	Corrupt database and no metadata_pre_restore.db' Help, I've screwed things up! I opened Calibre, All books appeared OK with their metadata but when I tried to update one I got the following calibre, version 3.30.0 ERROR: Failed to set data: Could not set data, click Show Details to see why. Traceback (most recent call last): File "site-packages\calibre\gui2\library\models.py", line 1091, in setData File "site-packages\calibre\gui2\library\models.py", line 1117, in _set_data File "site-packages\calibre\gui2\library\models.py", line 1080, in set_custom_column_data File "site-packages\calibre\db\legacy.py", line 659, in set_custom File "site-packages\calibre\db\cache.py", line 1092, in set_field File "site-packages\calibre\db\write.py", line 544, in set_books File "site-packages\calibre\db\write.py", line 228, in one_one_in_other File "site-packages\calibre\db\backend.py", line 855, in executemany File "c:\t\t\apsw-bdov6u\apsw-3.23.1-r1\src\cursor.c", line 236, in resetcursor CantOpenError: CantOpenError: unable to open database file I tried several times to restore the database and finally spotted I had another Calibre Library with one author. I told it to forget this library but the database is still coming up corrupt. The restore is coming up with ERROR: Failed: Restoring database failed, click Show details to see details Traceback (most recent call last): File "site-packages\calibre\db\restore.py", line 127, in run File "site-packages\calibre\db\restore.py", line 279, in replace_db File "shutil.py", line 83, in copyfile IOError: [Errno 2] No such file or directory: u'C:\\Users\\helen\\Documents\\MyBooks\\Calibre Library\\metadata_pre_restore.db' and it is right there is no such file in either of the Calibre libraries The restore creates a tiny db file and when I click to open Calibre it flashed up something and then closes. If I put the old db back I get back to the original postion - can see all my books but can't save anything! I assume I will have to create a new blank library somewhere else and re import all my books (only about 3500 so not too bad). Will I lose my user meta data (telling be which ones I've read and their rating). Can someone poit me at where I can find instructions for the best way to get Calibre back up with minimal loss.