Jul 19, 2021 7:49 pm
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?
Jul 19, 2021 8:06 pm
This didnt work though, still getting slow load times
Jul 20, 2021 9:39 am
Ive done all of this guys, but my site is still getting slow page load times due to slow queries......
Jul 20, 2021 11:35 pm
- ) 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?
Jul 21, 2021 1:23 pm
- [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 🙂