Can't add book / can't open database

pepethecow · 06-11-2021, 02:21 PM

I ran into this when trying to add a book to my library. The same error happens when I try to open an existing book in my library, but then the book does open.

calibre, version 5.21.0
ERROR: Errors while adding: Failed to add any books, click "Show details" for more information

----------------------------------------------------------------------
Failed to add the book: An Introduction to Machine Learning
D:/username/Desktop/Kubat2017_Book_AnIntroductionToMachineLearnin.epub
With error:
Traceback (most recent call last):
File "calibre\gui2\add.py", line 457, in add_book
File "calibre\db\legacy.py", line 334, in create_book_entry
File "calibre\db\cache.py", line 75, in call_func_with_lock
File "calibre\db\cache.py", line 1698, in create_book_entry
File "calibre\db\backend.py", line 920, in execute
apsw.CantOpenError: CantOpenError: unable to open database file

Any ideas? My database is not on a NAS, just a local disk.

theducks · 06-11-2021, 02:32 PM

Check that that entire folder has full rights (not just read only)
Note: your A/V might have blocked write access to your documents folder.

Calibre now installs NEW libraries into the level above, <your user name>
You could try and move it USING THE OS (Calibre NOT running), then use Calibre to link to the new location.
right click the Library icon: Create/Switch: USE EXISTING

pepethecow · 06-11-2021, 03:29 PM

Ah, you're right. It's the Controlled Folder Access on Windows 10. I enabled it last month and completely forgot about it. Thank you so much.

06-11-2021, 02:21 PM	#1
pepethecow Junior Member Posts: 2 Karma: 10 Join Date: Jun 2021 Device: Kindle Voyager	Can't add book / can't open database I ran into this when trying to add a book to my library. The same error happens when I try to open an existing book in my library, but then the book does open. calibre, version 5.21.0 ERROR: Errors while adding: Failed to add any books, click "Show details" for more information ---------------------------------------------------------------------- Failed to add the book: An Introduction to Machine Learning D:/username/Desktop/Kubat2017_Book_AnIntroductionToMachineLearnin.epub With error: Traceback (most recent call last): File "calibre\gui2\add.py", line 457, in add_book File "calibre\db\legacy.py", line 334, in create_book_entry File "calibre\db\cache.py", line 75, in call_func_with_lock File "calibre\db\cache.py", line 1698, in create_book_entry File "calibre\db\backend.py", line 920, in execute apsw.CantOpenError: CantOpenError: unable to open database file Any ideas? My database is not on a NAS, just a local disk.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error cannot open database	jdvanisl	Library Management	4	05-25-2020 05:06 PM
Unable to open database	loatoday	Library Management	2	05-27-2018 09:41 AM
Kobo can't open database	Dei	Devices	3	05-28-2017 12:13 AM
open books failure to add new book	dhdurgee	Calibre	6	07-31-2016 02:27 PM
Calibre 7.7 cant open database	Patricia1066	Calibre	17	07-05-2010 11:23 AM

06-11-2021, 02:32 PM	#2
theducks Well trained by Cats Posts: 31,286 Karma: 62000000 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Check that that entire folder has full rights (not just read only) Note: your A/V might have blocked write access to your documents folder. Calibre now installs NEW libraries into the level above, <your user name> You could try and move it USING THE OS (Calibre NOT running), then use Calibre to link to the new location. right click the Library icon: Create/Switch: USE EXISTING

06-11-2021, 03:29 PM	#3
pepethecow Junior Member Posts: 2 Karma: 10 Join Date: Jun 2021 Device: Kindle Voyager	Ah, you're right. It's the Controlled Folder Access on Windows 10. I enabled it last month and completely forgot about it. Thank you so much.

Advert