Help Needed - Data Base Errors

Islanders · 02-21-2019, 01:45 PM

Get the following error when trying to add a book, can anyone please tell me how to resolve this error. I tried a repair install of Calibre but the error is still there.
Many Thanks

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

----------------------------------------------------------------------
Failed to add the book: Mission Critical
C:\Users\User\Downloads\Mission Critical - Mark Greaney.epub
With error:
Traceback (most recent call last):
File "site-packages\calibre\gui2\add.py", line 413, in add_book
File "site-packages\calibre\db\legacy.py", line 224, in create_book_entry
File "site-packages\calibre\db\cache.py", line 63, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 1557, in create_book_entry
File "site-packages\calibre\db\backend.py", line 845, in execute
File "c:\t\t\apsw-xaw3dh\apsw-3.26.0-r1\src\cursor.c", line 236, in resetcursor
CantOpenError: CantOpenError: unable to open database file

DaltonST · 02-21-2019, 02:19 PM

What is the path to your current Calibre Library for which you are adding books? Drive C: or another HD drive letter? Or a network or cloud location (neither are supported by Calibre)?

Islanders · 02-21-2019, 03:04 PM

Path is C:\Users\User\Documents\Calibre Library

I have been using the program and this path for years error just happened today when I tried to add a new book

BetterRed · 02-21-2019, 03:26 PM

Try disabling your Anti Virus software.

If that fixes it, put "C:\Users\User\Documents\Calibre Library" into the AV's exception list... or use another AV.

BR

ilovejedd · 02-21-2019, 03:45 PM

Iirc, some versions of Windows now automatically include the Documents folder in OneDrive.

Islanders · 02-21-2019, 03:56 PM

Dont have One Drive activated.
Have been using Windows Defender AntiVirus and surprisingly that must have been the problem, when I turned it off Calibre worked perfectly. I would have to guess that something in the latest Defender update must have caused the problem since it was working fine yesterday,
thanks for the help, most appreciated.

gbm · 02-21-2019, 04:07 PM

Quote:

Originally Posted by Islanders

Dont have One Drive activated.
Have been using Windows Defender AntiVirus and surprisingly that must have been the problem, when I turned it off Calibre worked perfectly. I would have to guess that something in the latest Defender update must have caused the problem since it was working fine yesterday,
thanks for the help, most appreciated.

Quote:

Originally Posted by Islanders

Path is C:\Users\User\Documents\Calibre Library

I have been using the program and this path for years error just happened today when I tried to add a new book

Right click the calibre icon in the calibre toolbar and select Library maintenance->Check Library--fix any problems found.

If that does not work then make a copy of your library then Right click the calibre icon in the calibre toolbar and select Library maintenance->Restore database.

bernie

Islanders · 02-21-2019, 04:18 PM

"Have been using Windows Defender AntiVirus and surprisingly that must have been the problem, when I turned it off Calibre worked perfectly. "

Disabling Windows Defender did the trick, database can now be accessed as usual.
By the way i tried Library Maintenance and it didn't fix the problem, disabling Windows Defender did though.

BetterRed · 02-21-2019, 04:50 PM

Quote:

Originally Posted by Islanders

Dont have One Drive activated.
Have been using Windows Defender AntiVirus and surprisingly that must have been the problem, when I turned it off Calibre worked perfectly. I would have to guess that something in the latest Defender update must have caused the problem since it was working fine yesterday,
thanks for the help, most appreciated.

I use Defender, and its not happening here, and I don't have any Defender exclusions.

When you say you 'turned it off", how did you do that - afaik it ain't easy to completely disable Defender. Perhaps you mean you turned off the Controlled Folder access feature?

Documents is in the Controlled Folders list - but my libraries are not in my Documents folder.

Attaching a screenshot of recent Defender updates

BR

Islanders · 02-21-2019, 05:05 PM

Go to Windows Defender, Virus then Threat Protections Settings and turn off Real Time Protection.
Once doing this gave me access to the Library I added Calibre as an exclusion and the problem disappeared.
I'm using the 64 bit version are you?

DNSB · 02-21-2019, 05:06 PM

Quote:

Originally Posted by BetterRed

I use Defender, and its not happening here, and I don't have any Defender exclusions.

When you say you 'turned it off", how did you do that - afaik it ain't easy to completely disable Defender. Perhaps you mean you turned off the Controlled Folder access feature?

Documents is in the Controlled Folders list - but my libraries are not in my Documents folder.

BR

The default path for the calibre library on Windows is in the user's Documents folder. Islander gave his path as "%userprofile%\Documents\Calibre Library". My personal choice a while back was to move my library folders to %userprofile%\Calibre so they were not in the Documents directory.

Islanders · 02-21-2019, 06:21 PM

Great suggestion.
Thanks

theducks · 02-21-2019, 06:46 PM

