my site is frozen sporadically due to the problems with this plugin locking up the database. my server admin identified the issue and sent me this:
The query that caused problems was this one:
SELECT pid , wp_options.option_value AS ‘custom_post_id’, GROUP_CONCAT(CONCAT_WS(‘@@’, meta_key, meta_value)) AS ‘extras’ FROM wp_ngg_pictures LEFT OUTER JOIN wp_options ON wp_options.option_name = CONCAT(‘wp_ngg_pictures_’, wp_ngg_pictures.pid) LEFT OUTER JOIN wp_postmeta ON wp_postmeta.post_id = wp_options.option_value WHERE (exclude = 0) GROUP BY wp_ngg_pictures.pid ORDER BY rand()
i have paying members and this plugin will make me lose them at this rate 🙁 (posted this in ‘reviews’, should’ve been posted here)
- The topic ‘Database Locking Issues’ is closed to new replies.