Problems Found in Database - Bug Reports - wpForo 2.0

RE: Problems Found in Database

Jason Wan — Mon, 11 May 2020 12:19:27 +0000

Update of my story.

I had received some info, that my hostings MySQL is

And I should try to look around in wpforo files if there is something like:
ENGINE=InnoDB and try to exchange it into ENGINE=MyISAM

Now I do not know mych about this stuff, and I will not waste my time doing some crazy experiments to see if it will work or not.

Any ideas how to fix it?

... or just simply start to look for a new hosting?

RE: Problems Found in Database

Jason Wan — Mon, 11 May 2020 08:42:57 +0000

@Sofy

Yes, I already did Step1, and Step2 but no luck, no good results.

This is why I decided to write a topic, and contact someone who can give me more clues.

RE: Problems Found in Database

Sofy — Mon, 11 May 2020 08:34:22 +0000

@jason-wan,

Please don't forget to do the following steps before checking:

1. Deactivate wpForo and activate it back.

2. Then navigate to Dashboard > Forums > Tools > Debugs > Tables sub-tab and check the errors if you still see those, please click on the button.

RE: Problems Found in Database

Jason Wan — Mon, 11 May 2020 08:31:58 +0000

@Sofy

Oh is that so? I believed I saw version 5.0 or greater.

But still planning to ask the hosting support for better version.

I will update here if I will know anything more about it.

RE: Problems Found in Database

Sofy — Mon, 11 May 2020 08:28:30 +0000

@jason-wan,

The MySQL version should be 5.6 or greater, as mentioned here: https://wpforo.com/docs/root/wpforo-installation/server-requirements/

Please contact your hosting support and ask them to increase the MySQL Version.

RE: Problems Found in Database

Jason Wan — Mon, 11 May 2020 08:07:07 +0000

I believe I have the same problem.

Clean wordpress install, then WPForo plugin and got many errors.

Like:

Table: wp_wpforo_forums

Doesn't exists

Button also didn't help at all.

That said, there was some magical script, that I needed to log in into phpMyAdmin, in section SQL paste and execute it;

Also did not help out, since the script has some issue

#1064 - Something is wrong in your syntax obok 'CREATE TABLE IF NOT EXISTS `wp_wpforo_profiles` (
`userid` INT UNSIGNED NOT ' w linii 31

List of errors:

Table: wp_wpforo_forums

Doesn't exists

Table: wp_wpforo_profiles

Doesn't exists

Table: wp_wpforo_usergroups

Doesn't exists

Table: wp_wpforo_languages

Doesn't exists

Table: wp_wpforo_likes

Doesn't exists

Table: wp_wpforo_views

Doesn't exists

Table: wp_wpforo_votes

Doesn't exists

Table: wp_wpforo_accesses

Doesn't exists

Table: wp_wpforo_subscribes

Doesn't exists

Table: wp_wpforo_visits

Doesn't exists

Table: wp_wpforo_activity

Doesn't exists

Table: wp_wpforo_post_revisions

Doesn't exists

Table: wp_wpforo_tags

Doesn't exists

Table wp_wpforo_accesses doesn't exist
Table wp_wpforo_activity doesn't exist
Table wp_wpforo_forums doesn't exist
Table wp_wpforo_languages doesn't exist
Table wp_wpforo_likes doesn't exist

Table wp_wpforo_post_revisions doesn't exist
Table wp_wpforo_profiles doesn't exist
Table wp_wpforo_subscribes doesn't exist

Table wp_wpforo_tags doesn't exist
Table wp_wpforo_usergroups doesn't exist
Table wp_wpforo_views doesn't exist
Table wp_wpforo_visits doesn't exist
Table wp_wpforo_votes doesn't exist

PHP Version	7.4.5
MySQL Version	5.5.5

So, any ideas how to solve it?

RE: Problems Found in Database

Robert — Tue, 04 Feb 2020 17:00:27 +0000

@tanne

Please scroll down and click the button in the Dashboard > Forums > Tools > Debug > Tables sub-tab.

RE: Problems Found in Database

tanne — Tue, 04 Feb 2020 16:22:25 +0000

Good day ,
the deactivation has unfortunately brought nothing.
Here the required information.

Clipboard-2.jpg

Clipboard-1.jpg

RE: Problems Found in Database

Robert — Tue, 04 Feb 2020 12:17:11 +0000

Hi @tanne,

Please deactivate wpForo and activate it back. Then navigate to Dashboard > Forums > Tools > Debugs > Tables sub-tab and check the errors. if you still see those, please click on the button.

BTW, what is your hosting MySQL version?

Problems Found in Database

tanne — Tue, 04 Feb 2020 12:14:28 +0000

Good day ,
I installed wpforo completely fresh and I get the following error message.

Table: wp_wpforo_forums

Doesn't exists

Table: wp_wpforo_topics

Doesn't exists

Table: wp_wpforo_posts

Doesn't exists

Table: wp_wpforo_profiles

Doesn't exists

Table: wp_wpforo_usergroups

Doesn't exists

Table: wp_wpforo_languages

Doesn't exists

Table: wp_wpforo_phrases

Doesn't exists

Table: wp_wpforo_likes

Doesn't exists

Table: wp_wpforo_views

Doesn't exists

Table: wp_wpforo_votes

Doesn't exists

Table: wp_wpforo_accesses

Doesn't exists

Table: wp_wpforo_subscribes

Doesn't exists

Table: wp_wpforo_visits

Doesn't exists

Table: wp_wpforo_activity

Doesn't exists

Table: wp_wpforo_post_revisions

Doesn't exists

Table: wp_wpforo_tags

Doesn't exists

How can I stop this ?

Thank you for your help.

Error-Report.txt