Thread Starter
Susa38
(@susa38)
In two hours my wp-options table is 20 mb bigger and all is with ngg-gallery items.
any other users with this problem?
Susa38 Make a backup of your database first, and then put this query in SQL
DELETE FROM wp_options WHERE option_name like '_transient_%' OR option_name like 'displayed_galleries%'
This will remove all transient
Thread Starter
Susa38
(@susa38)
Thanks for the help.
One question?
I suposse this is a solution to delete all the items in table wp-options that nextgen gallery have inserted and are not in use to make the gallerys visible for the web users but…
this solution will prevent that tomorrow i do not have to make the same?
Why nextgen gallery plugin make this?
@susa38 You are correct, this is a solution to delete all transients, it doesn’t ensure that those will be regularly flushed, and maybe you’ll have to query it again.
However, this issue was present months ago (some NextGEN versions ago) and I had it too, then it was resolved and the current NextGEN version should not cause this problem no more, because now transients are regularly flushed away.
I see that you have current version, so for the moment I suggest to clean up database with that query (it’s harmless but I recommend to backup your database before any operation) and in addition you could also clear image cache from Other Options > Miscellaneous, just to see if this total cleaning will have impact in the subsequent behavior.
Thread Starter
Susa38
(@susa38)
thanks a lot. I’ve made that query and 150 mb now are out.
the web is ok but in 5 minuts that table have 1 mb more.
Also I’ve clear image cache like you comment
I suposse i have to make the query every 12 hours until a new release of the pluggin.
one question more please…
If I delete the plugin and after I install the plugin with the new version can I get the solution?
But if I delete the plugin all my gallerys and albums created will be deleted?
@susa38 – The transients should be flushed, by default, every hour (roughly) as it is a WP CRON event (provided WP CRON is working correctly on your site).
This code is currently in the latest version of NextGEN Gallery so there is no reason to delete and re-install the plugin to get the code as long as you maintain the current version of NextGEN Gallery on your site.
Currently, deleting the plugin will not remove your galleries, albums, or images.
– Cais.