I use windows defender X64, and it gives no problem. I do remember excluding the Library from the real time scan (everything in the Library come from another 'scanned' folder

BetterRed · 02-21-2019, 10:33 PM

Quote:

Originally Posted by Islanders

Go to Windows Defender, Virus then Threat Protections Settings and turn off Real Time Protection.
Once doing this gave me access to the Library I added Calibre as an exclusion and the problem disappeared.
I'm using the 64 bit version are you?

Yep - Windows Pro 64bit 1809

The only thing I have turned off is Controlled Folder access.

My libraries are not on my system drive.

BR

Calibre69 · 03-20-2019, 02:29 AM

I'm using the 64 bit W10 version ...I don't use OneDrive....and it was always like that ..
Is a last update of Windows that led to this ???
But..NO, because on my laptop ASUS (same version of W10) "Documents Calibre" is always at the same place (C:\Users\User\Documents\Calibre Library) and works well ...

I think we will not be able to understand, why ....

02-21-2019, 01:45 PM	#1
Islanders Junior Member Posts: 6 Karma: 10 Join Date: Feb 2019 Device: Kobo Aura	Help Needed - Data Base Errors Get the following error when trying to add a book, can anyone please tell me how to resolve this error. I tried a repair install of Calibre but the error is still there. Many Thanks calibre, version 3.39.1 ERROR: Errors while adding: Failed to add any books, click "Show details" for more information ---------------------------------------------------------------------- Failed to add the book: Mission Critical C:\Users\User\Downloads\Mission Critical - Mark Greaney.epub With error: Traceback (most recent call last): File "site-packages\calibre\gui2\add.py", line 413, in add_book File "site-packages\calibre\db\legacy.py", line 224, in create_book_entry File "site-packages\calibre\db\cache.py", line 63, in call_func_with_lock File "site-packages\calibre\db\cache.py", line 1557, in create_book_entry File "site-packages\calibre\db\backend.py", line 845, in execute File "c:\t\t\apsw-xaw3dh\apsw-3.26.0-r1\src\cursor.c", line 236, in resetcursor CantOpenError: CantOpenError: unable to open database file

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Transplanting data base to Aura One!	jackastor	Kobo Reader	26	09-19-2016 12:55 PM
Aura One data base error	petercreasey	Devices	4	09-07-2016 08:56 PM
Aura One data base error	petercreasey	Kobo Reader	5	09-07-2016 07:49 PM
Compress Data Base error on GloHD	mconh	Devices	3	11-09-2015 05:53 PM
corrupted data base	keith1241	Calibre	4	05-05-2013 10:40 PM

02-21-2019, 02:19 PM	#2
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	What is the path to your current Calibre Library for which you are adding books? Drive C: or another HD drive letter? Or a network or cloud location (neither are supported by Calibre)?

02-21-2019, 03:04 PM	#3
Islanders Junior Member Posts: 6 Karma: 10 Join Date: Feb 2019 Device: Kobo Aura	Path is C:\Users\User\Documents\Calibre Library I have been using the program and this path for years error just happened today when I tried to add a new book

02-21-2019, 03:26 PM	#4
BetterRed null operator (he/him) Posts: 21,677 Karma: 29711016 Join Date: Mar 2012 Location: Sydney Australia Device: none	Try disabling your Anti Virus software. If that fixes it, put "C:\Users\User\Documents\Calibre Library" into the AV's exception list... or use another AV. BR

02-21-2019, 03:45 PM	#5
ilovejedd hopeless n00b Posts: 5,110 Karma: 19597086 Join Date: Jan 2009 Location: in the middle of nowhere Device: PW4, PW3, Libra H2O, iPad 10.5, iPad 11, iPad 12.9	Iirc, some versions of Windows now automatically include the Documents folder in OneDrive.

02-21-2019, 03:56 PM	#6
Islanders Junior Member Posts: 6 Karma: 10 Join Date: Feb 2019 Device: Kobo Aura	Dont have One Drive activated. Have been using Windows Defender AntiVirus and surprisingly that must have been the problem, when I turned it off Calibre worked perfectly. I would have to guess that something in the latest Defender update must have caused the problem since it was working fine yesterday, thanks for the help, most appreciated.

02-21-2019, 04:18 PM	#8
Islanders Junior Member Posts: 6 Karma: 10 Join Date: Feb 2019 Device: Kobo Aura	"Have been using Windows Defender AntiVirus and surprisingly that must have been the problem, when I turned it off Calibre worked perfectly. " Disabling Windows Defender did the trick, database can now be accessed as usual. By the way i tried Library Maintenance and it didn't fix the problem, disabling Windows Defender did though.

02-21-2019, 05:05 PM	#10
Islanders Junior Member Posts: 6 Karma: 10 Join Date: Feb 2019 Device: Kobo Aura	Go to Windows Defender, Virus then Threat Protections Settings and turn off Real Time Protection. Once doing this gave me access to the Library I added Calibre as an exclusion and the problem disappeared. I'm using the 64 bit version are you?

02-21-2019, 06:21 PM	#12
Islanders Junior Member Posts: 6 Karma: 10 Join Date: Feb 2019 Device: Kobo Aura	Great suggestion. Thanks

02-21-2019, 06:46 PM	#13
theducks Well trained by Cats Posts: 30,966 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	I use windows defender X64, and it gives no problem. I do remember excluding the Library from the real time scan (everything in the Library come from another 'scanned' folder

03-20-2019, 02:29 AM	#15
Calibre69 Member Posts: 13 Karma: 10 Join Date: Mar 2019 Device: Kobo Aura 4	I'm using the 64 bit W10 version ...I don't use OneDrive....and it was always like that .. Is a last update of Windows that led to this ??? But..NO, because on my laptop ASUS (same version of W10) "Documents Calibre" is always at the same place (C:\Users\User\Documents\Calibre Library) and works well ... I think we will not be able to understand, why ....

Advert

Advert