'Sometimes' timestamp column has incorrect data

Bug #2069494 reported by _dan_
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
calibre
Invalid
Undecided
Unassigned

Bug Description

I added 3 books via Drag and Drop to calibre at the same time, two books got the correct timestamp in the books table, one book got '0101-01-01 00:00:00+00:00' instead which results in problems with connected apps.
last_modifed displays the correct date though.
I am using calibre 7.12 on macOS.

Revision history for this message
Kovid Goyal (kovid) wrote :

Fixed in branch master. The fix will be in the next release. calibre is usually released every alternate Friday.

Changed in calibre:
status: New → Fix Released
Revision history for this message
_dan_ (dan-void) wrote :

Still happening.
Added a new book, table books, timestamp -> 0101-01-01 00:00:00+00:00
Calibre 7.13 macOS

Changed in calibre:
status: Fix Released → New
Revision history for this message
Kovid Goyal (kovid) wrote :

Does not replicate for me. Adding a new book either sets the date to the current time or the value of the timestamp metadata in the book.

Changed in calibre:
status: New → Invalid
Revision history for this message
_dan_ (dan-void) wrote :

I can reproduce it with a new library.
When I first add the book, the timestamp is current time but after downloading (manually) metadata (Goodreads, with Goodreads ID) timestamp is then 0101-01-01 00:00:00+00:00

Changed in calibre:
status: Invalid → New
Revision history for this message
_dan_ (dan-void) wrote :

Adding a different book, clearing metadata and putting 'Goodreads:60929' in the ID field then pressing download metadata ends in the incorrent timestamp as well.

Changed in calibre:
status: New → Invalid
Revision history for this message
Kovid Goyal (kovid) wrote :

So then report the issue to the author of whatever metadata plugin is giving you that date. None of the builtin plugins do that.

Revision history for this message
_dan_ (dan-void) wrote :

Did not realise the plugin was the culprit. Thank you!

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.