Every Post with Gallery Shows Blank Images

  • beermoney

    (@beermoney)


    8 years, 9 months ago

    So, I imported a folder that is outside of the WordPress directory for a gallery. Everything went nice and smooth. This ia test post BTW. So I deleted the post and then deleted the folder with the images. All is well. I then create a new test post to try everything again and import a new folder again from outside of the WordPress directory and everything goes fine once again. Except this time, when I go to view the post, its showing white boxes with the file names of the images that I had deleted from the previous test. So I delete the post, the image folder and try it all over again…..again everything works fine until I look at the post….its now showing the images from the previous 2 test posts….though the images don’t actually work as they were deleted. So Now the post is filled with white boxes and then the 3 actual images are on page 2.

    Screenshot: http://oi60.tinypic.com/1g0go3.jpg

    When I go to Gallery -> Overview, it shows 24 images, yet there is no images as I had deleted all of them. I checked the folders where the images were outside of the WordPress directory and they were deleted and gone, and then went through the Gallery and NGG folders in the WordPress directory and no images exist. Yet, it still says that 24 images in the Overview.

    What am I doing wrong here? I am stumped and can’t figure out what is causing the issue.

    https://wordpress.org/plugins/nextgen-gallery/

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

    (@photocrati)

    8 years, 9 months ago

    @beermoney – We believe we have sorted out the issue with discrepancies when deleting images … the fix should be in the next release of NextGEN Gallery.

    We also suspect users that had/have this problem should run the following SQL to update their database to remove orphaned entries:

    DELETE FROM 'wp_ngg_picture' WHERE galleryid NOT IN (SELECT gid FROM wp_ngg_gallery)

    Thanks!

    – Cais.

    PS: As always, when working directly in the database please ensure you have a fully verified complete backup in case anything goes sideways unexpectedly.

    Thread Starter beermoney

    (@beermoney)

    8 years, 9 months ago

    OK, so when I try to run that I get an error:

    Error

SQL query:

DELETE FROM 'wp_ngg_picture' WHERE galleryid NOT IN (SELECT gid FROM wp_ngg_gallery)

MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''wp_ngg_picture' WHERE galleryid NOT IN (SELECT gid FROM wp_ngg_gallery)' at line 1

    Also, should it be run from the wp_ngg_picture table or the over all database table? I tried to run it from both, and got the same error either way.

    BTW my SQL version is: 5.5.41-cll-lve

    Flashphill

    (@flashphill)

    8 years, 9 months ago

    I have something similar going on.
    I just went to add a photo to a gallery and discovered that there was a duplicate of the gallery, showing a duplicate set of images on the web page.
    I deleted the duplicate gallery, but now I am left with boxes containing the image file names.
    Also the thumbnail images in the current gallery are all odd dimensions, where the previous thumbs are all identical in size and layout.
    Images are at
    http://bingleyanglingclub.co.uk/photo-gallery/nggallery/page/3
    page 4 only has boxes, but same titles as the last page 3 images.

    Plugin Contributor photocrati

    (@photocrati)

    8 years, 9 months ago

    @flashphill – Please start your own topic so we can try to help you with your specific issue on your specific site.

    See http://codex.wordpress.org/Forum_Welcome#Where_To_Post

    Thanks!

    – Cais.

    Flashphill

    (@flashphill)

    8 years, 9 months ago

    Ok Cais, will do 🙂

    Plugin Contributor photocrati

    (@photocrati)

    8 years, 9 months ago

    @flashphill – Thanks!

    – Cais.

    Benjamin

    (@benjaminowens)

    8 years, 8 months ago

    Hi beermoney,

    I think the SQL you have may have been changed or broken a little during copy/paste. Try the following:
    DELETE FROM wp_ngg_pictures WHERE galleryid NOT IN (SELECT gid FROM wp_ngg_gallery);

    It only needs to be applied to your ($prefix)_ngg_pictures table.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Every Post with Gallery Shows Blank Images’ is closed to new replies.

Tags