It’s taken me ages to locate this information and I don’t want to lose it. I have a couple of clients, the Janne Land Gallery and Momentuos, whose websites use Coppermine. I want to be able to edit the date and time a picture was uploaded.
The trick is to edit the ctime in the MySQL database:
Upload date would be ctime, mtime is last viewed date.
The time’s stored in a special format:
the value you see for ctime is a timestamp, representing a date … The number is the number of seconds which have passed since January 1st 1970.
A handy utility for converting between human time and the number of seconds is Online Tools: Unix Timestamp Converter.
The query itself looks like this:
UPDATE `cpg_pictures` SET ctime='1067890006' WHERE `filepath` LIKE '10001/'