View Single Post
Old 08-26-2018, 01:38 PM   #15
bodiccea
Member
bodiccea began at the beginning.
 
Posts: 11
Karma: 10
Join Date: Aug 2018
Device: samsung tablet 8", kitkai
@theducks,

I know last_modified is about metadata change only.
I am less clear about the "date" column. As said, if you make some changes on the book itself (I did read it somewhere it could, if you add a chapter or maybe other changes), this date could be changed too. But again, I am not sure if it is true or not. So using the MAX will be the "secure" way just in case of.

In any case, my main issue (initial question, 1st email of this thread) was to have the file system file modified date the same as the Calibre last_modified date. With or without the MAX function. This is done with my script, which runs once a day a 2:00 AM (it takes seconds to run), the library (changes only) itself is copied to server at 2:30 AM daily.
Don't forget my issue was that that my "last_modified" dates were all lost a few days ago, probably a mistake from me. This is way I changed temporarily the file system date to the "book creation date", which is better, but not good enough, as I think I can recover last_modified from a backup.
bodiccea is offline   Reply With Quote