unable to get my book backup back into Calibre? error msg inside

stustaff · 04-18-2009, 04:37 PM

unable to open database file RemoteTraceback (most recent call last): File "calibre\library\sqlite.pyo", line 119, in run OperationalError: unable to open database file
Detailed traceback:
Traceback (most recent call last):
File "main.py", line 793, in delete_books
File "calibre\gui2\library.pyo", line 224, in delete_books
File "calibre\library\database2.pyo", line 772, in delete_book
File "calibre\library\database2.pyo", line 799, in clean
File "calibre\library\sqlite.pyo", line 146, in run
DatabaseException: unable to open database file
RemoteTraceback (most recent call last):
File "calibre\library\sqlite.pyo", line 119, in run
OperationalError: unable to open database file

Ok so I am moving from a Mac to a PC for my prs 505 use and have created a copy of my calibre library by using 'save to disk in a single directory' in my mac calibre then in my windows calibre using 'add multiple books per directory' as instructed in the user guide.

however I get the message as above and only 188 of the 500+ books are in the library

Any ideas/suggestions?

Thanks

stustaff · 04-18-2009, 04:44 PM

sorry should also add done a full ubinstall and reinstall to latest version and still get this message!

kovidgoyal · 04-18-2009, 05:29 PM

Just copy your calibre library from the PC to the Mac, using your normal file copying tools. Then on the PC start calibre as

calibre --with-library c:\path\to\the\copied\library\folder

stustaff · 04-19-2009, 08:18 AM

Quote:

Originally Posted by kovidgoyal

Just copy your calibre library from the PC to the Mac, using your normal file copying tools. Then on the PC start calibre as

calibre --with-library c:\path\to\the\copied\library\folder

can Kovid or anyone translate the last bit into 'know nothing about computers speak' thanks

Im assuming he/you mean something in the CMD Run box thingie on the PC?

I normally just start by using GUI, will I then need to start like this everytime?

Thanks

sirbruce · 04-19-2009, 10:00 AM

I think you only have to do it once. As for simple instructions, we'd need to know where your Calibre is installed (default location?) and where you copy the library to on your PC.

stustaff · 04-20-2009, 05:17 PM

Quote:

Originally Posted by sirbruce

I think you only have to do it once. As for simple instructions, we'd need to know where your Calibre is installed (default location?) and where you copy the library to on your PC.

yeh in default location and i havent copied the library to anywhere? its on an external drive im trying to add the books from the exported book folder i created in calibre on my mac,

sirbruce · 04-20-2009, 08:23 PM

We'd need to know what drive letter, directory, etc. the library is on your external drive.

stustaff · 05-03-2009, 10:53 AM

Sorry for the long gap been away...

The library isnt in aany location thats what im trying to explain!

The installasion on my windows PC is standard so tCalibres library is on the C drive.

On my Mac i have opened Calibre and done a save to disc to back up all my books, they are saved on a USB drive which when connected to my PC is the S: drive but it is NOT a calibre Library! it is just a folder I called ebooks with the contents of Calbres(on my mac) save to disc function.

Calibre(windows) will not let me add the books in my folder to ITS existing Library. I get the original error. ????

Thanks for your help so far really appreciate it.

kovidgoyal · 05-03-2009, 02:04 PM

You get that error when trying to add books or when starting up calibre?

sirbruce · 05-03-2009, 07:58 PM

I would uninstall Calibre on the Windows machine, delete the Library folder wherever you designated it on your C: drive, and reinstall a new version of Calibre.

stustaff · 05-04-2009, 04:28 AM

Quote:

Originally Posted by kovidgoyal

You get that error when trying to add books or when starting up calibre?

initially when I tried to add books but then on start of calibre seems to be when it tries to access the library info for the first time.

stustaff · 05-04-2009, 04:30 AM

Quote:

Originally Posted by sirbruce

I would uninstall Calibre on the Windows machine, delete the Library folder wherever you designated it on your C: drive, and reinstall a new version of Calibre.

Thanks but as mentioned a few posts up I have tried this already.
I have to assume when I remove Calibre and delete the library folder that I am missing something...

OR actually could my backup be the problem, thats what started it and on a clean install it still wont accept it.

itimpi · 05-04-2009, 04:48 AM

There is also the folder containing Calibre settings under your User profile. This is important as it will contain the path (amongst other things) that Calibre will use to try and find your library. Deleting this folder makes calibre return to default settings.

It will have a path something like C:\Documents and Settings\Username\Application Data\calibre although it can vary slightly with different versions of Windows. You may need to ensure that you have the "Show Hidden Files" set under folder options to see this folder.

sirbruce · 05-04-2009, 04:51 AM

The only thing I can guess is a permissions problem, but that would be fixed by the uninstall and deleteing of the folder. So yes, something is being missed, but I'm afraid with your imperfect description of the problem I'm at a loss to say what's going wrong.

You might try as Kovid suggested before... forget save to disk, just copy the Mac library directory onto your USB drive, then copy the library folder from your USB drive onto Windows (after deleteing the old library folder), and starting calibre from the command line with the path to the new library. But you'd need to understand what the path was on your PC in order to do that.

