Register Guidelines E-Books Today's Posts Search

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

Notices

Reply
 
Thread Tools Search this Thread
Old 03-17-2019, 02:40 AM   #1
Calibre69
Member
Calibre69 began at the beginning.
 
Posts: 13
Karma: 10
Join Date: Mar 2019
Device: Kobo Aura 4
Question Impossible to add books

Hello,

Excuse me for my poor English ...
I will try to describe to you my problem that has appeared since yesterday.

I have version 3.40.1 of Calibre and I don't know what happened, but since yesterday, when I want to add an epub in my library, I have the following error message:

Traceback (most recent call last):
File "site-packages \ template \ gui2 \ add.py", line 413, in add_book
File "site-packages \ template \ db \ legacy.py", line 224, in create_book_entry
File "site-packages \ caliber \ db \ cache.py", line 63, in call_func_with_lock
File "site-packages \ template \ db \ cache.py", line 1557, in create_book_entry
File "site-packages \ template \ db \ backend.py", line 845, in execute
File "c: \ t \ t \ apsw-bdov6u \ apsw-3.23.1-r1 \ src \ cursor.c", line 236, in resetcursor
CantOpenError: CantOpenError: unable to open database


I uninstalled and reinstalled Calibre, but I still have the same problem ...

Could you help me solve this annoying problem

Thanks a lot and have a good day
Calibre69 is offline   Reply With Quote
Old 03-17-2019, 03:12 AM   #2
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,253
Karma: 27110894
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
Exclude the calibre library folder from your antivirus.
kovidgoyal is offline   Reply With Quote
Advert
Old 03-17-2019, 07:10 AM   #3
Calibre69
Member
Calibre69 began at the beginning.
 
Posts: 13
Karma: 10
Join Date: Mar 2019
Device: Kobo Aura 4
Hello Mumbai,

My Calibre library is in the "Documents" folder of W10, under the name "Calibration Library" and I can't exclude a folder from my Windows Defender anti-virus.
I set my anti virus to accept Calibre and it didn't not change anything ....
What else to do ???
Calibre69 is offline   Reply With Quote
Old 03-17-2019, 10:11 AM   #4
Calibre69
Member
Calibre69 began at the beginning.
 
Posts: 13
Karma: 10
Join Date: Mar 2019
Device: Kobo Aura 4
Path is C:\Users\User\Documents\Calibre Library

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

I installed Calibre on my other computer (W10) and I have NO problem, NO error message

So....
Calibre69 is offline   Reply With Quote
Old 03-17-2019, 12:21 PM   #5
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: 30,946
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Does your username (windows logon) have any non-ASCII characters?
theducks is offline   Reply With Quote
Advert
Old 03-17-2019, 01:52 PM   #6
stumped
Wizard
stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.
 
Posts: 3,305
Karma: 10259306
Join Date: May 2016
Device: kobo forma, Kobo Libra, Huawei media Tab, fire HD10, PW3 HDX8.9,
You CAN exclude folders from Windows defender Scans and checks.

https://www.addictivetips.com/window...er-windows-10/

You can also temporarily turn off defender to see if that is the cause for the problem. Or not
stumped is offline   Reply With Quote
Old 03-17-2019, 02:14 PM   #7
Calibre69
Member
Calibre69 began at the beginning.
 
Posts: 13
Karma: 10
Join Date: Mar 2019
Device: Kobo Aura 4
So, no, I don't think ..... my windows password is a mix of numbers and lowercase letters (6 in all).

I tried a database restore that failed:
Traceback (most recent call last):
File "site-packages \ template \ db \ restore.py", line 127, in run
File "site-packages \ template \ db \ restore.py", line 279, in replace_db
File "shutil.py", line 97, in copyfile
IOError: [Errno 2] No such file or directory: u'C: \\ Users \\ US2 \\ Documents \\ Calibration Library \\ metadata_pre_restore.db '

I NEVER had this problem before and without touching windows defender..

