WordPress.org

Ready to get started?Download WordPress

Forums

NextGEN Gallery
[resolved] Wrong meta data imported and wrong sorting (50 posts)

  1. mummihuhn
    Member
    Posted 1 year ago #

    Hi.

    Since the latest version of nextgen-gallery 1.912 the thumbnails are not in the right order.

    The date which has been imported ist 1.jan 1970 for every picture.

    does anybody know how to fix this problem?

    cheers

    Ralph

    http://wordpress.org/extend/plugins/nextgen-gallery/

  2. andybrownphotography
    Member
    Posted 1 year ago #

    I also have the same problem since updating to 1.9.12, it appears that older images are having their dates changed and new ones are getting 1 Jan 1970 even though their metadata is correct. Any ideas anyone?

    Regards,

    Andy

  3. lnichetti
    Member
    Posted 1 year ago #

    I also have the same problem since installing 1.9.12. Please fix this issue because I have 2 running sites depending on this plugin!

  4. lnichetti
    Member
    Posted 1 year ago #

    I confirm what [andybrownphotography] said: pictures metadata seems to be imported correctly, but all images uploaded after upgrading nextGenGallery to 1.9.12 have the same date (1 Jan 1970), so the sorting by date does not work as expected

  5. mauvan
    Member
    Posted 1 year ago #

    Same here. Seems to a problem since last update (or 1.9.11).
    I need it because images from different camera's need to be sorted by date.

  6. Simon
    Member
    Posted 1 year ago #

    I have the same problem. All photos imported with 1.9.10 have the correct date, all imported after the update to 1.9.12 appear as 1 Jan 1970, though the metadata shows the correct date.

    Seems the conversion to Unix Timestamp (http://www.unixtimestamp.com/index.php) goes wrong and the default value ends up in the database.
    Edit: Indeed, the imagedate field in the ngg_pictures table is '1970-01-01 00:33:33' for all new images..

  7. Simon
    Member
    Posted 1 year ago #

    Update: I've replaced lib\meta.php with the one from 1.9.10 and it works fine again when importing images.

    The function get_date_time() is not working for me anymore in 1.9.12.

  8. mauvan
    Member
    Posted 1 year ago #

    @simon: so we have to re-import all images again (?)
    Hopefully there will be an update real soon.

  9. Simon
    Member
    Posted 1 year ago #

    I've quickly looked through the code, and it may be enough to

    • Revert lib\meta.php to 1.9.10 state*
    • Check/Select the pictures that have invalid imagedate in the gallery
    • Pick 'Import Metadata' from the Combobox and execute it

    I've not tested this (I manually updated the database..), but it looks like get_date_time() is called when doing this.

    * If you don't have an old copy of nggallery, the internet's long time memory has it.

  10. photocrati
    Member
    Plugin Author

    Posted 1 year ago #

    If you all wouldn't mind submitting a bug report here, it will go directly to our developers to look into. We'll hopefully have a fix for this included in our next upgrade.

    Thanks!

  11. Simon
    Member
    Posted 1 year ago #

    Thanks for the link! Bug report is submitted.

  12. andybrownphotography
    Member
    Posted 1 year ago #

    Bug report submitted, thanks

  13. photocrati
    Member
    Plugin Author

    Posted 1 year ago #

    Thanks @Simon & @andybrownphotography :) Bug report received!

  14. EdLeckert
    Member
    Posted 1 year ago #

    Looking forward to the fix. Hacking the db for every uploaded image is not fun. :-)

  15. photocrati
    Member
    Plugin Author

    Posted 1 year ago #

    I am going to mark this thread as resolved, because we will be looking into resolving this in the next upgrade. Please continue to submit your bug reports if you haven't already if you are experiencing this error.

    Thanks!

  16. markcorder
    Member
    Posted 1 year ago #

    I just submitted mine - same problem...

    I'll note that I just tried a fresh installation of WP 3.5.1 on a localhost setup - then installed NGG 1.9.12 only with NO other plugins installed or running - and the very same thing happened : After creating a Gallery, all photos added to it get the date "January 1, 1970".

  17. JohnTheViking
    Member
    Posted 1 year ago #

    I'm using this SQL until an update is available:

    UPDATEwp_ngg_pictures`
    Set imagedate =
    Concat(
    SUBSTRING(meta_data, LOCATE('"created_timestamp";s:16:"',meta_data ) +32, 4 )
    ,"-",SUBSTRING(meta_data, LOCATE('"created_timestamp";s:16:"',meta_data ) +29, 2 )
    ,"-",SUBSTRING(meta_data, LOCATE('"created_timestamp";s:16:"',meta_data ) +26, 2 )
    ," ",SUBSTRING(meta_data, LOCATE('"created_timestamp";s:16:"',meta_data ) +37, 2 )
    ,":",SUBSTRING(meta_data, LOCATE('"created_timestamp";s:16:"',meta_data ) +40, 2 )
    ,":00"
    )
    WHERE imagedate < '1971-01-01'`

  18. sficht
    Member
    Posted 1 year ago #

    Unfortunately, importing the Metadata again is not enough - it shows the right data under "meta" but sorts the pictures by filedate or whatever - had to delete my pictures and upload them again with the older meta.php. Only then it worked. :-(

  19. ozzyoBR
    Member
    Posted 1 year ago #

    there is one workarounod, try to upload the images without EXIF info (if exporting from lightroom use copyright only)

    that worked for me... too bad I need to have the EXIF data in the pictures

  20. gsfergusson
    Member
    Posted 1 year ago #

    Any ETA on getting this problem fixed? NextGen is a popular plugin and this is a very annoying problem!

  21. gsfergusson
    Member
    Posted 1 year ago #

    Incidentally, I've tried Simon's suggestion and replaced lib\meta.php with the one from 1.9.10 and I agree, the problem is fixed, for newly uploaded pictures anyways. Importing new meta data on a previously uploaded picture only changes the date to the upload date, which I suppose is better than 1 January 1970...

    I await a real fix from NextGen.

  22. wagnerbm01
    Member
    Posted 1 year ago #

    I am having the same problem. The developers do not seem to be very interested in either fixing this problem or even responding to it. Why would anyone want to pay for any of their upgrades or themes if they will not even respond to this problem?

  23. photocrati
    Member
    Plugin Author

    Posted 1 year ago #

    @wagnerbm01 - As stated in our last reply [here], we are planning on including a fix for this in the next upgrade. v2.0 Beta is right around the corner and will hopefully be available within the next few weeks. Included in the Beta is a solution for this issue.

  24. pleasefixthis
    Member
    Posted 1 year ago #

    @photocrati - could you please confirm whether this will fix retrospectively without the need to upload the images again?

  25. desertroseknits
    Member
    Posted 12 months ago #

    I'm having the same issue as the previous posters. Any new info on when the next upgrade - with this fix - will be released, and if it will fix the dates for images already uploaded?

  26. jklupfel
    Member
    Posted 11 months ago #

    I'm having the same issues.
    Any news on when it's fixed?

  27. Zoinks! Graphics
    Member
    Posted 11 months ago #

    @photocrati if it's simply a matter of reverting lib\meta.php to the 1.9.10 state, wouldn't that more than justify a 1.9.13 update? Rather than waiting 2+ months -- or however long it will take for the new 2.0 to come out? Just saying, this is a documented issue that numerous users are experiencing, and developer relief would be appreciated sooner than later. Thanks for all you do!

    And thanks @Simon for all the helpful info!!

  28. Martin Bay
    Member
    Posted 11 months ago #

    Just came across this... ugh. This is a stupid problem we have to deal with - give us an update. @photocrati

  29. photocrati
    Member
    Plugin Author

    Posted 11 months ago #

    Hey all, we are currently discussing if we are able to do a 1.9.13, because v2.0 is right around the corner. We are currently testing this next upgrade and will be releasing it first as a Beta. v2.0 does include a fix for this, and you shouldn't have to re-upload images. The meta should fix itself with the update. We may go ahead with v2.0 rather than do a v1.9.13, as they would be back to back updates. If we do v1.9.13, that would likely be available within the next week or two. v2.0 should hopefully be available within the next few weeks. We apologize for the inconvenience this meta bug has caused, and want to assure you that v2.0 does include a fix and we'll get that out to all of you as soon as possible.

  30. mauvan
    Member
    Posted 11 months ago #

    I certainly hope for a stable 2.0(.x)!
    This issue is also causing a wrong date in (SEO) xml sitemaps for ngg-tags ánd the xml-file itself is dated 1-1-1970.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic