Notifications
Clear all

Limited Support

Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed.
We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.

 

wpForo 1.x.x [Solved] MySQL queries killing the server

10 Posts
3 Users
0 Reactions
1,703 Views
Posts: 5
 Zimi
Topic starter
(@zimi)
Active Member
Joined: 4 years ago

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`
               FROM `wp_wpforo_forums`
               WHERE `forumid` = 3
               UNION
               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 |

9 Replies
dimalifragis
Posts: 2601
(@dimalifragis)
Famed Member
Joined: 5 years ago

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?

1 Reply
 Zimi
(@zimi)
Joined: 4 years ago

Active Member
Posts: 5

@dimalifragis 

I haven't got a debug log set up. The hosting is a normal business hosting where up 10 a 100 Domains, 100 Databases and 500 GB of storage can be hosted. I can install adebug log and activate WP Foro again. But it is definitely WP Foro causing the issue because since I deactivated it, the problem stopped.

dimalifragis
Posts: 2601
(@dimalifragis)
Famed Member
Joined: 5 years ago

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.

 

Robert
Posts: 10616
Admin
(@robert)
Support Team
Joined: 9 years ago

@zimi,

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.

5 Replies
 Zimi
(@zimi)
Joined: 4 years ago

Active Member
Posts: 5

@robert yep, done, you should have it.

Robert
Admin
(@robert)
Joined: 9 years ago

Support Team
Posts: 10616

@zimi,

We've not received any email from you. Please check the email again. Make sure you've sent the details to support[at]gvectors.com email address.

 Zimi
(@zimi)
Joined: 4 years ago

Active Member
Posts: 5

@robert yes sure, let me have a look again.

Robert
Admin
(@robert)
Joined: 9 years ago

Support Team
Posts: 10616

@zimi ,

We found and fixed the issue. Somehow, one of your forum parent ID was set its own ID, so it was stacked in a loop. I think this was a result of some database manipulation by someone. wpForo could not set such parent ID in its own.

 Zimi
(@zimi)
Joined: 4 years ago

Active Member
Posts: 5

@robert many thanks for that. We will never know what caused it but I am glad it's solved.