Database repair? or what? - Page 2

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

Quote:

Originally Posted by emphasis

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.

It is saying that there is one file (metadata.opf) where authors are supposed to be. This particular case is a known problem, fixed in 0.7.25. The file can be deleted.

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

kovid - ran the calibre-debug -g, Ran several 'good books' and nothing appeared in the 'black command window'. Then when I clicked on the bad book the following appeared in BCW

qcolor:: setnamecolor: unknown color name 'fffffff'
qtexthtmlparser :: applyAttributes unknown color name 'ffffff'

[is there a way to copy this from the BCW?

Thanks

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

That helps, it seems like the html in the comments of that book is causing the crash in Qt. Try hiding the book details pane (press shift+alt+d or click the tiny book icon in the bottom right corner) and see if that fixes the crash.

chaley · 10-30-2010, 01:11 PM

Quote:

Originally Posted by emphasis

[is there a way to copy this from the BCW?

Right-click on the BCW, choose 'Mark', drag the mouse pointer over what you want to copy (which highlights it), and hit return.

emphasis · 10-30-2010, 04:56 PM

Kovid

I have updated to 7.26
I have hidden the book details pane

NOTHING HAS CHANGED

I can not delete the book, edit the book, etc because the program is not recognizing the book. Whether I attempt to place my mouse on the line or using the up/down arrows to go to the line the program just dies!

It is good that you identified the problem, now how do i correct it.

Jerry

emphasis · 10-30-2010, 04:57 PM

Chaley -

thanks but how/where do I choose 'mark'?

kovidgoyal · 10-30-2010, 05:03 PM

Well 0.7.26 had no changes that would affect your issue, so I'm not surprised it didn't help

As for fixing the problem you will have to use the command line tools to do that:

Run

calibredb list > output.txt

Then run

notepad.exe output.txt

That will give you a list of books with id numbers in the left most column. Fin the id number of your problem book and then run

calibredb remove id_number

where id_number should be the number you found

chaley · 10-30-2010, 05:33 PM

Quote:

Originally Posted by emphasis

Chaley -

thanks but how/where do I choose 'mark'?

It is in the context menu when you right-click in the BCW.

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

Kovid - I understand your instructions, just not positive how to accomplish.

I run calibredb list > output.txt and the black command window opens and I can see the program and creating the file and then when finished running the window closes.

So then I run notepad.exe output.txt and notepad opens but with a message saying cannot find output.txt file. I tried to find it but could not. Where did the file go? did I do something wrong? did I not do something?

BTW the fix certainly sounds simple enough. I appreciate your assistance.

Jerry

kovidgoyal · 10-30-2010, 08:19 PM

Open the console first, then run the commands.

typre cmd.exe in the run box to open the console

emphasis · 10-30-2010, 09:27 PM

Kovid (and the others who responded) -

Thanks for all your help.

I have eliminated the problem and now Calibre is working correctly.

FYI - after repairing I readded the book that was the problem and program worked fine. I then edited/downloaded metadata using isbn number and also downloaded the cover. Pregram DID NOT run correctly, same problem as before.

I did repair and it worked OK. I only added the cover and it worked OK. Am leaving it the way it is.

Jerry

kovidgoyal · 10-30-2010, 09:35 PM

Would you mind posting or PMing the title/author/isbn number of the book so I can try to fix the underlying problem.

emphasis · 11-01-2010, 09:31 PM

Kovid - The Book is 1776 and the ISBN 978-0743226721

Thanks for your help

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

Thanks will be fixed in the next release

Beau · 11-02-2010, 02:20 AM

I'm sorry, I'm still not understanding how to find and open the command line (in windows) to run the tools listed above. I think my problem is similar. can anyone explain further?

Thanks

10-30-2010, 12:52 PM	#17
emphasis Member Posts: 18 Karma: 10 Join Date: Oct 2010 Device: Nook	kovid - ran the calibre-debug -g, Ran several 'good books' and nothing appeared in the 'black command window'. Then when I clicked on the bad book the following appeared in BCW qcolor:: setnamecolor: unknown color name 'fffffff' qtexthtmlparser :: applyAttributes unknown color name 'ffffff' [is there a way to copy this from the BCW? Thanks Last edited by emphasis; 10-30-2010 at 01:02 PM.

11-01-2010, 09:31 PM	#28
emphasis Member Posts: 18 Karma: 10 Join Date: Oct 2010 Device: Nook	ISBN Kovid - The Book is 1776 and the ISBN 978-0743226721 Thanks for your help

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-30-2010, 12:55 PM	#18
kovidgoyal creator of calibre Posts: 45,364 Karma: 27230406 Join Date: Oct 2006 Location: Mumbai, India Device: Various	That helps, it seems like the html in the comments of that book is causing the crash in Qt. Try hiding the book details pane (press shift+alt+d or click the tiny book icon in the bottom right corner) and see if that fixes the crash.

10-30-2010, 04:56 PM	#20
emphasis Member Posts: 18 Karma: 10 Join Date: Oct 2010 Device: Nook	Kovid I have updated to 7.26 I have hidden the book details pane NOTHING HAS CHANGED I can not delete the book, edit the book, etc because the program is not recognizing the book. Whether I attempt to place my mouse on the line or using the up/down arrows to go to the line the program just dies! It is good that you identified the problem, now how do i correct it. Jerry

10-30-2010, 04:57 PM	#21
emphasis Member Posts: 18 Karma: 10 Join Date: Oct 2010 Device: Nook	Chaley - thanks but how/where do I choose 'mark'?

10-30-2010, 05:03 PM	#22
kovidgoyal creator of calibre Posts: 45,364 Karma: 27230406 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Well 0.7.26 had no changes that would affect your issue, so I'm not surprised it didn't help As for fixing the problem you will have to use the command line tools to do that: Run calibredb list > output.txt Then run notepad.exe output.txt That will give you a list of books with id numbers in the left most column. Fin the id number of your problem book and then run calibredb remove id_number where id_number should be the number you found

10-30-2010, 08:16 PM	#24
emphasis Member Posts: 18 Karma: 10 Join Date: Oct 2010 Device: Nook	Kovid - I understand your instructions, just not positive how to accomplish. I run calibredb list > output.txt and the black command window opens and I can see the program and creating the file and then when finished running the window closes. So then I run notepad.exe output.txt and notepad opens but with a message saying cannot find output.txt file. I tried to find it but could not. Where did the file go? did I do something wrong? did I not do something? BTW the fix certainly sounds simple enough. I appreciate your assistance. Jerry

10-30-2010, 08:19 PM	#25
kovidgoyal creator of calibre Posts: 45,364 Karma: 27230406 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Open the console first, then run the commands. typre cmd.exe in the run box to open the console

10-30-2010, 09:27 PM	#26
emphasis Member Posts: 18 Karma: 10 Join Date: Oct 2010 Device: Nook	Kovid (and the others who responded) - Thanks for all your help. I have eliminated the problem and now Calibre is working correctly. FYI - after repairing I readded the book that was the problem and program worked fine. I then edited/downloaded metadata using isbn number and also downloaded the cover. Pregram DID NOT run correctly, same problem as before. I did repair and it worked OK. I only added the cover and it worked OK. Am leaving it the way it is. Jerry

10-30-2010, 09:35 PM	#27
kovidgoyal creator of calibre Posts: 45,364 Karma: 27230406 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Would you mind posting or PMing the title/author/isbn number of the book so I can try to fix the underlying problem.

11-01-2010, 10:29 PM	#29
kovidgoyal creator of calibre Posts: 45,364 Karma: 27230406 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Thanks will be fixed in the next release

11-02-2010, 02:20 AM	#30
Beau Connoisseur Posts: 77 Karma: 132 Join Date: Jul 2007 Device: Sony 700, ipod Touch, iphone, Galaxy Tab	I'm sorry, I'm still not understanding how to find and open the command line (in windows) to run the tools listed above. I think my problem is similar. can anyone explain further? Thanks

Advert

Advert