• Resolved Gon?alo Peres

    (@gonperesgmailcom)


    Greetings.

    I’m using the latest NG version (2.0.66.29) and after uploading a new gallery I noticed that the “meta_data” field on table “ngg_pictures” stop saving data as a serialized array.

    Before it would store something like:

    a:17:{s:5:”width”;i:640;s:6:”height”;i:427;s:4:”full”;a:2:{s:5:”width”;i:640;s:6:”height”;i:427;}s:9:”thumbnail”;a:4:{s:5:”width”;i:120;s:6:”height”;i:90;s:8:”filename”;s:33:”thumbs_851-Alexandra-e-George.jpg”;s:9:”generated”;s:21:”0.21434600 1406810041″;}s:8:”aperture”;b:0;s:6:”credit”;b:0;s:6:”camera”;b:0;s:7:”caption”;b:0;s:17:”created_timestamp”;s:25:”30 de Julho de 2014 15:51″;s:9:”copyright”;b:0;s:12:”focal_length”;b:0;s:3:”iso”;b:0;s:13:”shutter_speed”;b:0;s:5:”flash”;b:0;s:5:”title”;b:0;s:8:”keywords”;b:0;s:5:”saved”;b:1;}

    Now the values stored are like this:

    eyJ3aWR0aCI6MTI4MCwiaGVpZ2h0Ijo4NTMsImZ1bGwiOnsid2lkdGgiOjEyODAsImhlaWdodCI6ODUzfSwidGh1bWJuYWlsIjp7IndpZHRoIjoxMjAsImhlaWdodCI6OTAsImZpbGVuYW1lIjoidGh1bWJzXzAwMS1KT0dPLUZVVEVCT0wtMjAxNC5qcGciLCJnZW5lcmF0ZWQiOiIwLjMzNzIwMzAwIDE0MTAyODU0MjMifSwiYXBlcnR1cmUiOmZhbHNlLCJjcmVkaXQiOmZhbHNlLCJjYW1lcmEiOmZhbHNlLCJjYXB0aW9uIjpmYWxzZSwiY3JlYXRlZF90aW1lc3RhbXAiOmZhbHNlLCJjb3B5cmlnaHQiOmZhbHNlLCJmb2NhbF9sZW5ndGgiOmZhbHNlLCJpc28iOmZhbHNlLCJzaHV0dGVyX3NwZWVkIjpmYWxzZSwiZmxhc2giOmZhbHNlLCJ0aXRsZSI6ZmFsc2UsImtleXdvcmRzIjpmYWxzZSwic2F2ZWQiOnRydWV9

    I roled back to NG version 2.0.66, went to “Manage Gallaries”, entered the gallery with the corrupt “meta_data” entries, selected all images and chose the option “Import Metadata” > “Apply”. The “meta_data” field became again a serialized array, with useful data I need to work on some custom theme functions.

    I wonder if this is a new feature, but i’m more inclined to say it is a BUG. I did spend some hours digging in the NG code, but couldn’t find the “culprit”… ??

    Thank you for all the work and i hope you fix this.

    Operating System : Linux (64 Bit)
    Server : nginx/1.4.3
    Memory usage : 16.55 MByte
    MYSQL Version : 5.1.41-3ubuntu12.10-log
    SQL Mode : Not set
    PHP Version : 5.4.13
    PHP Safe Mode : Off
    PHP Allow URL fopen : On
    PHP Memory Limit : 128
    PHP Max Upload Size : 63M
    PHP Max Post Size : 64M
    PCRE Backtracking Limit : 1000000
    PHP Max Script Execute Time : 1200s
    PHP Exif support : No
    PHP IPTC support : Yes
    PHP XML support : Yes
    Graphic Library

    GD Version : bundled (2.0.34 compatible)
    FreeType Support : Yes
    FreeType Linkage : with freetype
    T1Lib Support : No
    GIF Read Support : Yes
    GIF Create Support : Yes
    JPEG Support : Yes
    PNG Support : Yes
    WBMP Support : Yes
    XPM Support : No
    XBM Support : Yes
    JIS-mapped Japanese Font Support : No

    https://www.ads-software.com/plugins/nextgen-gallery/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor photocrati

    (@photocrati)

    @gon?alo Peres – The meta_data is now stored as a base64 encoded string (and has been for a while although it may not appear so if the images are “old”). This information will be updated in most every case with the next save of any of these meta details on any image for that image.

    Also, if you decode it you will find the same details that were there previously … this site is a good quick reference:https://www.base64decode.org/

    Thanks!

    – Cais.

    Thread Starter Gon?alo Peres

    (@gonperesgmailcom)

    Thank you very much for clarifying that. Solved!

    Plugin Contributor photocrati

    (@photocrati)

    @gon?alo Peres – Good to know!

    Thanks for the update.

    – Cais.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘"meta_data" corrupted text on table "ngg_pictures" ?’ is closed to new replies.