Calibre can't work with prior Calibre library.

PassedPawn · 12-03-2010, 04:38 AM

Sounds a little confusing, I know.

What happened is that a recent AVG update trashed my Vista installation, so I had to reinstall Windows and all my other stuff during the last couple of days. My ebook library is located on an external hard drive which worked fine with Calibre. After installing Calibre 0.7.31, the Welcome Wizard asked for a folder to use for ebooks and I tried to set it to my original ebook folder that contains books. The error Calibre reported is this:

ERROR: Bad location: You must choose an empty folder for the calibre library. F:\Storage\Downloads\eBooks is not empty.

After finally getting Calibre to run and trying to point it to my original ebook directory, it reported this error:

ERROR: Invalid database: <p>An invalid library already exists at F:\Storage\Downloads\eBooks, delete it before trying to move the existing library.<br>Error: attempt to write a readonly database
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 196, in run
OperationalError: attempt to write a readonly database

Traceback (most recent call last):
File "site-packages\calibre\gui2\wizard\__init__.py", line 551, in move_library
File "site-packages\calibre\library\database2.py", line 133, in __init__
File "site-packages\calibre\library\database2.py", line 175, in initialize_dynamic
File "site-packages\calibre\library\sqlite.py", line 232, in run
DatabaseException: attempt to write a readonly database
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 196, in run
OperationalError: attempt to write a readonly database

Is there a way to salvage my ebook directory setup or do I have to copy each book from each subdirectory, that Calibre created before the reinstall, somewhere else and then add them to Calibre from anther directory?

SkyDream · 12-03-2010, 04:44 AM

Have you tried to cancel the Welcome Wizard and use

-Switch/Create Library
-use existing library at new location

This should work.
Maybe the Welcome Wizard tries to create a new library while detecting your existing library.

itimpi · 12-03-2010, 05:32 AM

The error message suggests that the calibre metadata.db3 file has been set read-only. Have you checked that this is not the case?

chaley · 12-03-2010, 05:51 AM

Given the rebuild, it could be that the security descriptors changed and as-logged-in, you no longer have appropriate privileges on the calibre library. Right-click on the library folder and check security to see whether the user you are logged in as has full privileges on the folder and its content. If not, fix it.

PassedPawn · 12-03-2010, 07:15 AM

That's what it was security settings. I had to change the user privileges for that drive to full.

Whew, all's working now. Thanks everybody

12-03-2010, 04:38 AM	#1
PassedPawn Junior Member Posts: 3 Karma: 10 Join Date: Oct 2010 Device: Sony PRS-300BC	Calibre can't work with prior Calibre library. Sounds a little confusing, I know. What happened is that a recent AVG update trashed my Vista installation, so I had to reinstall Windows and all my other stuff during the last couple of days. My ebook library is located on an external hard drive which worked fine with Calibre. After installing Calibre 0.7.31, the Welcome Wizard asked for a folder to use for ebooks and I tried to set it to my original ebook folder that contains books. The error Calibre reported is this: ERROR: Bad location: You must choose an empty folder for the calibre library. F:\Storage\Downloads\eBooks is not empty. After finally getting Calibre to run and trying to point it to my original ebook directory, it reported this error: ERROR: Invalid database: <p>An invalid library already exists at F:\Storage\Downloads\eBooks, delete it before trying to move the existing library.<br>Error: attempt to write a readonly database RemoteTraceback (most recent call last): File "site-packages\calibre\library\sqlite.py", line 196, in run OperationalError: attempt to write a readonly database Traceback (most recent call last): File "site-packages\calibre\gui2\wizard\__init__.py", line 551, in move_library File "site-packages\calibre\library\database2.py", line 133, in __init__ File "site-packages\calibre\library\database2.py", line 175, in initialize_dynamic File "site-packages\calibre\library\sqlite.py", line 232, in run DatabaseException: attempt to write a readonly database RemoteTraceback (most recent call last): File "site-packages\calibre\library\sqlite.py", line 196, in run OperationalError: attempt to write a readonly database Is there a way to salvage my ebook directory setup or do I have to copy each book from each subdirectory, that Calibre created before the reinstall, somewhere else and then add them to Calibre from anther directory? Last edited by PassedPawn; 12-03-2010 at 04:40 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Does Calibre work with new Kindles?	warshauer	Amazon Kindle	11	08-04-2010 09:36 PM
How to direct Library books to Calibre instead of Sony Reader Library	onebookie	Calibre	3	07-19-2010 11:31 AM
Does Calibre work with the DX?	skellng	Calibre	3	06-15-2009 01:43 PM
trying to get Calibre to work	grimo1re	Calibre	2	05-26-2009 05:56 PM
cannot get calibre to work on prs500	hechoamano	Calibre	1	12-23-2008 05:42 PM

12-03-2010, 04:44 AM	#2
SkyDream Wizard Posts: 1,377 Karma: 9400 Join Date: Sep 2009 Location: Europe Device: PRS-650, iPod touch 4G, iPad 3	Have you tried to cancel the Welcome Wizard and use -Switch/Create Library -use existing library at new location This should work. Maybe the Welcome Wizard tries to create a new library while detecting your existing library.

12-03-2010, 05:32 AM	#3
itimpi Wizard Posts: 4,552 Karma: 950151 Join Date: Nov 2008 Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)	The error message suggests that the calibre metadata.db3 file has been set read-only. Have you checked that this is not the case?

12-03-2010, 05:51 AM	#4
chaley Grand Sorcerer Posts: 11,741 Karma: 6997045 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	Given the rebuild, it could be that the security descriptors changed and as-logged-in, you no longer have appropriate privileges on the calibre library. Right-click on the library folder and check security to see whether the user you are logged in as has full privileges on the folder and its content. If not, fix it.

12-03-2010, 07:15 AM	#5
PassedPawn Junior Member Posts: 3 Karma: 10 Join Date: Oct 2010 Device: Sony PRS-300BC	That's what it was security settings. I had to change the user privileges for that drive to full. Whew, all's working now. Thanks everybody

Advert

Advert