It's a real mystery !!
Calibre69 is offline   Reply With Quote
Old 03-17-2019, 02:50 PM   #8
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: 45,439
Karma: 168808777
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
Could you try the following procedure:
  1. Open Windows Defender Security Center.
  2. Click on Virus & threat protection.
  3. Click the Virus & threat protection settings option.
  4. Turn off the Controlled folder access toggle switch.

You could also try adding calibre's application collection to the allowed list in the Controlled Folder area but it was easier for me to move my calibre libraries into a new directory directly under my user directory (C:\Users\David\Calibre) and point calibre at the new locations.
DNSB is offline   Reply With Quote
Old 03-17-2019, 03:46 PM   #9
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: 30,946
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by Calibre69 View Post
So, no, I don't think ..... my windows password is a mix of numbers and lowercase letters (6 in all).

I tried a database restore that failed:
Traceback (most recent call last):
File "site-packages \ template \ db \ restore.py", line 127, in run
File "site-packages \ template \ db \ restore.py", line 279, in replace_db
File "shutil.py", line 97, in copyfile
IOError: [Errno 2] No such file or directory: u'C: \\ Users \\ US2 \\ Documents \\ Calibration Library \\ metadata_pre_restore.db '

I NEVER had this problem before and without touching windows defender..

It's a real mystery !!
Is this your unique name, because it sure is not Calibre Library (the default, but not required )?
theducks is offline   Reply With Quote
Old 03-17-2019, 06:03 PM   #10
BetterRed
null operator (he/him)
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: 21,662
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
It could be Onedrive synching.

Recent versions of Windows 10 automatically synchronise the %USERRHOME%\Documents folder to OneDrive, for that reason since calibre version 3.30 the location of the default library changed from %USERRHOME%\Documents\Calibre Library to ???? - I'm not sure. This only affects new installations of course. Synching involves file locking and VSS trickery.

IIRC you could exclude the Calibre Library folder in Documents from OneDrive synching; or you could pause Onedrive synching when you're using calibre; or you could move your library to a location that Onedrive won't synch automatically - such as %USERRHOME%\Calibre\Library. I would opt for the third option

Move the library when calibre is not running, then when you start calibre it should ask where its library went and offer a dialogue to select the new location.

BR
BetterRed is online now   Reply With Quote
Old 03-18-2019, 02:24 AM   #11
Calibre69
Member
Calibre69 began at the beginning.
 
Posts: 13
Karma: 10
Join Date: Mar 2019
Device: Kobo Aura 4
Good Morning,

YES, BINGO, I followed your advice and changed the location of my "Caliber library": I put it in C: \ Users \ US2 \ Calibration Library and ALL is working normally ... but I don't understand why ! Why this new location is good...now ???

It's really odd, because when I installed Calibre yesterday on my second ASUS laptop, I did not have these problems ... and my folder is in C: \ Users \ NOUS2 \ Documents \ Calibration Library.
This second computer has the same version of W10 ...

Everything appeared on my HP desktop, why ????
Can you explain that to me ???
A HUGE THANK YOU to you ALL

Have a very good day
Calibre69 is offline   Reply With Quote
Old 03-18-2019, 03:32 PM   #12
stumped
Wizard
stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.
 
Posts: 3,305
Karma: 10259306
Join Date: May 2016
Device: kobo forma, Kobo Libra, Huawei media Tab, fire HD10, PW3 HDX8.9,
Quote:
Originally Posted by BetterRed View Post
It could be Onedrive synching.

Recent versions of Windows 10 automatically synchronise the %USERRHOME%\Documents folder to OneDrive, for that reason since calibre version 3.30 the location of the default library changed from %USERRHOME%\Documents\Calibre Library to ???? - I'm not sure. This only affects new installations of course. Synching involves file locking and VSS trickery.

IIRC you could exclude the Calibre Library folder in Documents from OneDrive synching; or you could pause Onedrive synching when you're using calibre; or you could move your library to a location....

