[Solved] MySQL queries killing the server
I had to deactivate WP Foro temprorarily because my webhost critizised that the plugin makes SQL queries that make the the server crash eventually. It looks like a maintenance job the plugin is doing. See below. Anybody an Idea how to solve that issue?
| 243059 | akilifod_wp5 | p21.server.hostpoint.internal:53344 | akilifod_wp5 | Query | 3735 | Storing result in query cache | WITH RECURSIVE `forum_path` AS(
SELECT `forumid`, `parentid`, 0 AS `depth`
WHERE `forumid` = 3
SELECT f.`forumid`, f.`parentid`, `depth` + 1
FROM `wp_wpforo_forums` f
INNER JOIN `forum_path` fp ON fp.`parentid` = f.`forumid`
) SELECT `forumid` FROM `forum_path` ORDER BY `depth` DESC | 0.000 |
I doubt wpForo is killing any mysql server.
What kind of hosting plan is that? Can you give us some details?
Do you have Debug to a LOG enabled for Wordpress?
Are there any fatal or other errors in the debug.log?
Just enable debug to a log
Add these to your wp-config.php
define( 'WP_DEBUG', true ); define( 'WP_DEBUG_DISPLAY', false ); define( 'WP_DEBUG_LOG', true );
Also check forums/tools/debug and go through all the tabs to see any issues.
Could you please let us login and help to fix this issue?
Please send the admin login details to support[at]gvectors.com email address.