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.
You ogtta stopleaving me to figure this s**t out on my own!! It is terrifying lol 😉
I found it and truncated the whole table.
All of my table are on InnoDB except for Likes and visits, they are on My sam.
Should i truncate the Likes table too?
This didnt work though, still getting slow load times
Ive done all of this guys, but my site is still getting slow page load times due to slow queries......
- ) SELECT `forumid` FROM `forum_path` ORDER BY `depth` DESC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/generatepress/page.php'), generate_do_template_part, get_template_part, locate_template, load_template, require('/themes/generatepress/content-page.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, wpforo_load, wpforo_init_template, include('/plugins/wpforo/wpf-themes/classic/index.php'), include('/plugins/wpforo/wpf-themes/classic/header.php'), wpForoTemplate->breadcrumb, wpForoForum->get_parents, wpForoForum->__get_parents_mysql8, QM_DB->query
Im getting this in my error log in the forum debug, any suggestions?
- [21-Jul-2021 04:46:54 UTC] WordPress database error MySQL server has gone away for query INSERT INTO `wp_3cy42zznwz_wpforo_posts` (`forumid`, `topicid`, `parentid`, `userid`, `title`, `body`, `created`, `modified`, `status`, `private`, `name`, `email`, `root`) VALUES (84, 3364, 64017, 6726, 'RE: My first grow', '@monkeydo thanks mate I appreciate that learning from the best
', '2021-07-21 04:46:54', '2021-07-21 04:46:54', 0, 0, '', '', 64017) made by require('wp-blog-header.php'), wp, WP->main, do_action_ref_array('wp'), WP_Hook->do_action, WP_Hook->apply_filters, wpForo->init, do_action('wpforo_after_init'), WP_Hook->do_action, WP_Hook->apply_filters, wpForoAction->do_actions, do_action('wpforo_action_wpforo_post_add'), WP_Hook->do_action, WP_Hook->apply_filters, wpForoAction->post_add, wpForoPost->add, QM_DB->query
- [21-Jul-2021 04:46:53 UTC] PHP Warning: mysqli_query(): (HY000/2006): MySQL server has gone away in /home/percysgr/public_html/wp-includes/wp-db.php on line 2056
- [20-Jul-2021 23:36:30 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_3cy42zznwz_options WHERE option_name = 'cli_script_blocker_status' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Cookie_Law_Info_Script_Blocker->end_buffer, Cookie_Law_Info_Script_Blocker->get_blocking_status, Cookie_Law_Info_Script_Blocker->get_script_blocker_status, get_option, QM_DB->query
- [20-Jul-2021 23:02:54 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_3cy42zznwz_options WHERE option_name = 'cli_script_blocker_status' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Cookie_Law_Info_Script_Blocker->end_buffer, Cookie_Law_Info_Script_Blocker->get_blocking_status, Cookie_Law_Info_Script_Blocker->get_script_blocker_status, get_option, QM_DB->query
- [20-Jul-2021 20:19:12 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_3cy42zznwz_options WHERE option_name = 'cli_script_blocker_status' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Cookie_Law_Info_Script_Blocker->end_buffer, Cookie_Law_Info_Script_Blocker->get_blocking_status, Cookie_Law_Info_Script_Blocker->get_script_blocker_status, get_option, QM_DB->query
- [20-Jul-2021 20:13:51 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_3cy42zznwz_options WHERE option_name = 'cli_script_blocker_status' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Cookie_Law_Info_Script_Blocker->end_buffer, Cookie_Law_Info_Script_Blocker->get_blocking_status, Cookie_Law_Info_Script_Blocker->get_script_blocker_status, get_option, QM_DB->query
- [20-Jul-2021 20:11:16 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_3cy42zznwz_options WHERE option_name = 'cli_script_blocker_status' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Cookie_Law_Info_Script_Blocker->end_buffer, Cookie_Law_Info_Script_Blocker->get_blocking_status, Cookie_Law_Info_Script_Blocker->get_script_blocker_status, get_option, QM_DB->query
- ) SELECT `forumid` FROM `forum_path` ORDER BY `depth` DESC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/generatepress/page.php'), generate_do_template_part, get_template_part, locate_template, load_template, require('/themes/generatepress/content-page.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, wpforo_load, wpforo_init_template, include('/plugins/wpforo/wpf-themes/classic/index.php'), include('/plugins/wpforo/wpf-themes/classic/header.php'), wpForoTemplate->breadcrumb, wpForoForum->get_parents, wpForoForum->__get_parents_mysql8, QM_DB->query
- INNER JOIN `forum_path` fp ON fp.`parentid` = f.`forumid`
- FROM `wp_3cy42zznwz_wpforo_forums` f
- SELECT f.`forumid`, f.`parentid`, `depth` + 1
- UNION
- WHERE `forumid` = 106
- FROM `wp_3cy42zznwz_wpforo_forums`
- SELECT `forumid`, `parentid`, 0 AS `depth`
How is this?
for question 2:
USER AGENT | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.164 Safari/537.36 |
Web Server | LiteSpeed |
PHP Version | 7.4.21 |
MySQL Version | 10.3.30-MariaDB |
PHP Max Post Size | 2000M |
PHP Max Upload Size | 4000M |
PHP Memory Limit | 4000M |
for question 3
I have most addons for wpforo, all of them are fully up to date except for the emojis, that's deactivated as i need to renew it.
I dont think i have added any custom code to the function file either.
I hope this helps 🙂