Hi,
I have a new deployment (Docker using the Linuxserver.io image). All if my images are stored in a directory structure on a separate file share, so I am using the FTP synchronization option. This worked great to import all of my images and albums. But, all of my albums have a "created on" date of yesterday when I did the import. As a result, I can't sort them by date created. This means that I have to manually order all sub-albums, and new ones get created at the end of the list. I'd like to use newest -> oldest automatic ordering, but that puts my existing albums out of order.
Is there any way to manually modify the album created date so that I can fix the order of the existing albums when I use newest -> oldest ordering?
Thanks!
Details:
Piwigo 12.3.0
Operating system: Linux
PHP: 7.4.26 (Show info) [2022-08-16 21:11:50]
MySQL: 5.5.5-10.5.16-MariaDB-log [2022-08-16 21:11:50]
Graphics Library: ImageMagick 7.0.11-14
Offline
Hi,
You can find the album created date in the database, in the piwigo_activity table, scattered with differents events.
Each category has an object (named "album"), an object_id and an occured_on (the creation date).
By the way, its not a very good idea to manually modify that.
Rgds
Offline
Thanks for the reply. That piwigo_activity table seems to be a log of all actions done by an admin. So, I guess I have a few questions.
1) Is that really where the Album Created On date comes from?
2) Is there a "correct" way to change that date?
3) What are the possible issues from changing those records?
I'll take a database backup and try to change those, but I'm curious if there's a better way to do this.
Offline
This table is a log of all actions, you will find who did the action looking at performed_by.
1) It's the creation date displayed when you edit the album, for example : /admin.php?page=album-1
2) Perhaps a plugin can do that but I don't know it.
3) I don't know neither, none I hope so. Maybe you have no other choice.
Offline
I took a look at the php code. You're absolutely right, that is where the album created dates come from. I have changed several of my albums so far, and that seems to be working. I'll post back if I find any weird issues from messing with the dates.
Thanks again for the help, it would have taken me forever to piece that together without it.
Offline