BR
Good spot. One drive is harmless only if you don't use Microsoft accounts. It cannot then auto sync as it has nowhere to sync to....
stumped is offline   Reply With Quote
Old 03-18-2019, 06:27 PM   #13
BetterRed
null operator (he/him)
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: 21,662
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
@Calibre69 - One of the features of Onedrive (Microsoft's equivalent of Dropbox, Google Drive etc) is that it can maintain a replica of designated folders on MS's cloud servers. A recent version of Windows added the user's Documents, Pictures, and Music folders to the default list of folders Onedrive will replicate to the cloud.

Prior to calibre version 3.30 a new install of Calibre would create its default library ("Calibre Library") in the users Documents folder. The design of the calibre software assumes it has exclusive access to the current library. But the advent of Onedrive's replication of the Documents by default means calibre and Onedrive are trying to access the same data concurrently.

Since calibre version 3.30, the Welcome wizard creates the default library in the users Home directory, which removes it from Onedrive's default list of folders to replicate to the cloud.

If you want to keep a copy of your library on your Onedrive 'account' use a file synch tool that can interoperate with Onedrive - most of them can.

I won't speculate why things work on your ASUS and not on your HP, there are too many variables at play. I suggest you move your calibre libraries out of the Documents folder on both computers.

BR

Last edited by BetterRed; 03-19-2019 at 01:15 AM.
BetterRed is online now   Reply With Quote
Old 03-19-2019, 12:42 AM   #14
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: 45,439
Karma: 168808777
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
Quote:
Originally Posted by Calibre69 View Post
Good Morning,

YES, BINGO, I followed your advice and changed the location of my "Caliber library": I put it in C: \ Users \ US2 \ Calibration Library and ALL is working normally ... but I don't understand why ! Why this new location is good...now ???

It's really odd, because when I installed Calibre yesterday on my second ASUS laptop, I did not have these problems ... and my folder is in C: \ Users \ NOUS2 \ Documents \ Calibration Library.
This second computer has the same version of W10 ...

Everything appeared on my HP desktop, why ????
Can you explain that to me ???
I have seen several people have issues with updates to Windows Defender and access to files/directories in it's protected folders which includes the Documents directory. The weird part is that in theory, Documents is part of the default for protected folders but some people have it protected and others don't despite "I didn't make any changes"—something which any tech has heard all too often.

There have also been issues with OneDrive and other cloud storage providers where they synchronize the Documents directory which can and does make calibre very unhappy. I generally find it easier to move the calibre library directories to where they will not be synchronized and then to save a backup where it will be synchronized.
DNSB is offline   Reply With Quote
Old 03-19-2019, 02:27 AM   #15
stumped
Wizard
stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.stumped ought to be getting tired of karma fortunes by now.
 
Posts: 3,305
Karma: 10259306
Join Date: May 2016
Device: kobo forma, Kobo Libra, Huawei media Tab, fire HD10, PW3 HDX8.9,
Quote:
Originally Posted by DNSB View Post

There have also been issues with OneDrive and other cloud storage providers where they synchronize the Documents directory which can and does make calibre very unhappy. I generally find it easier to move the calibre library directories to where they will not be synchronized and then to save a backup where it will be synchronized.
maybe a warning is needed in calibre FAQ / documentation re this. as it installs a library into documents by default
its probably too tricky to detect if sync is ON for one drive during an install, and to warn at that stage ?
stumped is offline   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Vanishing auto add books during import, books left behind in auto add folder jataadroid Library Management 9 01-14-2018 11:43 PM
Impossible to add a font to an azw3. Is it a bug? Ruskie_it Editor 4 07-03-2017 07:02 AM
5 Reasons It’s Impossible to Find Funny Books xg4bx General Discussions 37 02-28-2014 08:17 AM
Trying to add large library of books - add books seems to have hung nicknefarious Library Management 1 06-18-2012 09:32 AM
I was told ya can use itunes to get audio books, so how do ya add the books to the K? Dragoro Amazon Kindle 27 04-16-2009 12:17 AM


All times are GMT -4. The time now is 02:56 AM.


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