Database repair? or what?

emphasis · 10-29-2010, 11:35 PM

Somewhat new to Calibre and the more I use it the more I need to learn!

It seems that I have one book in my library database that is causing a problem. Lets say that I have 100 books and this is book#50. I get a response from Calibre for #'s 1 - 49 and 51 - 100. I get NONE for #50. I cannot use the program to delete it because it does not recognize it. I added the book again to the library and it was done successfully, without presenting the usual window saying this book is already in library, do you want to add it. Again, because Calibre did not recognize it.

Thinking that it might be in the database I checked on this forum and found a couple of mentions about going to preferences + advanced + database. Well I found preferences+advanced but NO database.

I am using the latest version calibre and windows7

Please advise how to correct this problem.

Thanks

Jerry

kovidgoyal · 10-29-2010, 11:37 PM

I'm not clear on what the problem is. Why not just delete the book causing the problem and re-add it?

Manichean · 10-30-2010, 03:28 AM

In newer versions of Calibre the database integrity check lives in the dropdown menu of the library button. See library maintenance.

emphasis · 10-30-2010, 04:39 AM

Manichean - thanks for pointing out the library maintenance drop down menu. I did run the database integrity check and it found no problems. So my problem still exists

emphasis · 10-30-2010, 04:48 AM

Kovid - thanks for your program and your response.
Your response was 2 part.

You suggested that I simply delete the book and then re add the book.

In my original post I tried to explain that I tried that and it failed.

"I cannot use the program to delete it because it does not recognize it. I added the book again to the library and it was done successfully, without presenting the usual window saying this book is already in library, do you want to add it. Again, because Calibre did not recognize it."

The program is not recognizing this one book and when I do do click on the book the program does not respond, and soon I get a message that the entire program is not responding.

This occurs ONLY on this one book, all other book entries respond correctly.

Jerry

DoctorOhh · 10-30-2010, 06:04 AM

Quote:

Originally Posted by emphasis

"I cannot use the program to delete it because it does not recognize it. I added the book again to the library and it was done successfully, without presenting the usual window saying this book is already in library, do you want to add it. Again, because Calibre did not recognize it."

You actually see this book in your library?
When you select it what formats exist for this book? To find the formats select the book and click edit metadata and tell me what you see in available formats area (see attached).
What format is the book you try to add?
When you select the book and say remove is the entry deleted?
Did you reboot your computer and try to remove the book?

emphasis · 10-30-2010, 10:23 AM

Dwanthy - thanks for your response. Since receipt of your response I defragmented my drives and then rebooted .................... same problem

You asked "You actually see this book in your library?" YES, I actually see the book in the library.

You asked "When you select it what formats exist for this book?" and "When you select the book and say remove is the entry deleted?"

I have tried to explain this previously.............. when I select the book nothing happens! As opposed to the normal response of highlighting the selected book in blue and then being able to select an action i.e delete book, edit book, view book.

What does happen is that the cursor changes to a spinning wheel and in a second or two a message stating "(not responding) appears at the top left and the only action I can take is to close the program and restart.

Not stating this as a cause but only an observation is that this began after I installed 7.25. I have since uninstalled and reinstalled but problem persists.

????????????????

Jerry

kovidgoyal · 10-30-2010, 10:50 AM

you can run the database check by clicking the arrow next to the calibre icon and choosing

library management->check database integrity

emphasis · 10-30-2010, 11:38 AM

Kovid - yes, one of your forum members pointed this out in a previous response and in my response to him I stated "Manichean - thanks for pointing out the library maintenance drop down menu. I did run the database integrity check and it found no problems. So my problem still exists" (see above)

Also please read my previous post at 2:23 PM

Jerry

Manichean · 10-30-2010, 11:57 AM

Are there actually formats inside the books' library folder (and are they the ones you expect to be there)? Does the folder exist?

kovidgoyal · 10-30-2010, 11:59 AM

post the crash report when calibre crashes.

chaley · 10-30-2010, 12:00 PM

Quote:

Originally Posted by emphasis

Kovid - yes, one of your forum members pointed this out in a previous response and in my response to him I stated "Manichean - thanks for pointing out the library maintenance drop down menu. I did run the database integrity check and it found no problems. So my problem still exists" (see above)

Did you run check_library (found near check integrity)? It won't fix anything, but it might point at where the problem is.

emphasis · 10-30-2010, 12:13 PM

Kovid -Pls adv how to obtain 'crash report'. thanks

emphasis · 10-30-2010, 12:16 PM

Chaley - re: check library. Tried it before but not really sure if it ran or what it was doing. Ran again after reading your message and this is what I copied

Invalid authors,metadata.opf,metadata.opf

As I am not sure what this file is I did not delete it, Was not sure if it represnted just one author in that file, or if all authors are in the file.

Thanks Jerry

kovidgoyal · 10-30-2010, 12:29 PM

Run calibre in a console as

calibre-debug -g

and post any output you see when the crash happens

