Won't Convert - Can't Open Error

BiloKranks · 01-24-2018, 10:05 AM

Recently Calibre stopped converting files. I am being told it was unable to open database files.

I have updated to most recent version of Calibre, and also restored my library in hopes of solving the problem. Any solutions would be greatly appreciated.

Here is the error code in detail:

calibre, version 3.15.0
ERROR: Unhandled exception: <b>CantOpenError</b>:CantOpenError: unable to open database file

calibre 3.15 embedded-python: True is64bit: True
Darwin-17.3.0-x86_64-i386-64bit Darwin ('64bit', '')
('Darwin', '17.3.0', 'Darwin Kernel Version 17.3.0: Thu Nov 9 18:09:22 PST 2017; root:xnu-4570.31.3~1/RELEASE_X86_64')
Python 2.7.12
OSX: ('10.13.2', ('', '', ''), 'x86_64')
Interface language: None
Traceback (most recent call last):
File "site-packages/calibre/gui2/convert/single.py", line 288, in accept
File "site-packages/calibre/gui2/convert/metadata.py", line 259, in pre_commit_check
File "site-packages/calibre/db/cache.py", line 63, in call_func_with_lock
File "site-packages/calibre/db/cache.py", line 1101, in set_field
File "site-packages/calibre/db/cache.py", line 1036, in mark_as_dirty
File "site-packages/calibre/db/cache.py", line 1029, in update_last_modified
File "site-packages/calibre/db/write.py", line 544, in set_books
File "site-packages/calibre/db/write.py", line 197, in one_one_in_books
File "site-packages/calibre/db/backend.py", line 856, in executemany
File "src/cursor.c", line 236, in resetcursor
CantOpenError: CantOpenError: unable to open database file

BiloKranks · 01-24-2018, 10:34 AM

Quote:

Originally Posted by BiloKranks

Recently Calibre stopped converting files. I am being told it was unable to open database files.

I have updated to most recent version of Calibre, and also restored my library in hopes of solving the problem. Any solutions would be greatly appreciated.

Here is the error code in detail:

calibre, version 3.15.0
ERROR: Unhandled exception: <b>CantOpenError</b>:CantOpenError: unable to open database file

calibre 3.15 embedded-python: True is64bit: True
Darwin-17.3.0-x86_64-i386-64bit Darwin ('64bit', '')
('Darwin', '17.3.0', 'Darwin Kernel Version 17.3.0: Thu Nov 9 18:09:22 PST 2017; root:xnu-4570.31.3~1/RELEASE_X86_64')
Python 2.7.12
OSX: ('10.13.2', ('', '', ''), 'x86_64')
Interface language: None
Traceback (most recent call last):
File "site-packages/calibre/gui2/convert/single.py", line 288, in accept
File "site-packages/calibre/gui2/convert/metadata.py", line 259, in pre_commit_check
File "site-packages/calibre/db/cache.py", line 63, in call_func_with_lock
File "site-packages/calibre/db/cache.py", line 1101, in set_field
File "site-packages/calibre/db/cache.py", line 1036, in mark_as_dirty
File "site-packages/calibre/db/cache.py", line 1029, in update_last_modified
File "site-packages/calibre/db/write.py", line 544, in set_books
File "site-packages/calibre/db/write.py", line 197, in one_one_in_books
File "site-packages/calibre/db/backend.py", line 856, in executemany
File "src/cursor.c", line 236, in resetcursor
CantOpenError: CantOpenError: unable to open database file

I'm sorry, I didn't see the "How to ask question about conversion problems" post.

I am trying to convert into .MOBI or .PDF. I have tried with multiple files over multiple conversion formats. No conversion alterations from default.

theducks · 01-24-2018, 10:41 AM

It means Exactly what it says.
The Library is inaccessible (blocked?) A/V?
Is your Library on a Local (mounted) HD (thumb drive)?
Is it RWX (n77) ? You can't have any write-create restrictions (No CD/DVD) Remember that copying from those leaves the file write protected. a CHMOD is needed to restore write

kovidgoyal · 01-24-2018, 10:45 AM

Most likely your antivirus is blocking calibre from accessing the library database. Disable the antivirus or exclude the library folder from it.

BiloKranks · 01-24-2018, 12:05 PM

Thanks for the prompt reply, guys. I'm sorry I am a little slow and dim with this tech stuff.

I don't have antivirus on this Mac. Also, the library is too large (big reader) so it had to be put on an external hard drive since its a Macbook air with limited storage. The library has been there for quite some time and no problems with conversion before.

I don't know what RWX n77 is or a CHMOD

I can try to answer questions as best I can tho. Thank you again for the assistance.

kovidgoyal · 01-24-2018, 01:22 PM

