Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 04-26-2010, 03:18 PM   #1
modkindle
Member
modkindle began at the beginning.
 
Posts: 15
Karma: 10
Join Date: Apr 2010
Device: kindle
calibre and dropbox error

I use calibre and dropbox together and made a big mistake and although I still have all of my books, my calibre can't find them. I tried to add another computer to the dropbox and calibre and have both computers have access to the same library. It seems to have written two metadata.db files and messed everything up. Is there any way for me to replace the metadata.db file with the correct one so I don't have to add all 607 books again and edit the metadate for them?

Thank you so much. I hope my question makes sense, as I am not very technical.
modkindle is offline   Reply With Quote
Old 04-26-2010, 03:43 PM   #2
Starson17
Wizard
Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.
 
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
Quote:
Originally Posted by modkindle View Post
I use calibre and dropbox together and made a big mistake and although I still have all of my books, my calibre can't find them. I tried to add another computer to the dropbox and calibre and have both computers have access to the same library. It seems to have written two metadata.db files and messed everything up. Is there any way for me to replace the metadata.db file with the correct one so I don't have to add all 607 books again and edit the metadate for them?

Thank you so much. I hope my question makes sense, as I am not very technical.
Someone here will help you. Just don't delete any copies of your metadata.db or overwrite any. If your books are still in your library (and they almost certainly are), all you will have to do is put the correct metadata.db back into the library. That will get you most of your books back (any added after the problem occurred probably will need to be added again.) There are several dropbox experts here, and you should be able to recover conflict files.
Starson17 is offline   Reply With Quote
 
Enthusiast
Old 04-26-2010, 03:46 PM   #3
modkindle
Member
modkindle began at the beginning.
 
Posts: 15
Karma: 10
Join Date: Apr 2010
Device: kindle
Quote:
Originally Posted by Starson17 View Post
Someone here will help you. Just don't delete any copies of your metadata.db or overwrite any. If your books are still in your library (and they almost certainly are), all you will have to do is put the correct metadata.db back into the library. That will get you most of your books back (any added after the problem occurred probably will need to be added again.) There are several dropbox experts here, and you should be able to recover conflict files.
Thank you. Thank you. Thank you.

I still have all of the books and I know which metadata.db I need and I still have it. But in my efforts to "fix" this I tried to unhook the dropbox folder (in Calibre preferences) and rehook it and it then hates the whole metadata.db file that I have.
modkindle is offline   Reply With Quote
Old 04-26-2010, 04:51 PM   #4
Starson17
Wizard
Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.
 
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
Quote:
Originally Posted by modkindle View Post
Thank you. Thank you. Thank you.

I still have all of the books and I know which metadata.db I need and I still have it. But in my efforts to "fix" this I tried to unhook the dropbox folder (in Calibre preferences) and rehook it and it then hates the whole metadata.db file that I have.
There are procedures in dropbox to get back files when they're in a conflict state. I'm sorry I don't know them, but others do. If you can find the correct metadata.db, all you have to do is put it in the right place (be careful when you do this, as you will have to overwrite what's there now -save all your files). Once the right metadata.db is in your library, you should make sure that Calibre is pointed to that library location (Check Preferences.)

If Calibre is complaining about your metadata.db, however, your metadata.db may be corrupted.

After you get your best metadata.db in the right place, and get Calibre pointed to it, you should probably run the database integrity option in Preferences.

You may want to search for the dropbox threads here. They should give you some idea of how to recover.
Starson17 is offline   Reply With Quote
Old 04-26-2010, 05:14 PM   #5
chaley
"chaley", not "charley"
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 5,522
Karma: 855450
Join Date: Jan 2010
Location: France
Device: Many android devices
Because of the order of things you did, you now (probably) have what dropbox calls conflicts. These happen when the same file changes in two places. In your case, the metadata.db changed on the new machine before it was successfully synced from the original machine. This happens if you run calibre on the new machine before sync finishes.

The way out of this is probably:
1. Ensure that each machine is connected to dropbox.
2. Go to your dropbox website. Navigate through your folders (on the website) to calibre's library folder, the one containing metadata.db.
3. Run your mouse over the metadata.db file. Click the little down-pointing triangle that appears, and select 'previous versions'
4. Select the version that is correct. It will be the newest largest version. You might also be able to tell from the timestamp, taking the one dated from before you added the new dropbox client.
5. Restore that version.
6. At this point, you have told dropbox which one is correct. This file will be downloaded to all the clients. However, on machines with the *wrong* db, the correct db will show up as a conflict file. Delete the wrong one and rename the right one to metadata.db.

An alternate way that avoids step 6 is to delete metadata.db* from every machine in step 1. If you do this, then step 3 must be modified to include clicking the 'show deleted files' button so that you will see the versions of metadata.db to select from.

Do not run calibre until all machines claim to be fully synced.

Good luck!
chaley is offline   Reply With Quote
Old 04-26-2010, 05:19 PM   #6
modkindle
Member
modkindle began at the beginning.
 
Posts: 15
Karma: 10
Join Date: Apr 2010
Device: kindle
thank you Chaley. I will try that tonight. The worst thing that happens is I go back a couple of weeks with my library and only add a few books. Could be a lot worse. I guess I got a bit too big for my britches with experimentation!
modkindle is offline   Reply With Quote
Old 04-26-2010, 10:57 PM   #7
modkindle
Member
modkindle began at the beginning.
 
Posts: 15
Karma: 10
Join Date: Apr 2010
Device: kindle
Success. Thank you so very much
modkindle is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[Old Thread] Calibre + Dropbox = unclouded happiness dpierron Related Tools 143 10-30-2011 07:01 AM
Calibre & Dropbox and 2 computers???? jekoby Related Tools 3 08-02-2010 03:16 AM
Calibre Error TimeTraveler Calibre 8 05-13-2010 09:41 AM
New Dropbox/Calibre User Question Sydney's Mom Related Tools 7 03-30-2010 01:07 AM
Error with Calibre sonli Calibre 7 05-28-2008 10:38 AM


All times are GMT -4. The time now is 02:47 AM.


MobileRead.com is a privately owned, operated and funded community.