Chintaru
Member
Posted 8 months ago #
Hi,
I have included galleries on their own pages using the nggallery shortcode. However, after updating a few thumbnails, two of my galleries suddenly stopped working and all I get when I visit the pages containing the galleries is:
[Gallery not found]
Even though the galleries still exist and contain images. I've already tried to restore from backup but results in "File do not exists" errors for all image IDs in the gallery, despite the fact that they DO exist (in the gallery and in their folders on the server)!
This is extremely frustrating as I can't seem to get the galleries to work anymore and I really don't want to reupload 100+ images... Any help please?
http://wordpress.org/extend/plugins/nextgen-gallery/
Chintaru
Member
Posted 8 months ago #
After investigating, it seems that the exclude column in the database got messed up and broke the link between the images and its gallery. I don't know how this happened, but at least there's a fix:
UPDATE 'wp_ngg_pictures' SET 'exclude'=[value] WHERE 'galleryid'=[value]
With [value] being the id of the gallery.
Chintaru
Member
Posted 8 months ago #
The problem still persists... For some reason, sometimes uploads get set to 'exclude' in the database and won't show up on the frontend. Ofcourse, with this I can turn ALL the exclusions off:
UPDATE wp_ngg_pictures SET exclude=0
and with the code in my previous post I could turn if off for images per gallery but I'd like to know if there is a more permanent fix for this. I'm not sure why or how it occurs as it seems to happen right after uploading or just out of nowhere. The last batch of images, for example, were all somehow excluded in the database (the images weren't ticked as excluded in the admin panel afaik).
Any help/ideas is/are ofcourse appreciated.
