Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 02-21-2019, 01:45 PM   #1
Islanders
Junior Member
Islanders began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Feb 2019
Device: Kobo Aura
Angry 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
Islanders is offline   Reply With Quote
Old 02-21-2019, 02:19 PM   #2
DaltonST
Deviser
DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.
 
DaltonST's Avatar
 
Posts: 1,379
Karma: 101268
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
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)?
DaltonST is offline   Reply With Quote
Old 02-21-2019, 03:04 PM   #3
Islanders
Junior Member
Islanders began at the beginning.
 
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
Islanders is offline   Reply With Quote
Old 02-21-2019, 03:26 PM   #4
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 12,460
Karma: 10634266
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
BetterRed is offline   Reply With Quote
Old 02-21-2019, 03:45 PM   #5
ilovejedd
hopeless n00b
ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.
 
ilovejedd's Avatar
 
Posts: 3,525
Karma: 9000000
Join Date: Jan 2009
Location: in the middle of nowhere
Device: PW4, PW3, iPad 9.7, iPad 12.9
Iirc, some versions of Windows now automatically include the Documents folder in OneDrive.
ilovejedd is offline   Reply With Quote
Old 02-21-2019, 03:56 PM   #6
Islanders
Junior Member
Islanders began at the beginning.
 
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.
Islanders is offline   Reply With Quote
Old 02-21-2019, 04:07 PM   #7
gbm
Wizard
gbm ought to be getting tired of karma fortunes by now.gbm ought to be getting tired of karma fortunes by now.gbm ought to be getting tired of karma fortunes by now.gbm ought to be getting tired of karma fortunes by now.gbm ought to be getting tired of karma fortunes by now.gbm ought to be getting tired of karma fortunes by now.gbm ought to be getting tired of karma fortunes by now.gbm ought to be getting tired of karma fortunes by now.gbm ought to be getting tired of karma fortunes by now.gbm ought to be getting tired of karma fortunes by now.gbm ought to be getting tired of karma fortunes by now.
 
Posts: 1,502
Karma: 5970580
Join Date: Jun 2010
Device: Windows 10 tablet,Hisence Sero 7 Pro RIP, Nook STR, jetbook lite
Quote:
Originally Posted by Islanders View Post
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 View Post
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
gbm is offline   Reply With Quote
Old 02-21-2019, 04:18 PM   #8
Islanders
Junior Member
Islanders began at the beginning.
 
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.
Islanders is offline   Reply With Quote
Old 02-21-2019, 04:50 PM   #9
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 12,460
Karma: 10634266
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by Islanders View Post
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
Attached Thumbnails
Click image for larger version

Name:	{14071520-5C30-4D5A-B77D-DDE347FBAA49}.jpg
Views:	19
Size:	126.2 KB
ID:	169854  
BetterRed is offline   Reply With Quote
Old 02-21-2019, 05:05 PM   #10
Islanders
Junior Member
Islanders began at the beginning.
 
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?
Islanders is offline   Reply With Quote
Old 02-21-2019, 05:06 PM   #11
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 5,546
Karma: 25303977
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Aura One, Aura H2O, Aura HD, Nexus 7 HD, iPad Air, Tolino epos
Quote:
Originally Posted by BetterRed View Post
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.
DNSB is offline   Reply With Quote
Old 02-21-2019, 06:21 PM   #12
Islanders
Junior Member
Islanders began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Feb 2019
Device: Kobo Aura
Great suggestion.
Thanks
Islanders is offline   Reply With Quote
Old 02-21-2019, 06:46 PM   #13
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 22,745
Karma: 23579576
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: K4NT, Galaxy Tab A, Kobo Aura2
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
theducks is online now   Reply With Quote
Old 02-21-2019, 10:33 PM   #14
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 12,460
Karma: 10634266
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by Islanders View Post
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
BetterRed is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 03:47 PM.


MobileRead.com is a privately owned, operated and funded community.