Where in the SQL database is the gallery image data stored?

  • Resolved cudak888

    (@cudak888)


    6 years, 9 months ago

    I’m presently migrating a site from FooGallery to MaxGalleria by batch replacing SQL entries.

    Perhaps this is a bit unconventional, but since I have to migrate over 150 existing galleries (with anywhere from 10-100 photos per gallery), it makes sense.

    This said, while I have had no problem moving over the galleries themselves (replacing post_type from FooGallery to MaxGalleria in wp_posts does that exceptionally well), moving the photos within each gallery has become a bit of a problem.

    I’ve had no trouble locating the individual entries for each FooGallery – they store the per-gallery image data under foogallery_attachments as a meta_key. However, I have gone so far as to create a clean copy of WordPress with just MaxGalleria installed, and I still can’t find where MaxGalleria is storing its per-gallery image data.

    Can you help out here? In the worst of cases, I’m considering migrating the FooGalleries to NextGEN using SQL, and then importing NextGEN into MaxGalleria with your import tool.

    Please do let me know. Thank you!

    -KK

    • This topic was modified 6 years, 9 months ago by cudak888.
    • This topic was modified 6 years, 9 months ago by cudak888.
    • This topic was modified 6 years, 9 months ago by cudak888.
    • This topic was modified 6 years, 9 months ago by cudak888.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author AlanP57

    (@alanp57)

    You will find that the gallery images are post type attachment with the ID of the gallery in the post_parent field and the order of images stored in the menu order field. This means that an image in the media library can only belong to one gallery. Thus, if an image needs to be in more than one gallery, you need to create a second attachment record that points to the same image.

    Thread Starter cudak888

    (@cudak888)

    Found it, thanks! The association of the photos with a single gallery shouldn’t be an issue.

    Strangely enough, I decided to experiment with the database and batch-converted everything to MaxGallery. This seemed to clear all the images out of each gallery, but if I individually opened each gallery as a photo gallery (as opposed to a video gallery), all the photos would repopulate.

    I did lose categories and featured images in the process, so it’s not that much work to get most of these squared away (though it would be nice to know where the photo/video gallery setting is stored in SQL – I could fix these all with a simple batch function if I knew).

    EDIT: Found them under maxgallery_type image and maxgallery_template image-tiles in wp_postmeta. Batch fix here we go.

    Thanks again!

    -KK

    • This reply was modified 6 years, 9 months ago by cudak888.
    Plugin Author AlanP57

    (@alanp57)

    You will find the gallery type is stored in the postmeta table with the meta_key, ‘maxgallery_type’.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Where in the SQL database is the gallery image data stored?’ is closed to new replies.