View Single Post
Old 07-27-2022, 11:10 AM   #2
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 47,105
Karma: 169815798
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
Quote:
Originally Posted by John Maverick View Post
Yesterday I added 3 columns to a library with 30K of books downloaded with the plugin FanFicFare. The problem is that after doing the restart that Calibre asked, the column "last_modified" for all the books was changed to yesterday date. So now I can't use that column to sort my books for last updated (or at last last changed).
You have modified the library entry and yes, that will update the last modified column. I have been surprised on several occasions by what trigger an update of the last modified column .

Quote:
Originally Posted by John Maverick View Post
There is some way to recover the original values of "last_modified" column?

I do have backups of my library, but I was hoping to use them as a last resort.

Also, Is changing the is the last_modified column to the current time the expected behavior when adding new columns to a library?

if that is the case, there is some way to add new columns to a library without changing the last_modified column?
The database has been written so, AFAIK, no way to restore the old values. Not that it does you much good now but you can use one of the Job Spy's functions to save and restore the last modified column values. Personally I use a custom column to record when I last edited/modified an ebook since the last modified date is affected by way too many possibilities to be worth using.

As for your last questions, yes that is the expected behaviour. You are modifying the library entry and that is reflected in the last modified date.

If there is a way of adding columns without updating the last modified value, either chaley or kovidgoyal are likely the best people to answer that question. I suspect the answer will be no.
DNSB is offline   Reply With Quote