Quote:
Originally Posted by John Maverick
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
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.