problem after upgrading from 0.8.7 to 0.8.8 - Page 2

theducks · 07-05-2011, 04:50 PM

Quote:

Originally Posted by Mickey330

Hi, Kovid -

I have just received this error. I did it to myself - forgot to close Calibre 0.8.7 before I started running the installation of 0.8.8. Stoooopid me!

Anyway, I got the same results as the prior poster - corrupted, can't fix, open with blank library. So, I go to Calibre and try to change libraries (mine's in Dropbox). I get this:

[

Marilyn

NO
the DB IS your Library. Any other DB is just junk (as far as your Library is concerned

)

Zip Up Metadata.db and be prepared to sent it to Kovid when asked.

DoctorOhh · 07-05-2011, 06:41 PM

Quote:

Originally Posted by Mickey330

If my assumptions above are wrong - please help me fix my idiotic error?

Kovid may have other advice but since you are using Dropbox just restore (via dropbox web site) the last version of metadata.db that was working. Any library changes made after this previous version won't be there but your library will be working again.

Good Luck.

kovidgoyal · 07-05-2011, 09:10 PM

Run this command and it will fix your broken metadata.db automatically:

Code:

calibre-debug -c "from calibre.utils.config import prefs; import os, sqlite3; db = os.path.join(prefs['library_path'], 'metadata.db'); conn = sqlite3.connect(db); schema = conn.execute('pragma user_version=21'); conn.commit()"

Just copy paste it into a windows command prompt and press enter to run it.

Mickey330 · 07-05-2011, 10:36 PM

Ah, that did the trick. Thanks, Kovid!

Next time, promise, I'll remember to close Calibre before installing updates. Silly n00b move...

Marilyn

jiffy128 · 07-08-2011, 04:08 AM

Kovid

Just a brief update

Since your last message I have been extremely busy due to a serious illness in the family leaving me in charge of 4 young grandchildren so have not had time to get back to you.

Version monitoring software I run has since informed me by email that I was not on the latest Calibre version and that it was 0.8.8 that I was missing. Thus when I thought I had an issue it did happen going from 0.8.6 to 0.8.7

On that occasion Calibre informed me on startup that there was a newer version (first time I have seen that - i am a recent user and started on 0.8.3 I think and have always been informed of new versions by the version tracking sioftware and installed without opening Calibre first) and I proceeded to install from within Calibre and then couldnt open my database having done so. Anyway that is now history - I have now downloaded and installed 0.8.8 but have not yet had time to run with it. I expect to do so over the weekend and will get back to you if the database problem recurs.

07-05-2011, 09:10 PM	#18
kovidgoyal creator of calibre Posts: 45,597 Karma: 28548962 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Run this command and it will fix your broken metadata.db automatically: Code: calibre-debug -c "from calibre.utils.config import prefs; import os, sqlite3; db = os.path.join(prefs['library_path'], 'metadata.db'); conn = sqlite3.connect(db); schema = conn.execute('pragma user_version=21'); conn.commit()" Just copy paste it into a windows command prompt and press enter to run it.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem upgrading to 7.51 or 7.52	speakingtohe	Calibre	13	03-28-2011 01:38 PM
Opus Problem Upgrading Opus	Adri	Bookeen	18	02-20-2011 06:15 AM
problem upgrading	GA Russell	Calibre	4	09-29-2010 05:22 PM
Problem upgrading to last version	trustno12003	Calibre	0	12-26-2008 07:36 AM
Problem upgrading	capinredbeard	iRex	4	02-12-2008 02:02 AM

07-05-2011, 10:36 PM	#19
Mickey330 Addict Posts: 378 Karma: 1107420 Join Date: Dec 2009 Location: Western New York state (USA) Device: Kindle Oasis & the Kindle app on iDevices	Ah, that did the trick. Thanks, Kovid! Next time, promise, I'll remember to close Calibre before installing updates. Silly n00b move... Marilyn

07-08-2011, 04:08 AM	#20
jiffy128 Junior Member Posts: 3 Karma: 10 Join Date: Jul 2011 Device: Kindle	Kovid Just a brief update Since your last message I have been extremely busy due to a serious illness in the family leaving me in charge of 4 young grandchildren so have not had time to get back to you. Version monitoring software I run has since informed me by email that I was not on the latest Calibre version and that it was 0.8.8 that I was missing. Thus when I thought I had an issue it did happen going from 0.8.6 to 0.8.7 On that occasion Calibre informed me on startup that there was a newer version (first time I have seen that - i am a recent user and started on 0.8.3 I think and have always been informed of new versions by the version tracking sioftware and installed without opening Calibre first) and I proceeded to install from within Calibre and then couldnt open my database having done so. Anyway that is now history - I have now downloaded and installed 0.8.8 but have not yet had time to run with it. I expect to do so over the weekend and will get back to you if the database problem recurs.