wp_options to many records

Yes, it’s back with a new errors.

Here is solution:
$sql = "DELETE FROMcn_optionsWHEREoption_namelike '_transient_%' ORoption_namelike 'displayed_galleries%' ORoption_name` like ‘displayed_gallery_rendering
%'”;`

But my patience is over. Deleted the gallery, now I am using WP Photo Album Plus.

Damit wird das Problem ja noch gr?sser und killt jede “gut” besuchte Seite .

Also my patience is over too. @ragelt How did you definitely remove Nextgen Gallery from your db and website?

Thanks

I’m still getting this error too. Upgraded my WAMP development system on my local pc to WordPress 3.8 and NextGen 2.0.40 and one click of the gallery generated 20 wp_options entries!
Have disabled the plugin on my live site using NextGen and run the sql to delete the records from wp_options. No galleries for now, but if they don’t fix it soon we’ll have to change the image software.
Thankfully we use Coppermine on the biggest site I run!

This is happening to me, too, in version 2.0.40. Had to deactivate the plugin to avoid it bringing my entire site down.

All – We are bringing in more improvements for how transients are handled and cleared with our next release, including the ability to specify the TTL for when the caches are cleared.

We expect this to have a significant impact on this issue.

Thanks!

– Cais.

Please remove caching from wp_options. It’s the wrong place for that!

Any ETA on those improvements Photocrati? This is causing me hours upon hours of work and a very frustrated client. Thanks!

RagelT (or anyone) where do I put this code?

$sql = "DELETE FROMcn_optionsWHEREoption_namelike '_transient_%' ORoption_namelike 'displayed_galleries%' ORoption_name like ‘displayed_gallery_rendering
%'”;`

Thanks!

heres a ready to run script: https://goo.gl/8PNfqi

Scripts to delete are all very well but they don’t reset the autoincrement id field so eventually it will crash.

Right. But this can crash also when the nextgen gallery cleans his entries….

My statement is very clear: Cashing is in a wrong place on the wp_options table….

including the ability to specify the TTL for when the caches are cleared.

I see this listed in the changelog.. where is it in the plugin settings?

Can someone please explain how to enable the cache deletion and cron automation released recently that fixes this?

@jesse S – Most of the new “constants” that you are referring to were noted in the 2.0.57 changelog and are to be used in the wp-config.php file appropriately.

I also see you may have submitted a Bug Report related to this, our Support Team can continue the conversation there for your specific issue.

Thanks!

– Cais.