My site seems to be...
 
Notifications
Clear all

wpForo 1.x.x [Closed] My site seems to be loading slower since the recent update.

95 Posts
5 Users
27 Reactions
7,898 Views
Posts: 1212
Topic starter
(@percysgrowroom)
Noble Member
Joined: 6 years ago

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?

1 Reply
Robert
Admin
(@robert)
Joined: 9 years ago

Support Team
Posts: 10591

@percysgrowroom,

No, the like table should not be truncated.

Posts: 1212
Topic starter
(@percysgrowroom)
Noble Member
Joined: 6 years ago

This didnt work though, still getting slow load times 

Posts: 1212
Topic starter
(@percysgrowroom)
Noble Member
Joined: 6 years ago

Ive done all of this guys, but my site is still getting slow page load times due to slow queries......

2 Replies
dimalifragis
(@dimalifragis)
Joined: 5 years ago

Famed Member
Posts: 2611
Posted by: @percysgrowroom

Ive done all of this guys, but my site is still getting slow page load times due to slow queries......

I do not think that MyIsam or InnoDB is your problem. Personally i wouldn't switch anything to MyISAM anymore for many many reasons, the information is all over the Internet so i will not expand here.

Your issues should be examined and solved by some experienced Wordpress guy. There are no mysteries here, it is either some problem with your site or some hosting issue.

 

 

(@percysgrowroom)
Joined: 6 years ago

Noble Member
Posts: 1212

@dimalifragis This all started after the recent wpforo updates mate, everything was working sweet up until then, so i am pretty confident that anything here has been caused by that. 

There was definitely a change in databases during the update, another member has also said it happened to them. 

Could this simply be a cache issue?

I have debug on my site and can see the issues being caused, if some one from the admin team can log into my site as admin they would see the issues 

 

Posts: 1212
Topic starter
(@percysgrowroom)
Noble Member
Joined: 6 years ago
  • ) 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?

1 Reply
Robert
Admin
(@robert)
Joined: 9 years ago

Support Team
Posts: 10591

@percysgrowroom,

Three things

1. The error message was copied incompletely. Please provide the list items above this message too.

2. I don't remember if I have asked you about the version of PHP and MySQL/MariaDB, so please let me know what are the versions.

3. Also, please let me know if you have any outdated wpForo addons or custom code in the functions.php of the WordPress theme.

 

Posts: 1212
Topic starter
(@percysgrowroom)
Noble Member
Joined: 6 years ago
  • [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 🙂 

Page 3 / 8