If its not antivirus the other possibility is permissions problems. Try opening terminal.app and running the following command:

chmod -R a+rw /path/to/your/calibre/library/folder

BiloKranks · 01-25-2018, 12:09 AM

after finding the path to the folder, i copied and pasted

chmod -R a+rw /volumes/harddrive/calibrelibrary

terminal responded with "No such file or directory".

i can't alter metadata either, i imagine its due to the same issue. its a bit confusing, i've been using calibre for years and it just popped up recently.

when changing metadata, i get:

calibre, version 3.15.0
ERROR: Failed to set data: Could not set data, click Show Details to see why.

Traceback (most recent call last):
File "site-packages/calibre/gui2/library/models.py", line 1091, in setData
File "site-packages/calibre/gui2/library/models.py", line 1166, in _set_data
File "site-packages/calibre/db/legacy.py", line 441, in set
File "site-packages/calibre/db/cache.py", line 63, in call_func_with_lock
File "site-packages/calibre/db/cache.py", line 1092, in set_field
File "site-packages/calibre/db/write.py", line 544, in set_books
File "site-packages/calibre/db/write.py", line 407, in many_many
File "site-packages/calibre/db/write.py", line 290, in change_case
File "site-packages/calibre/db/backend.py", line 856, in executemany
File "src/cursor.c", line 236, in resetcursor
CantOpenError: CantOpenError: unable to open database file

kovidgoyal · 01-25-2018, 01:09 AM

Use quotes around the path in the terminal command

BiloKranks · 01-25-2018, 03:44 AM

chmod -R a+rw “/Volumes/hard drive/calibre library”

still no such file or directory. is it because of the spaces in folder/volume names?

kovidgoyal · 01-25-2018, 03:53 AM

Use straight quotes, not curly ones. The quotes will allow the spaces to work.

BiloKranks · 01-25-2018, 04:12 AM

may be a dumb question, but can you demonstrate? I don't know what straight quotes are.

HarryT · 01-25-2018, 04:36 AM

Quote:

Originally Posted by BiloKranks

may be a dumb question, but can you demonstrate? I don't know what straight quotes are.

"These are straight quotes".

“These are curly quotes”

BiloKranks · 01-25-2018, 08:50 AM

i tried with straight quotes and curly quotes.. neither worked for me. i may just be too dense to pull this off :/

i don't even know how to make straight quotes so i just copied from the last message.

pdurrant · 01-25-2018, 09:08 AM

Quote:

Originally Posted by BiloKranks

i tried with straight quotes and curly quotes.. neither worked for me. i may just be too dense to pull this off :/

i don't even know how to make straight quotes so i just copied from the last message.

straight quotes are the ones on the keycaps. if you're typing in terminal there should be no auto-correction to curly caps. Don't type in Word or Pages and then copy/paste to terminal.

Do you have your external hard disk plugged in?

gbm · 01-25-2018, 12:40 PM

Are you logged in as an Administrator or a User?

Run the cmd in post #6 as Administrator.

Code:

sudo chmod -R a+rw /path/to/your/calibre/library/folder

bernie

Quote:

Originally Posted by BiloKranks

i tried with straight quotes and curly quotes.. neither worked for me. i may just be too dense to pull this off :/

i don't even know how to make straight quotes so i just copied from the last message.

01-24-2018, 10:05 AM	#1
BiloKranks Member Posts: 17 Karma: 10 Join Date: May 2017 Device: none	Won't Convert - Can't Open Error Recently Calibre stopped converting files. I am being told it was unable to open database files. I have updated to most recent version of Calibre, and also restored my library in hopes of solving the problem. Any solutions would be greatly appreciated. Here is the error code in detail: calibre, version 3.15.0 ERROR: Unhandled exception: <b>CantOpenError</b>:CantOpenError: unable to open database file calibre 3.15 embedded-python: True is64bit: True Darwin-17.3.0-x86_64-i386-64bit Darwin ('64bit', '') ('Darwin', '17.3.0', 'Darwin Kernel Version 17.3.0: Thu Nov 9 18:09:22 PST 2017; root:xnu-4570.31.3~1/RELEASE_X86_64') Python 2.7.12 OSX: ('10.13.2', ('', '', ''), 'x86_64') Interface language: None Traceback (most recent call last): File "site-packages/calibre/gui2/convert/single.py", line 288, in accept File "site-packages/calibre/gui2/convert/metadata.py", line 259, in pre_commit_check File "site-packages/calibre/db/cache.py", line 63, in call_func_with_lock File "site-packages/calibre/db/cache.py", line 1101, in set_field File "site-packages/calibre/db/cache.py", line 1036, in mark_as_dirty File "site-packages/calibre/db/cache.py", line 1029, in update_last_modified File "site-packages/calibre/db/write.py", line 544, in set_books File "site-packages/calibre/db/write.py", line 197, in one_one_in_books File "site-packages/calibre/db/backend.py", line 856, in executemany File "src/cursor.c", line 236, in resetcursor CantOpenError: CantOpenError: unable to open database file

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calibre won't open and weird error message!	rtshores	Calibre	5	07-19-2012 01:01 AM
Calibre won't open after install -- ERROR: Bad database location	htbyron	Calibre	3	06-17-2010 10:43 AM
Won't convert- Value Error??? Help	Krazybaker	Calibre	2	01-27-2010 06:29 PM
Won't Convert Certain PDF's-Get This Error Message	Ravensknight	Calibre	3	07-05-2009 12:16 AM
Error when trying to open Ebook Viewer, won't show stories	cloudyvisions	Calibre	1	03-28-2009 04:13 AM

