[Sticky] Topic Add Error  

There are a very few hosting services with MySQL server configuration which doesn't allow wpForo to complete all tables installation on activation process. This is the main reason why you get "Topic Add Error" when you try to create a new topic:

If this is not a new installation and you got this problem after wpForo update please execute this SQL in Hosting Service cPanel > phpMyAdmin database manager, navigate to SQL Tab. If your WordPress table prefix is not wp_   replace all wp_ prefixes in this code to your database table prefixes, if they are wp_ just use it as is:

ALTER TABLE `wp_wpforo_posts` ADD `private` TINYINT(1) NOT NULL DEFAULT '0' AFTER `email`, ADD INDEX `is_private` (`private`);

If you just installed wpForo and got this error please follow to this instruction:

You should open hosting service > cPanel > phpMyAdmin database manager, navigate to SQL Tab:

https://wpforo.com/wp-content/uploads/2017/02/wpForo-Topic-Add-Error-execute-SQL.png

Then insert the SQL mentioned below to the SQL query textarea. If your WordPress table prefix is not wp_   replace all wp_ prefixes in this code to your database table prefixes, if they are wp_ just use it as is:

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE IF NOT EXISTS `wp_wpforo_likes` (
  `likeid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `userid` int(10) UNSIGNED NOT NULL,
  `postid` int(10) UNSIGNED NOT NULL,
  `post_userid` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`likeid`),
  UNIQUE KEY `userid` (`userid`,`postid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `wp_wpforo_posts` (
  `postid` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parentid` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `forumid` int(10) UNSIGNED NOT NULL,
  `topicid` bigint(20) UNSIGNED NOT NULL,
  `userid` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `body` longtext,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `likes` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `votes` int(11) NOT NULL DEFAULT '0',
  `is_answer` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `is_first_post` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `private` tinyint(1) NOT NULL DEFAULT '0',
   PRIMARY KEY (`postid`),
   KEY `topicid` (`topicid`),
   KEY `forumid` (`forumid`),
   KEY `userid` (`userid`),
   KEY `parentid` (`parentid`),
   KEY `is_answer` (`is_answer`),
   KEY `is_first_post` (`is_first_post`),
   KEY `status` (`status`),
   KEY `email` (`email`),
   KEY `is_private` (`private`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `wp_wpforo_subscribes` (
  `subid` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `itemid` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(5) NOT NULL,
  `confirmkey` varchar(32) NOT NULL,
  `userid` bigint(20) UNSIGNED NOT NULL,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`subid`),
  UNIQUE KEY `itemid_type_userid` (`itemid`,`type`,`userid`),
  UNIQUE KEY `confirmkey` (`confirmkey`),
  KEY `itemid` (`itemid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `wp_wpforo_topics` (
  `topicid` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `forumid` int(10) UNSIGNED NOT NULL,
  `first_postid` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `userid` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_post` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `posts` int(11) NOT NULL DEFAULT '0',
  `votes` int(11) NOT NULL DEFAULT '0',
  `answers` int(11) NOT NULL DEFAULT '0',
  `views` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `meta_key` text,
  `meta_desc` text,
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `closed` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `has_attach` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `private` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
   PRIMARY KEY (`topicid`),
   UNIQUE KEY `UNIQUE SLUG` (`slug`(191)),
   KEY `forumid` (`forumid`),
   KEY `first_postid` (`first_postid`), 
   KEY `created` (`created`),
   KEY `modified` (`modified`),
   KEY `type` (`type`),
   KEY `status` (`status`),
   KEY `email` (`email`),
   KEY `is_private` (`private`),
   KEY `own_private` (`userid`,`private`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `wp_wpforo_views` (
  `vid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `userid` int(10) UNSIGNED NOT NULL,
  `topicid` int(10) UNSIGNED NOT NULL,
  `created` int(11) NOT NULL,
  PRIMARY KEY (`vid`),
  UNIQUE KEY `userid_topicid` (`userid`,`topicid`),
  KEY `user_topic` (`userid`,`topicid`),
  KEY `userid` (`userid`),
  KEY `topicid` (`topicid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `wp_wpforo_visits` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `userid` int(10) UNSIGNED NOT NULL,
  `name` varchar(50) NOT NULL,
  `ip` varchar(60) NOT NULL,
  `time` int(10) UNSIGNED NOT NULL,
  `forumid` int(10) UNSIGNED NOT NULL,
  `topicid` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`),
  KEY `forumid` (`forumid`),
  KEY `topicid` (`topicid`),
  KEY `time` (`time`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `wp_wpforo_votes` (
  `voteid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `userid` int(10) UNSIGNED NOT NULL,
  `postid` int(10) UNSIGNED NOT NULL,
  `reaction` tinyint(4) NOT NULL DEFAULT '1',
  `post_userid` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`voteid`),
  UNIQUE KEY `userid` (`userid`,`postid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `wp_wpforo_posts` ADD FULLTEXT KEY `title` (`title`);
ALTER TABLE `wp_wpforo_posts` ADD FULLTEXT KEY `body` (`body`);
ALTER TABLE `wp_wpforo_posts` ADD FULLTEXT KEY `title_plus_body` (`title`,`body`);
ALTER TABLE `wp_wpforo_topics` ADD FULLTEXT KEY `title` (`title`);

After executing this SQL you'll get message "MySQL returned an empty result set...", this mean all is correct and already created:

This SQL query creates missing tables:

That's it, this is a one time manipulation, there will not be other issues in future.

Hello, I have inserted your code, except I replaced "wp_" to "_wp" ...new tables were created, but the error is still present, do you have any other solution? Thank you.

Martin.

Posted by: Jahnuv

Hello, I have inserted your code, except I replaced "wp_" to "_wp" ...new tables were created, but the error is still present, do you have any other solution?

You've created tables with incorrect table prefix. Wy you've changed "wp_" to "_wp"? I don't think your table prefix is "_wp". Could you please leave some screenshot of your WP tables?

Robert!

I executed the sentence at my db but the issue persists. Heres my db structure 

Posted by: dalejandrom

Robert!

I executed the sentence at my db but the issue persists. Heres my db structure 

wptable.JPG

Hi dalejandrom,

Please Uninstall wpForo (not deactivate), it'll remove all tables and data. Then Install it again. Then use the SQL above, I just updated and adapted for current wpForo versions. That was a little out of date. Now it should work fine.

Thanks you

Really appreciated, Robert.

Why I have error ?

Because you've translated the SQL code too. The code is changed. For example:

CREATE TABLE IF NOT EXISTS

is changed to:

CREATE TABLE SI NO EXISTE

Please don't translate code, use it as is.