[Solved] Forum is down again!
My host also said this:
WITH RECURSIVE `forum_path` AS(
SELECT `forumid`, `parentid`, 0 AS `depth`
WHERE `forumid` = 116
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
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?
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