10-29-2010, 11:35 PM	#1
emphasis Member Posts: 18 Karma: 10 Join Date: Oct 2010 Device: Nook	Database repair? or what? Somewhat new to Calibre and the more I use it the more I need to learn! It seems that I have one book in my library database that is causing a problem. Lets say that I have 100 books and this is book#50. I get a response from Calibre for #'s 1 - 49 and 51 - 100. I get NONE for #50. I cannot use the program to delete it because it does not recognize it. I added the book again to the library and it was done successfully, without presenting the usual window saying this book is already in library, do you want to add it. Again, because Calibre did not recognize it. Thinking that it might be in the database I checked on this forum and found a couple of mentions about going to preferences + advanced + database. Well I found preferences+advanced but NO database. I am using the latest version calibre and windows7 Please advise how to correct this problem. Thanks Jerry

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Repair Database metadata.db	icq70610	Calibre	1	09-21-2010 02:35 AM
Hiebook repair	N5EGX	Legacy E-Book Devices	8	05-13-2008 07:08 PM
New repair story :-((((	Gogolo	iRex	11	04-16-2008 05:37 PM
repair cost	cirocco	Sony Reader	3	01-30-2008 04:46 AM
Care and Repair	oliverbogler	iRex	9	07-25-2006 05:59 AM

10-29-2010, 11:37 PM	#2
kovidgoyal creator of calibre Posts: 43,850 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	I'm not clear on what the problem is. Why not just delete the book causing the problem and re-add it?

10-30-2010, 03:28 AM	#3
Manichean Wizard Posts: 3,130 Karma: 91256 Join Date: Feb 2008 Location: Germany Device: Cybook Gen3	In newer versions of Calibre the database integrity check lives in the dropdown menu of the library button. See library maintenance.

10-30-2010, 04:39 AM	#4
emphasis Member Posts: 18 Karma: 10 Join Date: Oct 2010 Device: Nook	Manichean - thanks for pointing out the library maintenance drop down menu. I did run the database integrity check and it found no problems. So my problem still exists

10-30-2010, 04:48 AM	#5
emphasis Member Posts: 18 Karma: 10 Join Date: Oct 2010 Device: Nook	Kovid - thanks for your program and your response. Your response was 2 part. You suggested that I simply delete the book and then re add the book. In my original post I tried to explain that I tried that and it failed. "I cannot use the program to delete it because it does not recognize it. I added the book again to the library and it was done successfully, without presenting the usual window saying this book is already in library, do you want to add it. Again, because Calibre did not recognize it." The program is not recognizing this one book and when I do do click on the book the program does not respond, and soon I get a message that the entire program is not responding. This occurs ONLY on this one book, all other book entries respond correctly. Jerry

10-30-2010, 10:23 AM	#7
emphasis Member Posts: 18 Karma: 10 Join Date: Oct 2010 Device: Nook	Dwanthy - thanks for your response. Since receipt of your response I defragmented my drives and then rebooted .................... same problem You asked "You actually see this book in your library?" YES, I actually see the book in the library. You asked "When you select it what formats exist for this book?" and "When you select the book and say remove is the entry deleted?" I have tried to explain this previously.............. when I select the book nothing happens! As opposed to the normal response of highlighting the selected book in blue and then being able to select an action i.e delete book, edit book, view book. What does happen is that the cursor changes to a spinning wheel and in a second or two a message stating "(not responding) appears at the top left and the only action I can take is to close the program and restart. Not stating this as a cause but only an observation is that this began after I installed 7.25. I have since uninstalled and reinstalled but problem persists. ???????????????? Jerry

10-30-2010, 10:50 AM	#8
kovidgoyal creator of calibre Posts: 43,850 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	you can run the database check by clicking the arrow next to the calibre icon and choosing library management->check database integrity

10-30-2010, 11:38 AM	#9
emphasis Member Posts: 18 Karma: 10 Join Date: Oct 2010 Device: Nook	Kovid - yes, one of your forum members pointed this out in a previous response and in my response to him I stated "Manichean - thanks for pointing out the library maintenance drop down menu. I did run the database integrity check and it found no problems. So my problem still exists" (see above) Also please read my previous post at 2:23 PM Jerry

10-30-2010, 11:57 AM	#10
Manichean Wizard Posts: 3,130 Karma: 91256 Join Date: Feb 2008 Location: Germany Device: Cybook Gen3	Are there actually formats inside the books' library folder (and are they the ones you expect to be there)? Does the folder exist?

10-30-2010, 11:59 AM	#11
kovidgoyal creator of calibre Posts: 43,850 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	post the crash report when calibre crashes.

10-30-2010, 12:13 PM	#13
emphasis Member Posts: 18 Karma: 10 Join Date: Oct 2010 Device: Nook	Kovid -Pls adv how to obtain 'crash report'. thanks

10-30-2010, 12:16 PM	#14
emphasis Member Posts: 18 Karma: 10 Join Date: Oct 2010 Device: Nook	Chaley - re: check library. Tried it before but not really sure if it ran or what it was doing. Ran again after reading your message and this is what I copied Invalid authors,metadata.opf,metadata.opf As I am not sure what this file is I did not delete it, Was not sure if it represnted just one author in that file, or if all authors are in the file. Thanks Jerry

10-30-2010, 12:29 PM	#15
kovidgoyal creator of calibre Posts: 43,850 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Run calibre in a console as calibre-debug -g and post any output you see when the crash happens