Hi SnotRocket,

If you used [extension by plg] Menalto2Piwigo, it should have set the "date added" correctly. From G3 I took the items.created column. Doesn't it match your need?

Here's maybe an example of what I'm (also) having an issue with.

In the "My Family" album from above...

Album shows created on 16 August 2014



First image in the set shows:



It was created on 19 Dec 2011

...... How to I modify Piwigo / database to show that the folder was actually created on 19 Dec 2011 vs 16 Aug 2014.... so that the FOLDERS show oldest to newest or newest to oldest in my gallery?

Any chance that a dev wants to look at my issue?

I'm actually willing to pay someone to fix this, as I'm sure (based on posts here) that others are also having the same issue.... every one of theirs has also gone unanswered.

I've been working in the database... copied date_creation to date_available in the image table - no change.

I looked at the categories table and referenced the representative_picture_id table to the images table to make sure that there was proper date information in the database...

My database is correct.

Just to clarify, in case I haven't... I fully manage my gallery via FTP.  File and directory times are correct at the file system level as well as in the database...

Except I can't find where to edit "This album contains 27 photos, added on Wednesday 1 October 2014."

I'm wondering if I can edit that "Wednesday 1 October 2014" to the proper date, if that will correct my issue.

Mistic says that "It uses the data of the contained photos"....

Can someone be more specific - what contained photo?  The album highlight?  If that's the case... it's still not sorting based on that.

I would believe that a dev knows how or where to look for the reason rather than me beating my head against the wall trying to make it work.

Please, give it a shot yourself - http://thehouseofjohnson.net/gallery  - try to sort... anything.  Albums or photos.

Last edited by SnotRocket (2014-10-15 22:28:56)

Hello

it seems there is several things going one here

you migrated ; you see that the date_available (posted xxx) field is the date of migration and not the one from items.created field from G2 : but did you check if that items.created column was correctly filled in the database?
you say that you "fully manage my gallery via FTP" but those pictures are in /upload not in /galeries so how could you manage them?
"Except I can't find where to edit This album contains 27 photos, added on " since this date in the one the most recent date_available field of the pictrues in it, and since that date_available available is the one the migration, it's consistent
"I've been working in the database... copied date_creation to date_available in the image table - no change." this is where it sounds weird; are you sure that the edition page of those pictures still display 2014?
then if you want to change the album date, it's the lastmodified column you need to change in piwigo_categories. But this field is taken from the pictures inside, so it should be updated somehow -don't know the internal mechanic- if you change the date_available ; piwigo is optimized so it might be a cache or that field is updated when doing a sync

So, I've already gone one step further.

I've done an "UPDATE piwigo_images SET lastmodified = date_creation" and "UPDATE piwigo_images SET date_available = date_creation"

Now, all 3 fields in the database show the exact same date.  (date_available, date_creation and lastmodified)

Sort is still not working.

Now I'm looking at the piwigo_categories table.

"Lastmodified" is all showing my latest sync date (2014-10-15)

I don't see any "date creation" or anything similar in that part of the database.

Last edited by SnotRocket (2014-10-28 15:57:31)

So, a bit further into my issues / documentation.

I have an astonishing number of files without exif dates.



This seems to be at least part of the root of my sort issue.

As I go in and fix my exif info, and then manually, do a sync within piwigo, then copy the date_creation to the date_available fields in the database... things start to work.

But ONLY if I go in as admin and force a sort on the albums and sub albums.

As a user... sort still doesn't work.

Maybe I'm now missing a setting somewhere in my setup that's forcing the admin sort, and not allowing the user to change the sort order?

Is such a feature/setting in piwigo?

Last edited by SnotRocket (2014-10-30 16:00:06)

Not sure that "mistake" is the proper word.

Album sorting, nor image sorting works properly on the user side.  You, as a user, can see that.

What I expect to happen is this:  As a user, I'm clicking the sort icon at the top of the page.. and selecting anything... any sort order.  Let's say oldest to newest or newest to oldest.

I expect that albums would show at the top, and be sorted in my date order that I choose.  I would then expect the images below the albums to also sort new to old, or old to new.

Basically what I expect is this:

Sorted Date - New to Old:

Album 1  |  Album 2 |  Album 3 | Album 4
Album 5  | Album 6  | Album 7  | Album 8
Image 1  |  Image 2 |  Image 3 | Image 4

Then, sorted old to new:

Album 8 | Album 7  | Album 6  | Album 5
Album 4 | Album 3  | Album 2  | Album 1
Image 4 | Image 3  | Image 2  | Image 1


I agree that the theme that I'm using isn't ideal at showing the differences between album and image... but regardless of that... when you sort/order.. nothing changes.


Automatic Album and image ordering by the admin console by forcing the sort order as an admin (new to old, old to new, whatever), seems to be working now that I'm fixing the EXIF info in my database.