This was really burning me out, so I took some time off and ignored it for a few days.
I have put the wp debug in my config now, and will wait 24 hours to let it do its thing, ill report back tomorrow 🙂
@percysgrowroom There are already several issues logged, not sure how serious or not they are.
I would suggest to email the log to gvectors support for them to check.
Especially these are database issues. Why the server is shutting down? Reboot? Why?
Smell like Hosting Issues.
[05-Aug-2021 10:55:58 UTC] PHP Warning: mysqli_query(): (08S01/1053): Server shutdown in progress in /home/xxxxx/public_html/wp-includes/wp-db.php on line 2056
[05-Aug-2021 10:55:58 UTC] WordPress database error Server shutdown in progress for query SELECT COUNT(`likeid`) FROM `wp_3cy42zznwz_wpforo_likes` WHERE `postid` = 41016 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'), wpforo_template, include('/plugins/wpforo/wpf-themes/classic/post.php'), include('/plugins/wpforo/wpf-themes/classic/layouts/4/post.php'), wpForoPost->replies, wpforo_thread_reply, wpforo_post, wpForoPost->get_post_likes_count, QM_DB->query
[05-Aug-2021 10:55:58 UTC] WordPress database error Connection was killed for query SELECT option_value FROM wp_3cy42zznwz_options WHERE option_name = 'can_compress_scripts' LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, wp_widgets_init, do_action('widgets_init'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Widget_Factory->_register_widgets, WP_Widget->_register, WP_Widget_Text->_register_one, wp_add_inline_script, wp_scripts, WP_Scripts->__construct, WP_Scripts->init, do_action_ref_array('wp_default_scripts'), WP_Hook->do_action, WP_Hook->apply_filters, wp_default_packages, wp_register_tinymce_scripts, script_concat_settings, get_site_option, get_network_option, get_option, QM_DB->query
[05-Aug-2021 10:56:01 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/xxxxxx/public_html/wp-includes/wp-db.php on line 1653
Also if you have a backup of your site in your local drive (pc), unzip it if it is zipped and search within all files (php files) for
ob_end_flush()
and see what plugin (or theme) use it. It seems to create an issue.
There are several search programs with massive folder search capabilities.
Especially these are database issues. Why the server is shutting down? Reboot? Why?
This could be DDoS attack as well. This kind of attacks overload server and database with multiple calls and the database goes down. Make sure your hosting has some protection against DDoS. Also, try to find the logs related to the "too many request to the server" issue. Your hosting support was talking about this issue, they should provide a list of pages and files that was under multiple requests.
BTW, have you tries to downgrade the forum?
@robert See those also:
[05-Aug-2021 10:23:35 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT *, CASE
WHEN `type` = 3 THEN 0
WHEN `type` = 4 THEN 1
WHEN `type` = 7 THEN 2
WHEN `type` = 6 THEN 3
WHEN `type` = 5 THEN 4
WHEN `type` = 9 THEN 5
WHEN `type` = 8 THEN 6
WHEN `type` = 2 THEN 7
WHEN `type` = 1 THEN 8
ELSE 9999
END AS `typeSort`, CASE
WHEN `type` = 3 THEN `parameters`
WHEN `type` = 4 THEN `parameters`
WHEN `type` = 1 THEN `IP`
WHEN `type` = 9 THEN `IP`
WHEN `type` = 5 THEN `IP`
WHEN `type` = 6 THEN `IP`
WHEN `type` = 7 THEN `IP`
WHEN `type` = 2 THEN `IP`
WHEN `type` = 8 THEN `IP`
ELSE 9999
END AS `detailSort`
FROM `wp_3cy42zznwz_wfblocks7` WHERE `type` IN (4) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `typeSort` ASC, `id` DESC made by wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::patternBlocks, wfBlock::allBlocks, QM_DB->query
[05-Aug-2021 10:23:35 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT *, CASE
WHEN `type` = 3 THEN 0
WHEN `type` = 4 THEN 1
WHEN `type` = 7 THEN 2
WHEN `type` = 6 THEN 3
WHEN `type` = 5 THEN 4
WHEN `type` = 9 THEN 5
WHEN `type` = 8 THEN 6
WHEN `type` = 2 THEN 7
WHEN `type` = 1 THEN 8
ELSE 9999
END AS `typeSort`, CASE
WHEN `type` = 3 THEN `parameters`
WHEN `type` = 4 THEN `parameters`
WHEN `type` = 1 THEN `IP`
WHEN `type` = 9 THEN `IP`
WHEN `type` = 5 THEN `IP`
WHEN `type` = 6 THEN `IP`
WHEN `type` = 7 THEN `IP`
WHEN `type` = 2 THEN `IP`
WHEN `type` = 8 THEN `IP`
ELSE 9999
END AS `detailSort`
FROM `wp_3cy42zznwz_wfblocks7` WHERE `type` IN (3) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `typeSort` ASC, `id` DESC made by wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::countryBlocks, wfBlock::allBlocks, QM_DB->query
[05-Aug-2021 10:23:35 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT *, CASE
WHEN `type` = 3 THEN 0
WHEN `type` = 4 THEN 1
WHEN `type` = 7 THEN 2
WHEN `type` = 6 THEN 3
WHEN `type` = 5 THEN 4
WHEN `type` = 9 THEN 5
WHEN `type` = 8 THEN 6
WHEN `type` = 2 THEN 7
WHEN `type` = 1 THEN 8
ELSE 9999
END AS `typeSort`, CASE
WHEN `type` = 3 THEN `parameters`
WHEN `type` = 4 THEN `parameters`
WHEN `type` = 1 THEN `IP`
WHEN `type` = 9 THEN `IP`
WHEN `type` = 5 THEN `IP`
WHEN `type` = 6 THEN `IP`
WHEN `type` = 7 THEN `IP`
WHEN `type` = 2 THEN `IP`
WHEN `type` = 8 THEN `IP`
ELSE 9999
END AS `detailSort`
FROM `wp_3cy42zznwz_wfblocks7` WHERE `type` IN (1, 8, 9, 2, 5, 6) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `typeSort` ASC, `id` DESC made by wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::ipBlocks, wfBlock::allBlocks, QM_DB->query
[05-Aug-2021 10:23:35 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT *, CASE
WHEN `type` = 3 THEN 0
WHEN `type` = 4 THEN 1
WHEN `type` = 7 THEN 2
WHEN `type` = 6 THEN 3
WHEN `type` = 5 THEN 4
WHEN `type` = 9 THEN 5
WHEN `type` = 8 THEN 6
WHEN `type` = 2 THEN 7
WHEN `type` = 1 THEN 8
ELSE 9999
END AS `typeSort`, CASE
WHEN `type` = 3 THEN `parameters`
WHEN `type` = 4 THEN `parameters`
WHEN `type` = 1 THEN `IP`
WHEN `type` = 9 THEN `IP`
WHEN `type` = 5 THEN `IP`
WHEN `type` = 6 THEN `IP`
WHEN `type` = 7 THEN `IP`
WHEN `type` = 2 THEN `IP`
WHEN `type` = 8 THEN `IP`
ELSE 9999
END AS `detailSort`
BTW, have you tries to downgrade the forum?
@robert all those issues do not point to wpForo. Does he need to downgrade?
Anything i can do here guys??? None of this makes much sense to me lol. I hope you guys can understand it more
Anything i can do here guys??? None of this makes much sense to me lol. I hope you guys can understand it more
Point this last page to your hosting support and ask WHY the server/db goes DOWN. A clear explanation.
Also pls do what i told you in
https://wpforo.com/community/how-to-and-troubleshooting-2/forum-is-down-again/paged/5/#post-56765
and find what plugin does this.
Also wait for @robert or @martin to reply also to give you some good advise, as usual.
