Tribulant Slideshow Gallery
[resolved] [Plugin: Slideshow Gallery] Cant assign slides to galleries (5 posts)

  1. jonnymaboy
    Posted 4 years ago #

    I can create galleries and upload images, but when it comes to bringing the two together, nothing happens. I select the required gallery checkbox the image edit form and click Save but every image I've uploaded is still linked to zero galleries.

    In MySQL, there is the correct data in the below tables:


    but no data exists in: wp_gallery_galleriesslides

    I can manually enter data into wp_gallery_galleriesslides and then things work, but obviously this is not a viable option.


  2. gb2048
    Posted 4 years ago #


    I'm getting the same issue with 3.4.1 and also getting the sub-directory issue. Also the tables seem to be created with MyISAM instead of the default InnoDB engine.

    Please kindly fix as soon as possible.



  3. gb2048
    Posted 4 years ago #

    Also using

  4. dad42kids
    Posted 3 years ago #

    I found this in another forum and it worked perfectly. Hope this helps.

    The problem lied within the insert query in the (whatever your wp table prefix is)_galleriesslides table.

    If you locate the db.php file within the helpers folders within the gallery slide plugin and find the following line:
    $galleryslidequery = "INSERT INTO" . $wpdb -> prefix . strtolower($this -> pre) . "_galleriesslides(id,slide_id,gallery_id,created,modified) VALUES ('', '" . $slide_id . "', '" . $gallery_id . "', '" . $date . "', '" . $date . "');";

    and change it to:

    $galleryslidequery = "INSERT INTO" . $wpdb -> prefix . strtolower($this -> pre) . "_galleriesslides(slide_id,gallery_id,created,modified) VALUES ('" . $slide_id . "', '" . $gallery_id . "', '" . $date . "', '" . $date . "');";

    You should be good. Insert queries cannot have blank or null values. the id was being set to nothing, so just removing it solved the issue.

  5. Tribulant Software
    Plugin Author

    Posted 3 years ago #

    Thank you for posting the solution @dad42kids

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Tribulant Slideshow Gallery
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic