Newbie Calibre user

shadowwolf36 · 01-29-2009, 12:53 PM

I am not the most highly computer literate person I know but I seem to be having a problem converting .lit files to .lrf.
I keep getting the following message:

attempt to write a readonly database RemoteTraceback (most recent call last): File "calibre\library\sqlite.pyo", line 80, in run OperationalError: attempt to write a readonly database
Detailed traceback:
Traceback (most recent call last):
File "main.py", line 671, in add_books
File "main.py", line 714, in _add_books
File "calibre\gui2\library.pyo", line 186, in add_books
File "calibre\library\database2.pyo", line 1137, in add_books
File "calibre\library\sqlite.pyo", line 107, in run
DatabaseException: attempt to write a readonly database
RemoteTraceback (most recent call last):
File "calibre\library\sqlite.pyo", line 80, in run
OperationalError: attempt to write a readonly database

I have converted one file successfully and all others give me this error message. I have tried removing it and re-installing it as well as rebooting my computer with no luck!! I have all the PDF files of these books but prefer LRF files. I will keep searching through these archives in case there is a fix that I am missing.

kovidgoyal · 01-29-2009, 01:01 PM

Your database file seems to have become read only. Full quit calibre (i.e. from the system tray aas well) Locate and delete the file metadata.db (it will be in the folder you selected for your library). Then restart calibre. (Note that by deleteing metadata.db you will lose any books in your calibre library.

shadowwolf36 · 01-29-2009, 02:40 PM

Thank you -- worked like a charm....how does that happen (become read only I mean) -- it happened again later on as well.

kovidgoyal · 01-29-2009, 02:51 PM

Hmm, no idea. What folder have you selected for your library?

shadowwolf36 · 01-30-2009, 07:31 AM

Actually dingbat that I am didn't choose a library so it goes in the Calibre program file but THEN I have been moving them (drop and drag) into my sd disk for later reading so perhaps the drop and drag is the problem.

itimpi · 01-30-2009, 07:58 AM

If you are using Vista (and I think possible XP+SP3) then the Program Files folder is normally set to be read-only. Therefore if you are storing your Calibre library at that location it is almost certainly the cause of your problem.

01-29-2009, 12:53 PM	#1
shadowwolf36 Enthusiast Posts: 42 Karma: 81 Join Date: Mar 2008 Device: Sony Digital	Newbie Calibre user I am not the most highly computer literate person I know but I seem to be having a problem converting .lit files to .lrf. I keep getting the following message: attempt to write a readonly database RemoteTraceback (most recent call last): File "calibre\library\sqlite.pyo", line 80, in run OperationalError: attempt to write a readonly database Detailed traceback: Traceback (most recent call last): File "main.py", line 671, in add_books File "main.py", line 714, in _add_books File "calibre\gui2\library.pyo", line 186, in add_books File "calibre\library\database2.pyo", line 1137, in add_books File "calibre\library\sqlite.pyo", line 107, in run DatabaseException: attempt to write a readonly database RemoteTraceback (most recent call last): File "calibre\library\sqlite.pyo", line 80, in run OperationalError: attempt to write a readonly database I have converted one file successfully and all others give me this error message. I have tried removing it and re-installing it as well as rebooting my computer with no luck!! I have all the PDF files of these books but prefer LRF files. I will keep searching through these archives in case there is a fix that I am missing.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Newbie E-book user	Leboire	Introduce Yourself	5	03-24-2010 08:24 PM
newbie UK user - how to use USA stores?	dieselnutjob	Sony Reader	11	06-29-2009 10:48 AM
Newbie mac user of Hanlin V3	andrespuentes	Introduce Yourself	2	12-31-2008 11:04 AM
Newbie, Mac-user, non-techie... General advice?	Savonarola	iRex	8	04-27-2008 11:26 AM

01-29-2009, 01:01 PM	#2
kovidgoyal creator of calibre Posts: 43,850 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Your database file seems to have become read only. Full quit calibre (i.e. from the system tray aas well) Locate and delete the file metadata.db (it will be in the folder you selected for your library). Then restart calibre. (Note that by deleteing metadata.db you will lose any books in your calibre library.

01-29-2009, 02:40 PM	#3
shadowwolf36 Enthusiast Posts: 42 Karma: 81 Join Date: Mar 2008 Device: Sony Digital	Thank you -- worked like a charm....how does that happen (become read only I mean) -- it happened again later on as well.

01-29-2009, 02:51 PM	#4
kovidgoyal creator of calibre Posts: 43,850 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Hmm, no idea. What folder have you selected for your library?

01-30-2009, 07:31 AM	#5
shadowwolf36 Enthusiast Posts: 42 Karma: 81 Join Date: Mar 2008 Device: Sony Digital	Actually dingbat that I am didn't choose a library so it goes in the Calibre program file but THEN I have been moving them (drop and drag) into my sd disk for later reading so perhaps the drop and drag is the problem.

01-30-2009, 07:58 AM	#6
itimpi Wizard Posts: 4,552 Karma: 950151 Join Date: Nov 2008 Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)	If you are using Vista (and I think possible XP+SP3) then the Program Files folder is normally set to be read-only. Therefore if you are storing your Calibre library at that location it is almost certainly the cause of your problem.

Advert

Advert