My host also said this:
WITH RECURSIVE `forum_path` AS(
SELECT `forumid`, `parentid`, 0 AS `depth`
FROM `wp_3cy42zznwz_wpforo_forums`
WHERE `forumid` = 116
UNION
SELECT f.`forumid`, f.`parentid`, `depth` + 1
FROM `wp_3cy42zznwz_wpforo_forums` f
INNER JOIN `forum_path` fp ON fp.`parentid` = f.`forumid`
) SELECT `forumid` FROM `forum_path` ORDER BY `depth` DESC
This peice of script seems to be the issue causing too many database commands
The hook code provided by @robert disables this SQL, as far as I know you've already tried it, and it didn't help. So we can ignore this SQL and try the wpForo downgrading option: https://wpforo.com/community/how-to-and-troubleshooting-2/forum-is-down-again/#post-56383
I had to update again as the private messages was broken with this version
Am I going to have to downgrade all of my add ons?
been working fine for near a whoole day the the site goes down with error estblishing database connection. It never ends.....
This is what the host said was wrong:
2021-08-10 16:58:48 0 [ERROR] InnoDB: (Duplicate key) writing word node to FTS auxiliary index table `percysgr_wp03409`.`wp_3cy42zznwz_wpforo_posts`
I am not able to get my site online until i know what to do here..... can anyone help?
So you're doing some changes on the database? Why the indexes are duplicated? What's going on with your hosting and database? Have you done any changes with the database?
Please contact us via support[at]gvectors.com and ask them to look deeper, they may ask you to access to the hosting managing panel (cPanel). This is the only place they can do a deep debugging and help you. Again, I don't like your hosting service...
Have you done any changes with the database?
I have changed nothing mate, only what you guys asked me to do last week, nothing recent.
I don't like your hosting service...
I am open to suggestions on who you would recommend for hosting ro what I should be looking for in a good hosting plan