Notifications
Clear all

wpForo 1.x.x 'Can't add forum' error. Data bases missing.

5 Posts
3 Users
0 Likes
569 Views
Jono3
Posts: 5
Topic starter
(@jono3)
Active Member
Joined: 2 years ago

I am getting the can't add forum error and i'm showing multiple missing databases.  I tried uninstalling and reinstalling but get the same error.  Please see my debug table info belwo:

 Problems Found in Database

Table name
Problem description
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
Solve database problems

IMPORTANT!

If the [Solve database problems] button doesn't solve the issues. Please use the SQl commands below in your hosting service cPanel > phpMyAdmin Database Manager > WordPress Database > SQL Tab. In case you're not familiar with hosting service tools, please contact to your hosting service support team and forward them this message with the SQL command.

Problem fixer SQL commands:

SET AUTOCOMMIT = 0;
CREATE TABLE IF NOT EXISTS `wp_wpforo_forums`( `forumid` INT UNSIGNED NOT NULL AUTO_INCREMENT, `title` VARCHAR(255) NOT NULL, `slug` VARCHAR(255) NOT NULL, `description` LONGTEXT, `parentid` INT UNSIGNED NOT NULL DEFAULT 0, `icon` VARCHAR(255), `last_topicid` INT UNSIGNED NOT NULL DEFAULT 0, `last_postid` INT UNSIGNED NOT NULL DEFAULT 0, `last_userid` INT UNSIGNED NOT NULL DEFAULT 0, `last_post_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `topics` INT NOT NULL DEFAULT 0, `posts` INT NOT NULL DEFAULT 0, `permissions` TEXT, `meta_key` TEXT, `meta_desc` TEXT, `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0, `is_cat` tinyint(1) UNSIGNED NOT NULL DEFAULT 0, `cat_layout` tinyint(1) UNSIGNED NOT NULL DEFAULT 0, `order` INT UNSIGNED NOT NULL DEFAULT 0, `color` VARCHAR(7) NOT NULL DEFAULT '', PRIMARY KEY (`forumid`), UNIQUE KEY `UNIQUE SLUG` (`slug`(191)), KEY `order` (`order`), KEY `status` (`status`), KEY `parentid` (`parentid`), KEY `last_postid` (`last_postid`), KEY `is_cat` (`is_cat`) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `wp_wpforo_profiles` ( `userid` INT UNSIGNED NOT NULL, `title` VARCHAR(255) NOT NULL DEFAULT 'member', `username` VARCHAR(255) NOT NULL, `groupid` INT UNSIGNED NOT NULL, `posts` INT NOT NULL DEFAULT 0, `questions` INT NOT NULL DEFAULT 0, `answers` INT NOT NULL DEFAULT 0, `comments` INT NOT NULL DEFAULT 0, `site` VARCHAR(255), `icq` VARCHAR(50), `aim` VARCHAR(50), `yahoo` VARCHAR(50), `msn` VARCHAR(50), `facebook` VARCHAR(255), `twitter` VARCHAR(255), `gtalk` VARCHAR(50), `skype` VARCHAR(50), `avatar` VARCHAR(255), `signature` TEXT, `about` TEXT, `occupation` TEXT, `location` VARCHAR(255), `last_login` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `online_time` INT UNSIGNED, `rank` INT UNSIGNED NOT NULL DEFAULT 0, `like` INT UNSIGNED NOT NULL DEFAULT 0, `status` VARCHAR(8) DEFAULT 'active' COMMENT 'active, blocked, trashed, spamer', `timezone` VARCHAR(255), `is_email_confirmed` TINYINT(1) NOT NULL DEFAULT 0, `secondary_groups` VARCHAR(255), `fields` LONGTEXT, PRIMARY KEY (`userid`), KEY `groupid` (`groupid`), KEY `online_time` (`online_time`), KEY `posts` (`posts`), KEY `status` (`status`), KEY `is_email_confirmed` (`is_email_confirmed`) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `wp_wpforo_usergroups`( `groupid` INT UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `cans` LONGTEXT NOT NULL COMMENT 'board permissions', `description` TEXT, `utitle` VARCHAR(100) NOT NULL DEFAULT '', `role` VARCHAR(50) NOT NULL DEFAULT '', `access` VARCHAR(50) NOT NULL DEFAULT '', `color` varchar(7) NOT NULL DEFAULT '', `visible` tinyint(1) UNSIGNED NOT NULL DEFAULT 1, `secondary` tinyint(1) UNSIGNED NOT NULL DEFAULT 1, PRIMARY KEY (`groupid`), KEY `visible` (`visible`), KEY `secondary` (`secondary`), UNIQUE KEY `UNIQUE_GROUP_NAME` (`name`(191)) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `wp_wpforo_languages`( `langid` INT UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, PRIMARY KEY (`langid`), UNIQUE KEY `UNIQUE language name` (`name`(191)) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `wp_wpforo_likes`( `likeid` INT UNSIGNED NOT NULL AUTO_INCREMENT, `userid` INT UNSIGNED NOT NULL, `postid` INT UNSIGNED NOT NULL, `post_userid` INT UNSIGNED NOT NULL, PRIMARY KEY (`likeid`), UNIQUE KEY `userid` (`userid`,`postid`), KEY `post_userid` (`post_userid`) ) ENGINE=INNODB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `wp_wpforo_views`( `vid` INT UNSIGNED NOT NULL AUTO_INCREMENT, `userid` INT UNSIGNED NOT NULL, `topicid` INT UNSIGNED NOT NULL, `created` INT UNSIGNED NOT NULL, PRIMARY KEY (`vid`), KEY `userid` (`userid`), KEY `topicid` (`topicid`), UNIQUE KEY `user_topic` (`userid`,`topicid`) ) ENGINE=INNODB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `wp_wpforo_votes`( `voteid` INT UNSIGNED NOT NULL AUTO_INCREMENT, `userid` INT UNSIGNED NOT NULL, `postid` INT UNSIGNED NOT NULL, `reaction` TINYINT NOT NULL DEFAULT 1, `post_userid` INT UNSIGNED NOT NULL, PRIMARY KEY (`voteid`), UNIQUE KEY `userid` (`userid`,`postid`) ) ENGINE=INNODB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `wp_wpforo_accesses`( `accessid` INT UNSIGNED NOT NULL AUTO_INCREMENT, `access` VARCHAR(255) NOT NULL, `title` VARCHAR(255) NOT NULL, `cans` LONGTEXT NOT NULL COMMENT 'forum permissions', PRIMARY KEY (`accessid`), UNIQUE KEY ( `access`(191) ) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `wp_wpforo_subscribes` ( `subid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `itemid` BIGINT UNSIGNED NOT NULL, `type` VARCHAR(5) NOT NULL, `confirmkey` varchar(32) NOT NULL, `userid` BIGINT UNSIGNED NOT NULL, `active` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `user_name` VARCHAR(60) NOT NULL, `user_email` VARCHAR(60) NOT NULL, PRIMARY KEY (`subid`), UNIQUE KEY `fld_group_unq` (`itemid`,`type`,`userid`,`user_email`(60)), UNIQUE KEY `confirmkey` (`confirmkey`), KEY `itemid_2` (`itemid`), KEY `userid` (`userid`) ) ENGINE=INNODB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `wp_wpforo_visits` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `userid` BIGINT UNSIGNED NOT NULL, `name` VARCHAR(60) NOT NULL, `ip` VARCHAR(60) NOT NULL, `time` INT UNSIGNED NOT NULL, `forumid` INT UNSIGNED NOT NULL, `topicid` BIGINT UNSIGNED NOT NULL, PRIMARY KEY (`id`), KEY `userid` (`userid`), KEY `forumid` (`forumid`), KEY `topicid` (`topicid`), KEY `time` (`time`), KEY `ip` (`ip`), KEY `time_forumid` (`time`,`forumid`), KEY `time_topicid` (`time`,`topicid`), UNIQUE KEY `unique_tracking` (`userid`,`ip`,`forumid`,`topicid`) ) ENGINE=INNODB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `wp_wpforo_activity` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `type` VARCHAR(60) NOT NULL, `itemid` BIGINT UNSIGNED NOT NULL, `itemtype` VARCHAR(60) NOT NULL, `itemid_second` BIGINT UNSIGNED NOT NULL DEFAULT 0, `userid` BIGINT UNSIGNED NOT NULL DEFAULT 0, `name` VARCHAR(60) NOT NULL DEFAULT '', `email` VARCHAR(70) NOT NULL DEFAULT '', `date` INT UNSIGNED NOT NULL DEFAULT 0, `content` TEXT, `permalink` VARCHAR(1024) NOT NULL DEFAULT '', `new` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `type` (`type`), KEY `type_objid_objtype` (`type`,`itemid`,`itemtype`), KEY `type_objid_objtype_userid` (`type`,`itemid`,`itemtype`,`userid`), KEY `itemtype_userid_new` (`itemtype`,`userid`,`new`), KEY `date` (`date`) ) ENGINE=INNODB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `wp_wpforo_post_revisions` ( `revisionid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `userid` BIGINT UNSIGNED NOT NULL DEFAULT 0, `textareaid` VARCHAR(50) NOT NULL, `postid` BIGINT UNSIGNED NOT NULL DEFAULT 0, `body` LONGTEXT, `created` INT UNSIGNED NOT NULL DEFAULT 0, `version` SMALLINT NOT NULL DEFAULT 0, `email` VARCHAR(50) NOT NULL DEFAULT '', `url` TEXT, PRIMARY KEY (`revisionid`), KEY `userid_textareaid_postid_email` (`userid`, `textareaid`, `postid`, `email`, `url`(70)) ) ENGINE=INNODB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

CREATE TABLE IF NOT EXISTS `wp_wpforo_tags`( `tagid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `tag` VARCHAR(255) NOT NULL, `prefix` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `count` INT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`tagid`), UNIQUE KEY `tag` (`tag`(190)), KEY (`prefix`) ) ENGINE=INNODB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

SET AUTOCOMMIT = 1;

Database Tables

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

wp_wpforo_phrases  |  Rows: 0  |  Status: OK
phraseid int(10) unsigned   - PRI  
langid int(10) unsigned   - MUL  
phrase_key text utf8mb4_unicode_ci - MUL  
phrase_value text utf8mb4_unicode_ci -    
package varchar(255) utf8mb4_unicode_ci -   wpforo
Indexes
PRIMARY phraseid Un BTREE
lng_and_key_uniq langid, phrase_key Un BTREE
langid langid 0 BTREE
phrase_key phrase_key 0 BTREE
wp_wpforo_posts  |  Rows: 0  |  Status: OK
postid bigint(20) unsigned   - PRI  
parentid bigint(20) unsigned   - MUL 0
forumid int(10) unsigned   - MUL  
topicid bigint(20) unsigned   - MUL  
userid int(10) unsigned   - MUL  
title varchar(255) utf8mb4_unicode_ci NULL MUL  
body longtext utf8mb4_unicode_ci NULL MUL  
created datetime   - MUL 0000-00-00 00:00:00
modified datetime   -   0000-00-00 00:00:00
likes int(10) unsigned   -   0
votes int(11)   -   0
is_answer tinyint(1) unsigned   - MUL 0
is_first_post tinyint(1) unsigned   - MUL 0
status tinyint(1) unsigned   - MUL 0
name varchar(50) utf8mb4_unicode_ci -    
email varchar(50) utf8mb4_unicode_ci - MUL  
private tinyint(1) unsigned   - MUL 0
root bigint(20)   NULL MUL  
Indexes
PRIMARY postid Un BTREE
topicid topicid 0 BTREE
forumid forumid 0 BTREE
userid userid 0 BTREE
created created 0 BTREE
parentid parentid 0 BTREE
is_answer is_answer 0 BTREE
is_first_post is_first_post 0 BTREE
status status 0 BTREE
email email 0 BTREE
is_private private 0 BTREE
root root 0 BTREE
forumid_status forumid, status 0 BTREE
topicid_status topicid, status 0 BTREE
topicid_solved topicid, is_answer 0 BTREE
topicid_parentid topicid, parentid 0 BTREE
forumid_status_private forumid, status, private 0 BTREE
forumid_answer_first forumid, is_answer, is_first_post 0 BTREE
title title 0 FULLTEXT
body body 0 FULLTEXT
title_plus_body title, body 0 FULLTEXT

Table wp_wpforo_post_revisions doesn't exist

Table wp_wpforo_profiles doesn't exist

Table wp_wpforo_subscribes doesn't exist

wp_wpforo_topics  |  Rows: 0  |  Status: OK
topicid bigint(20) unsigned   - PRI  
forumid int(10) unsigned   - MUL  
first_postid bigint(20) unsigned   - MUL 0
userid int(10) unsigned   - MUL  
title varchar(255) utf8mb4_unicode_ci - MUL  
slug varchar(255) utf8mb4_unicode_ci - MUL  
created datetime   - MUL 0000-00-00 00:00:00
modified datetime   - MUL 0000-00-00 00:00:00
last_post bigint(20) unsigned   - MUL 0
posts int(11)   -   0
votes int(11)   -   0
answers int(11)   -   0
views int(10) unsigned   -   0
meta_key text utf8mb4_unicode_ci NULL    
meta_desc text utf8mb4_unicode_ci NULL    
type tinyint(4)   - MUL 0
solved tinyint(1)   - MUL 0
closed tinyint(1) unsigned   -   0
has_attach tinyint(1) unsigned   -   0
private tinyint(1) unsigned   - MUL 0
status tinyint(1) unsigned   - MUL 0
name varchar(50) utf8mb4_unicode_ci -    
email varchar(50) utf8mb4_unicode_ci - MUL  
prefix varchar(100) utf8mb4_unicode_ci - MUL  
tags text utf8mb4_unicode_ci NULL    
Indexes
PRIMARY topicid Un BTREE
slug slug 0 BTREE
forumid forumid 0 BTREE
first_postid first_postid 0 BTREE
created created 0 BTREE
modified modified 0 BTREE
last_post last_post 0 BTREE
type type 0 BTREE
status status 0 BTREE
email email 0 BTREE
solved solved 0 BTREE
is_private private 0 BTREE
own_private userid, private 0 BTREE
forumid_status forumid, status 0 BTREE
forumid_status_private forumid, status, private 0 BTREE
prefix prefix 0 BTREE
title title 0 FULLTEXT

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

4 Replies
Martin
Posts: 868
Moderator
(@martin)
Support Team
Joined: 6 years ago

Hi @jono3,

Please make sure your hosting server MySQL is not outdated. It should be 5.6 and higher.

It seems the database doesn't support utf8mb4_unicode_ci collation.

Reply
Jono3
Posts: 5
Topic starter
(@jono3)
Active Member
Joined: 2 years ago

So I'm not 100% sure how to check that but under Tools>Site Hleath>Info>Database I found

Does that mean I can't use this plugin?  Can I update this somehow or do I have to move my site?

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

Support Team
Posts: 9912

@jono3,

You can see the MySQL version in Dashboard > Forums > Dashboard admin page.

And I think I was correct, your server MySQL database is outdated. You should contact to your hosting service and ask them update it to 5.6 or better 5.7.

Reply
Jono3
Posts: 5
Topic starter
(@jono3)
Active Member
Joined: 2 years ago

I contacted my host and they were able to execute something with my SQL to get the full database installed without any errors. However, it still shows v5.5.5.  I am now having a different problem with the forums being created but not showing up on the forum page.  Would this still be related to the SQL, or is this a different problem entirely?

Reply