DuncanClarke

Great work.

This is now working on my site with the new version installed. I have checked it on both PC (Chrome) and mobile and the format has been restored to how I set it up.

I’ve set you up an account on my WordPress site and sent you the details. If you need any more info please let me know.

I have applied version 1.8.96 and it has not changed the formatting issue as far as I can see.

https://urbanlines.net

I just noticed the exact same thing on my side – https://urbanlines.net.

I have tried changing the themes (strangely preview works but once applied it doesn’t). I have also tried deactivating every other plugin on the site but no change to the broken albums.

Thanks for that. I didn’t realise that anything else relied on it. Though my plugin is only for my own site I do want to keep it as portable as possible.

I’ll drop the search on post_name and instead do a slightly less conclusive search on post_title and tags_input. Every post made to the site is automatic so these should be identical each time. Just not quite the guarantee of uniqueness but enough to mitigate the risk.

Your help has been much appreciated and saved me a lot of time chasing my tail.

Ever since 2.x was released this has been a MAJOR issue. It kills my site. Literally kills it so pages time out and you can’t access it to the point where you can’t even reach the WP admin. The problem is simple – the plugin dumps thousands of trash entries into the wp_options table in your MySQL database slowing it to a crawl or killing it completely.

My fix for this is to strip these out manually, but it’s at the stage where I have to do this every day just to keep the site running. For those who want to try this, run this SQL query against your database:

DELETE FROM wp_options WHERE option_name LIKE '_transient_%' OR option_name LIKE 'displayed_gallery_%' OR option_name LIKE 'displayed_galleries_%'OR option_name LIKE '_site_transient_%'

@piszmaile

If this has broken your site, try checking the size of your work_options table in your database. If it is over a couple of hundred records then you may have the same issue I did. Mine was up to 120mb in size. I now run the SQL above a few times a day to clear down the junk that ngg is dumping in there before it takes the site down.

DELETE FROM wp_options WHERE option_name LIKE '_transient_%' OR option_name LIKE 'displayed_galleries_%'

Just in case someone needs to clean up their database before it corrupts it completely taking down the whole site in the process…

I’m having 2 faults – one minor and one MAJOR
1) Minor – when viewing an album with other albums embedded (https://urbanlines.net/gallery/) I get the standard message “no images were found” when trying to view the galleries.

2) MAJOR – I just had to completely reinstall my whole site (including wiping the WHOLE database and starting clean) because the plugin is filling the options table with the following, thousands and thousands of times. Please advise how I stop this before it fills my database again or I need to write custom SQL scripts to clear it out manually:

Full Texts 	option_id 	option_name 	option_value 	autoload
Edit 	Delete 	378 	_transient_83cca243488109bf3e6af441c861fcfa 	O:8:"stdClass":19:{s:2:"id";N;s:6:"source";s:9:"ga... 	no
Edit 	Delete 	379 	displayed_galleries_83cca243488109bf3e6af441c861fc... 	1 	yes
Edit 	Delete 	380 	_transient_timeout_0e0e5cd1948d7d9a71a0ef80f407dda... 	1378772508 	no
Edit 	Delete 	381 	_transient_0e0e5cd1948d7d9a71a0ef80f407ddab 	O:8:"stdClass":20:{s:2:"id";N;s:6:"source";s:9:"ga... 	no
Edit 	Delete 	382 	displayed_galleries_0e0e5cd1948d7d9a71a0ef80f407dd... 	1 	yes