wp_options table gets bloated with NGG entries

@acekin – Do you see similar results if you use the clear image cache under Gallery > Other Options > Miscellaneous?

– Cais.

There are not many files in the Gallery/cache folder if that is where you keep them. What I see are actually code snippets that look like what I pasted below. This is since I cleaned all of them this morning and it is under “_transient_f4d8ec…..”. There are many of them along with “displayed_gallery_rendering_…….” which has a much simpler entry, just a string of numbers like 1403540562.

This bloat as I am finding out is not limited to NextGEN, it seems to be a problem stemming from many plugins and WordPress using wp_options as a garbage disposal without anybody actually disposing them. The table keeps growing in size. When I noticed it first my wp_options table was close to 20MB, most of which being junk. This needs to be addressed at a core level and plugin developers need to play nice and clean their crud. Some leave entries even after uninstalling the plugin, that is a shame.

Cemal

Here is the code snippet in the wp_options file, with many many more:

<div
class=”ngg-galleryoverview ngg-ajax-pagination-none”
id=”ngg-gallery-af1d16c654407a1113848d2c0232b1d9-1″>

<!– Thumbnails –>
<div id=”ngg-image-0″ class=”ngg-gallery-thumbnail-box” >
<div class=”ngg-gallery-thumbnail”>
<a href=”https://www.keptlight.com/klblog/wp-content/gallery/soapmakers/mg_6011-12.jpg&#8221;
title=”Making Soap, general view of upstairs”
data-src=”https://www.keptlight.com/klblog/wp-content/gallery/soapmakers/mg_6011-12.jpg&#8221;
data-thumbnail=”https://www.keptlight.com/klblog/wp-content/gallery/soapmakers/thumbs/thumbs_mg_6011-12.jpg&#8221;
data-image-id=”5765″
data-title=”Making Soap, general view of upstairs”
data-description=”Making Soap, general view of upstairs”
rel=”lightbox[af1d16c654407a1113848d2c0232b1d9]”>
<img
title=”Making Soap, general view of upstairs”
alt=”Making Soap, general view of upstairs”
src=”https://www.keptlight.com/klblog/wp-content/gallery/soapmakers/thumbs/thumbs_mg_6011-12.jpg&#8221;
width=”89″
height=”134″
style=”max-width:none;”
/>

</div>
</div>
<—- snipped section to save space —->

<div id=”ngg-image-1″ class=”ngg-gallery-thumbnail-box” >

<div class=”ngg-clear”></div>
</div>

@acekin – If you perceive this as a WordPress core issue, this is not the place to have it addressed … they simply will not look here for this sort of report.

What was the result of you clearing the image cache?

Once again, like many times in the past, if you see this as a bug you are always welcome to submit a Bug Report (https://www.nextgen-gallery.com/report-bug/) with your site specifics.

Thanks!

– Cais.

I cleared the image cache in NGG and this is after that. There are many more entries since I copied and pasted this.

Yes, I am reporting this as a NextGEN issue here. The reference to a wider problem was “editorial comment”. I will write it directly to WordPress as well. But the entries created specifically by NextGEN multiply like rabbits ?? I am also going to submit this as a bug.

Cemal

@acekin – Thanks for the Bug Report we can continue this conversation there for the time being.

– Cais.