http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7241 --- Comment #25 from Adrien SAURAT <adrien.saurat@biblibre.com> --- Ok, I made a test with this request and it modified all the timestamps of my updated rows. That's because this field is designed to store the date of each sql update: `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, It seems to me that, for these logs, the important date is the "library action" date and not the "last SQL modification" date. --- I suggest adding also the following line before the UPDATE: ALTER TABLE action_logs CHANGE timestamp timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP; The timestamp will still be automatically set when creating a row, but updating won't change the original date/time. -- You are receiving this mail because: You are watching all bug changes.