Can't import into Calibre 6.26

Winter57 · 12-05-2009, 06:47 AM

Anyone have this problem? Upgraded to 6.26 today from 6.25 and cannot import any Lit file into Calibre (not even txt files!). Even ones I have previously imported. All give the same error:

WARNING: Failed to read metadata: Failed to read metadata from the following:

Engines of Destiny (2005).lit
Traceback (most recent call last):
File "site-packages\calibre\gui2\add.py", line 92, in run
File "site-packages\calibre\gui2\add.py", line 137, in add
File "site-packages\calibre\library\database2.py", line 1429, in create_book_entry
File "site-packages\calibre\library\sqlite.py", line 171, in run
DatabaseException: attempt to write a readonly database
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 142, in run
OperationalError: attempt to write a readonly database

itimpi · 12-05-2009, 07:33 AM

Works fine here.

The error message suggests that you have a permission problem on accessing the Calibre metadata.db file.

What version of calibre are you using, and what OS are you using it on?

Winter57 · 12-05-2009, 09:45 AM

Calibre 6.26 upgraded from 6.25 with Windows 7 64-bit. Had no problems with this OS with 6.25 version.

kovidgoyal · 12-05-2009, 10:36 AM

Just set the permission to read/write for the metadata.db file, which you will find in the calibre library folder.

Winter57 · 12-05-2009, 01:11 PM

OK. Already done that & checked full permissions for administrator and user (both me). Get the same error message for any new book I try to add - no matter whether its Lit, PDF, Txt, or HTML.

Winter57 · 12-05-2009, 01:18 PM

Hold it! I upgraded from 32-bit to 64-bit OS and copied my metadata.db file to the new Calibre library - is that an issue?

itimpi · 12-05-2009, 01:21 PM

In itself it is not, but is quite likely that during the process permissions got messed up.

You need to check the permissions on the Calibre library folder (and sub-folders) and the metadata.db file to check that you current user has Full Access permission.

Winter57 · 12-05-2009, 01:45 PM

I've checked permissions and I have full control. But there is a problem: the file metadata.db has read only UNCHECKED but the entire folder of Calibre library (that includes the metadata file) is checked READ ONLY and no matter what I do, I can't uncheck it. That, is I uncheck it and say OK but immediately I go back to se the attributes, it is READ only checked again!

Winter57 · 12-05-2009, 02:05 PM

After changing permissions in the folders at all levels with no effect - I had the bright idea of closing Calibre and the disk and then re-opening them both. Voila! I can now add books to Calibre!

Thank so much Itimpi and kovidgoyal for your patient help.

12-05-2009, 06:47 AM	#1
Winter57 Member Posts: 11 Karma: 10 Join Date: Jun 2009 Device: Sony PRS-505	Can't import into Calibre 6.26 Anyone have this problem? Upgraded to 6.26 today from 6.25 and cannot import any Lit file into Calibre (not even txt files!). Even ones I have previously imported. All give the same error: WARNING: Failed to read metadata: Failed to read metadata from the following: Engines of Destiny (2005).lit Traceback (most recent call last): File "site-packages\calibre\gui2\add.py", line 92, in run File "site-packages\calibre\gui2\add.py", line 137, in add File "site-packages\calibre\library\database2.py", line 1429, in create_book_entry File "site-packages\calibre\library\sqlite.py", line 171, in run DatabaseException: attempt to write a readonly database RemoteTraceback (most recent call last): File "site-packages\calibre\library\sqlite.py", line 142, in run OperationalError: attempt to write a readonly database

12-05-2009, 02:05 PM	#9
Winter57 Member Posts: 11 Karma: 10 Join Date: Jun 2009 Device: Sony PRS-505	Problem solved - I think After changing permissions in the folders at all levels with no effect - I had the bright idea of closing Calibre and the disk and then re-opening them both. Voila! I can now add books to Calibre! Thank so much Itimpi and kovidgoyal for your patient help.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calibre won't import any books!	sapereaudo	Calibre	10	03-22-2010 08:55 PM
Calibre on Mac can't import eBooks	robfb	Calibre	5	12-16-2009 03:09 PM
??? books wont import into calibre???	arekieh	Calibre	1	11-25-2009 06:43 PM
Calibre 0.6.14 import problems	niche99	Calibre	2	09-29-2009 10:57 PM
Calibre import question	edembowski	Calibre	1	07-02-2008 01:21 AM

12-05-2009, 07:33 AM	#2
itimpi Wizard Posts: 4,553 Karma: 950151 Join Date: Nov 2008 Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)	Works fine here. The error message suggests that you have a permission problem on accessing the Calibre metadata.db file. What version of calibre are you using, and what OS are you using it on?

12-05-2009, 09:45 AM	#3
Winter57 Member Posts: 11 Karma: 10 Join Date: Jun 2009 Device: Sony PRS-505	Calibre 6.26 upgraded from 6.25 with Windows 7 64-bit. Had no problems with this OS with 6.25 version.

12-05-2009, 10:36 AM	#4
kovidgoyal creator of calibre Posts: 45,214 Karma: 27110894 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Just set the permission to read/write for the metadata.db file, which you will find in the calibre library folder.

12-05-2009, 01:11 PM	#5
Winter57 Member Posts: 11 Karma: 10 Join Date: Jun 2009 Device: Sony PRS-505	OK. Already done that & checked full permissions for administrator and user (both me). Get the same error message for any new book I try to add - no matter whether its Lit, PDF, Txt, or HTML.

12-05-2009, 01:18 PM	#6
Winter57 Member Posts: 11 Karma: 10 Join Date: Jun 2009 Device: Sony PRS-505	Hold it! I upgraded from 32-bit to 64-bit OS and copied my metadata.db file to the new Calibre library - is that an issue?

12-05-2009, 01:21 PM	#7
itimpi Wizard Posts: 4,553 Karma: 950151 Join Date: Nov 2008 Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)	In itself it is not, but is quite likely that during the process permissions got messed up. You need to check the permissions on the Calibre library folder (and sub-folders) and the metadata.db file to check that you current user has Full Access permission.

12-05-2009, 01:45 PM	#8
Winter57 Member Posts: 11 Karma: 10 Join Date: Jun 2009 Device: Sony PRS-505	I've checked permissions and I have full control. But there is a problem: the file metadata.db has read only UNCHECKED but the entire folder of Calibre library (that includes the metadata file) is checked READ ONLY and no matter what I do, I can't uncheck it. That, is I uncheck it and say OK but immediately I go back to se the attributes, it is READ only checked again!

Advert

Advert