Support » Plugin: WordPress Gallery MaxGalleria » Where in the SQL database is the gallery image data stored?

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.

    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 1 year, 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.