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 06-08-2018, 02:50 PM   #1
hornetoli
Junior Member
hornetoli began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Jun 2018
Device: SONY PRS-T1
Metadata edit error

Dear all,

I have been using Calibre succesfully and gratefuly for several years now.
Currently I am running the latest version 3.25.0 64bit on my Windows 10 machine.

My database had been growing over the past years and I didn't encounter any issue. But since ~May this year I am suddenly having issues with editing metadata.

When I press the edit metadata button, attached error message will appear. Irrespective of the type of ebook format, age of entry (existing or new) etc.
This didn't happen before on the same machine with same OS etc. Only Calibre might have been a previous version.

I already tried to remove and clean Calibre and install freshly without success.

Kindly ask the expert for a hint what it could be and ideally for some support how to solve.

Thx!

Kind regards, hornetoli
Attached Thumbnails
Click image for larger version

Name:	Calibre.jpg
Views:	139
Size:	24.7 KB
ID:	164381  
hornetoli is offline   Reply With Quote
Old 06-08-2018, 03:13 PM   #2
DaltonST
Deviser
DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!
 
DaltonST's Avatar
 
Posts: 1,222
Karma: 100494
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
That is a bug, but you must run Calibre in Debug Mode to capture the debugging information. Post that log file back here so the bug's owner can fix it. Hover your mouse under Preferences to see the Debug Mode restart option. After restarting, cause that error several times with different books, then exit from Calibre. Save the log that is displayed.
DaltonST is offline   Reply With Quote
Advert
Old 06-08-2018, 06:51 PM   #3
hornetoli
Junior Member
hornetoli began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Jun 2018
Device: SONY PRS-T1
Hi DaltonST & all,

thx for the instructions - kindly find attached the according log file.

Kind regards, hornetoli
Attached Files
File Type: txt tmpo5xko7.txt (8.5 KB, 63 views)
hornetoli is offline   Reply With Quote
Old 06-08-2018, 09:39 PM   #4
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 33,402
Karma: 10205094
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
That's an interesting error, it indicates something really weird has happened to you database, it has number in the series column instead of text for some books. Attach the metadata.db file from your calibre library folder and I could tell you more.
kovidgoyal is offline   Reply With Quote
Old 06-09-2018, 04:41 AM   #5
hornetoli
Junior Member
hornetoli began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Jun 2018
Device: SONY PRS-T1
Hi kovidgoyal,

kindly find the metadata DB attached.

kind regards, hornetoli
Attached Files
File Type: gz metadata.db.gz (886.7 KB, 73 views)
hornetoli is offline   Reply With Quote
Advert
Old 06-09-2018, 02:02 PM   #6
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 33,402
Karma: 10205094
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
THanks, I'll take a look at it when I have a moment, in the meantime, you can probably recover your database using the Library maintenance restore database tool.

Right click the calibre icon on the main toolbar in the calibre window, choose library maintenance and restore database.
kovidgoyal is offline   Reply With Quote
Old 06-09-2018, 05:01 PM   #7
hornetoli
Junior Member
hornetoli began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Jun 2018
Device: SONY PRS-T1
Dear kovidgoyal,

thx a lot - worked like a charm!

Restoration seems completed with only few warnings / errors:

calibre, version 3.25.0
ACHTUNG: Erfolgreich: Wiederherstellung der Datenbank wurde erfolgreich mit einigen Warnungen durchgeführt. Klicken Sie für weitere Informationen auf "Details anzeigen". Die alte Datenbank wurde unter folgendem Namen gespeichert: E:\Calibre Library\Komplett\metadata_pre_restore.db

Failed to restore the books in the following folders:
E:\Calibre Library\Komplett\Tintenherz\Tintenherz (7336) with error:
Traceback (most recent call last):
File "site-packages\calibre\db\restore.py", line 255, in restore_books
File "site-packages\calibre\db\cache.py", line 63, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 2071, in restore_book
File "site-packages\calibre\db\cache.py", line 1559, in create_book_entry
File "site-packages\calibre\db\backend.py", line 845, in execute
File "c:\t\t\apsw-j6gj96\apsw-3.13.0-r1\src\cursor.c", line 236, in resetcursor
ConstraintError: ConstraintError: UNIQUE constraint failed: books.id


That doesn't look to serious to me and can be fixed.
And most important - edititing metadata seems to work again good!

Thank you very much - dhanyavaad!

kind regards, hornetoli
hornetoli is offline   Reply With Quote
Old 06-09-2018, 09:25 PM   #8
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 33,402
Karma: 10205094
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
I took a look at the db file and it looks like database corruption, there are basically a few entries in the series table with very high id numbers and nueric values for the series name. Sadly there's no way to know how they got into the database. Keep any eye out, if it recurs, try to narrow down what yu were doing just before the problem happened.
kovidgoyal is offline   Reply With Quote
Old 06-10-2018, 03:31 PM   #9
hornetoli
Junior Member
hornetoli began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Jun 2018
Device: SONY PRS-T1
Will do so and thx again!
hornetoli 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
Edit Title Field in Edit Metadata window goldilocks Library Management 7 11-08-2015 10:09 PM
Error when doing multiple metadata edit bigbird1227 Calibre 2 02-22-2014 12:02 PM
Error: I can't edit metadata PinkUsamimi Library Management 7 12-02-2012 11:22 PM
0.8.60 Edit metadata error pbw Calibre 3 07-20-2012 01:56 AM
Bulk metada edit error trying to edit tags Purple Lady Calibre 8 02-17-2011 06:09 PM


All times are GMT -4. The time now is 06:27 PM.


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