Notifications

Clear all

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

How-to and Troubleshooting

Last Post by Jono3 4 years ago

5 Posts

3 Users

0 Reactions

1,259 Views

RSS

Posts: 5

Jono3

Topic starter

Jul 18, 2020 11:18 pm

(@jono3)

Active Member

Joined: 4 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

Recheck DB

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

Posts: 992

Martin

Moderator

Jul 19, 2020 7:12 am

(@martin)

Support Team

Joined: 8 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.

Posts: 5

Jono3

Topic starter

Jul 19, 2020 6:13 pm

(@jono3)

Active Member

Joined: 4 years ago

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

Client version

mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $

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

1 Reply

Robert

Admin

(@robert)

Joined: 9 years ago

Support Team

Posts: 10591

Jul 20, 2020 12:23 pm

Reply to

Jono3

@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.

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

Posts: 5

Jono3

Topic starter

Jul 20, 2020 8:23 pm

(@jono3)

Active Member

Joined: 4 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?