01-24-2018, 10:41 AM	#3
theducks Well trained by Cats Posts: 31,047 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	It means Exactly what it says. The Library is inaccessible (blocked?) A/V? Is your Library on a Local (mounted) HD (thumb drive)? Is it RWX (n77) ? You can't have any write-create restrictions (No CD/DVD) Remember that copying from those leaves the file write protected. a CHMOD is needed to restore write

01-24-2018, 10:45 AM	#4
kovidgoyal creator of calibre Posts: 45,342 Karma: 27182818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Most likely your antivirus is blocking calibre from accessing the library database. Disable the antivirus or exclude the library folder from it.

01-24-2018, 12:05 PM	#5
BiloKranks Member Posts: 17 Karma: 10 Join Date: May 2017 Device: none	Thanks for the prompt reply, guys. I'm sorry I am a little slow and dim with this tech stuff. I don't have antivirus on this Mac. Also, the library is too large (big reader) so it had to be put on an external hard drive since its a Macbook air with limited storage. The library has been there for quite some time and no problems with conversion before. I don't know what RWX n77 is or a CHMOD I can try to answer questions as best I can tho. Thank you again for the assistance.

01-24-2018, 01:22 PM	#6
kovidgoyal creator of calibre Posts: 45,342 Karma: 27182818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	If its not antivirus the other possibility is permissions problems. Try opening terminal.app and running the following command: chmod -R a+rw /path/to/your/calibre/library/folder

01-25-2018, 12:09 AM	#7
BiloKranks Member Posts: 17 Karma: 10 Join Date: May 2017 Device: none	after finding the path to the folder, i copied and pasted chmod -R a+rw /volumes/harddrive/calibrelibrary terminal responded with "No such file or directory". i can't alter metadata either, i imagine its due to the same issue. its a bit confusing, i've been using calibre for years and it just popped up recently. when changing metadata, i get: calibre, version 3.15.0 ERROR: Failed to set data: Could not set data, click Show Details to see why. Traceback (most recent call last): File "site-packages/calibre/gui2/library/models.py", line 1091, in setData File "site-packages/calibre/gui2/library/models.py", line 1166, in _set_data File "site-packages/calibre/db/legacy.py", line 441, in set File "site-packages/calibre/db/cache.py", line 63, in call_func_with_lock File "site-packages/calibre/db/cache.py", line 1092, in set_field File "site-packages/calibre/db/write.py", line 544, in set_books File "site-packages/calibre/db/write.py", line 407, in many_many File "site-packages/calibre/db/write.py", line 290, in change_case File "site-packages/calibre/db/backend.py", line 856, in executemany File "src/cursor.c", line 236, in resetcursor CantOpenError: CantOpenError: unable to open database file

01-25-2018, 01:09 AM	#8
kovidgoyal creator of calibre Posts: 45,342 Karma: 27182818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Use quotes around the path in the terminal command

01-25-2018, 03:44 AM	#9
BiloKranks Member Posts: 17 Karma: 10 Join Date: May 2017 Device: none	chmod -R a+rw “/Volumes/hard drive/calibre library” still no such file or directory. is it because of the spaces in folder/volume names?

01-25-2018, 03:53 AM	#10
kovidgoyal creator of calibre Posts: 45,342 Karma: 27182818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Use straight quotes, not curly ones. The quotes will allow the spaces to work.

01-25-2018, 04:12 AM	#11
BiloKranks Member Posts: 17 Karma: 10 Join Date: May 2017 Device: none	may be a dumb question, but can you demonstrate? I don't know what straight quotes are.

01-25-2018, 08:50 AM	#13
BiloKranks Member Posts: 17 Karma: 10 Join Date: May 2017 Device: none	i tried with straight quotes and curly quotes.. neither worked for me. i may just be too dense to pull this off :/ i don't even know how to make straight quotes so i just copied from the last message.

Advert

Advert