04-18-2009, 04:37 PM	#1
stustaff Wizard Posts: 1,055 Karma: 2110 Join Date: Nov 2007 Location: Derbyshire UK Device: sony reader PRS505 and 600	unable to get my book backup back into Calibre? error msg inside unable to open database file RemoteTraceback (most recent call last): File "calibre\library\sqlite.pyo", line 119, in run OperationalError: unable to open database file Detailed traceback: Traceback (most recent call last): File "main.py", line 793, in delete_books File "calibre\gui2\library.pyo", line 224, in delete_books File "calibre\library\database2.pyo", line 772, in delete_book File "calibre\library\database2.pyo", line 799, in clean File "calibre\library\sqlite.pyo", line 146, in run DatabaseException: unable to open database file RemoteTraceback (most recent call last): File "calibre\library\sqlite.pyo", line 119, in run OperationalError: unable to open database file Ok so I am moving from a Mac to a PC for my prs 505 use and have created a copy of my calibre library by using 'save to disk in a single directory' in my mac calibre then in my windows calibre using 'add multiple books per directory' as instructed in the user guide. however I get the message as above and only 188 of the 500+ books are in the library Any ideas/suggestions? Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error msg "Warning - failed to read metadata"	kloewen	Calibre	2	06-08-2010 01:25 PM
Error Msg DatabaseException	jessie102	Calibre	0	02-18-2010 09:49 AM
Possible error with adding new format of book already in Calibre	TalpaEuropea	Calibre	1	02-14-2010 08:51 AM
Help with error msg	Novasea	Calibre	14	03-30-2009 02:07 PM
calibre auto fetch non-scheduled job & puts out error msg	shinew	Calibre	2	02-23-2009 10:27 PM

04-18-2009, 04:44 PM	#2
stustaff Wizard Posts: 1,055 Karma: 2110 Join Date: Nov 2007 Location: Derbyshire UK Device: sony reader PRS505 and 600	sorry should also add done a full ubinstall and reinstall to latest version and still get this message!

04-18-2009, 05:29 PM	#3
kovidgoyal creator of calibre Posts: 45,210 Karma: 27110894 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Just copy your calibre library from the PC to the Mac, using your normal file copying tools. Then on the PC start calibre as calibre --with-library c:\path\to\the\copied\library\folder

04-19-2009, 10:00 AM	#5
sirbruce Provocateur Posts: 1,859 Karma: 505847 Join Date: Feb 2009 Location: Columbus, OH Device: Kindle Touch, Kindle 2, Kindle DX, iPhone 3GS	I think you only have to do it once. As for simple instructions, we'd need to know where your Calibre is installed (default location?) and where you copy the library to on your PC.

04-20-2009, 08:23 PM	#7
sirbruce Provocateur Posts: 1,859 Karma: 505847 Join Date: Feb 2009 Location: Columbus, OH Device: Kindle Touch, Kindle 2, Kindle DX, iPhone 3GS	We'd need to know what drive letter, directory, etc. the library is on your external drive.

05-03-2009, 10:53 AM	#8
stustaff Wizard Posts: 1,055 Karma: 2110 Join Date: Nov 2007 Location: Derbyshire UK Device: sony reader PRS505 and 600	Sorry for the long gap been away... The library isnt in aany location thats what im trying to explain! The installasion on my windows PC is standard so tCalibres library is on the C drive. On my Mac i have opened Calibre and done a save to disc to back up all my books, they are saved on a USB drive which when connected to my PC is the S: drive but it is NOT a calibre Library! it is just a folder I called ebooks with the contents of Calbres(on my mac) save to disc function. Calibre(windows) will not let me add the books in my folder to ITS existing Library. I get the original error. ???? Thanks for your help so far really appreciate it.

05-03-2009, 02:04 PM	#9
kovidgoyal creator of calibre Posts: 45,210 Karma: 27110894 Join Date: Oct 2006 Location: Mumbai, India Device: Various	You get that error when trying to add books or when starting up calibre?

05-03-2009, 07:58 PM	#10
sirbruce Provocateur Posts: 1,859 Karma: 505847 Join Date: Feb 2009 Location: Columbus, OH Device: Kindle Touch, Kindle 2, Kindle DX, iPhone 3GS	I would uninstall Calibre on the Windows machine, delete the Library folder wherever you designated it on your C: drive, and reinstall a new version of Calibre.

05-04-2009, 04:48 AM	#13
itimpi Wizard Posts: 4,553 Karma: 950151 Join Date: Nov 2008 Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)	There is also the folder containing Calibre settings under your User profile. This is important as it will contain the path (amongst other things) that Calibre will use to try and find your library. Deleting this folder makes calibre return to default settings. It will have a path something like C:\Documents and Settings\Username\Application Data\calibre although it can vary slightly with different versions of Windows. You may need to ensure that you have the "Show Hidden Files" set under folder options to see this folder.

05-04-2009, 04:51 AM	#14
sirbruce Provocateur Posts: 1,859 Karma: 505847 Join Date: Feb 2009 Location: Columbus, OH Device: Kindle Touch, Kindle 2, Kindle DX, iPhone 3GS	The only thing I can guess is a permissions problem, but that would be fixed by the uninstall and deleteing of the folder. So yes, something is being missed, but I'm afraid with your imperfect description of the problem I'm at a loss to say what's going wrong. You might try as Kovid suggested before... forget save to disk, just copy the Mac library directory onto your USB drive, then copy the library folder from your USB drive onto Windows (after deleteing the old library folder), and starting calibre from the command line with the path to the new library. But you'd need to understand what the path was on your PC in order to do that.