Notifications
Clear all

wpForo 1.x.x [Closed] Add Topic Error

6 Posts
2 Users
0 Likes
1,475 Views
Posts: 4
Topic starter
(@dipass)
Active Member
Joined: 5 years ago

Hi guys!

 

I have an error when add a new post... I tried to follow the debug instructions both the automatic and the manual procedure, but the error persists (tables like topics, post, likes ecc don't exist.) . Do you know how to solve? I use Wordpress last version and last sql version...

 

Thank you for reply.

5 Replies
Posts: 4
Topic starter
(@dipass)
Active Member
Joined: 5 years ago

Any solution? @anonymous20 @Sofy

Posts: 1602
(@anonymous20)
Noble Member
Joined: 8 years ago

I would be glad to help but i don't really understand what the problem is. What myphpadmin has to do with it ?

Was wpForo installed and worked right ? And suddlenly stoped ? What is the error when adding a post ?

What DEBUG.LOG shows ?

We can't guess all that and a url (if possible) would help.

 

Posts: 4
Topic starter
(@dipass)
Active Member
Joined: 5 years ago
The debug error is in the following attachment and if I use the automatic resolution problems (blue button) it does not work. If I then go to act manually through the sql it shows the error of the first attachment posted. Maybe there are error in the code?

Spoiler
Problem fixer SQL commands:
SET AUTOCOMMIT = 0;
CREATE TABLE IF NOT EXISTS `avwp_wpforo_topics`( `topicid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `forumid` INT UNSIGNED NOT NULL, `first_postid` BIGINT UNSIGNED NOT NULL DEFAULT 0, `userid` INT 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 UNSIGNED NOT NULL DEFAULT 0, `posts` INT NOT NULL DEFAULT 0, `votes` INT NOT NULL DEFAULT 0, `answers` INT NOT NULL DEFAULT 0, `views` INT UNSIGNED NOT NULL DEFAULT 0, `meta_key` TEXT, `meta_desc` TEXT, `type` TINYINT NOT NULL DEFAULT 0, `solved` TINYINT(1) 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) UNSIGNED NOT NULL DEFAULT 0, `name` VARCHAR(50) NOT NULL DEFAULT '', `email` VARCHAR(50) NOT NULL DEFAULT '', `prefix` VARCHAR(100) NOT NULL DEFAULT '', `tags` TEXT, PRIMARY KEY (`topicid`), UNIQUE KEY `slug` (`slug`(191)), FULLTEXT KEY `title` (`title`), KEY `forumid` (`forumid`), KEY `first_postid` (`first_postid`), KEY `created` (`created`), KEY `modified` (`modified`), KEY `last_post` (`last_post`), KEY `type` (`type`), KEY `status` (`status`), KEY `email` (`email`), KEY `solved` (`solved`), KEY `is_private` (`private`), KEY `own_private` (`userid`,`private`), KEY `forumid_status` (`forumid`,`status`), KEY `forumid_status_private` (`forumid`,`status`,`private`), KEY `prefix` (`prefix`) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci

CREATE TABLE IF NOT EXISTS `avwp_wpforo_posts`( `postid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `parentid` BIGINT UNSIGNED NOT NULL DEFAULT 0, `forumid` INT UNSIGNED NOT NULL, `topicid` BIGINT UNSIGNED NOT NULL, `userid` INT UNSIGNED NOT NULL, `title` varchar(255), `body` LONGTEXT, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `likes` INT UNSIGNED NOT NULL DEFAULT 0, `votes` INT 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) UNSIGNED NOT NULL DEFAULT 0, `name` VARCHAR(50) NOT NULL DEFAULT '', `email` VARCHAR(50) NOT NULL DEFAULT '', `private` tinyint(1) UNSIGNED NOT NULL DEFAULT 0, `root` BIGINT NULL DEFAULT NULL, PRIMARY KEY (`postid`), FULLTEXT KEY `title`(`title`(191)), FULLTEXT KEY `body` (`body`), FULLTEXT KEY `title_plus_body` (`title`,`body`), KEY `topicid` (`topicid`), KEY `forumid` (`forumid`), KEY `userid` (`userid`), KEY `created` (`created`), 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`), KEY `root` (`root`), KEY `forumid_status` (`forumid`,`status`), KEY `topicid_status` (`topicid`,`status`), KEY `topicid_solved` (`topicid`,`is_answer`), KEY `topicid_parentid` (`topicid`,`parentid`), KEY `forumid_status_private` (`forumid`, `status`, `private`), KEY `forumid_answer_first` (`forumid`, `is_answer`, `is_first_post`) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci

CREATE TABLE IF NOT EXISTS `avwp_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_520_ci

CREATE TABLE IF NOT EXISTS `avwp_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_520_ci

CREATE TABLE IF NOT EXISTS `avwp_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_520_ci

CREATE TABLE IF NOT EXISTS `avwp_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_520_ci

CREATE TABLE IF NOT EXISTS `avwp_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_520_ci

CREATE TABLE IF NOT EXISTS `avwp_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(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `type` (`type`), KEY `type_objid_objtype` (`type`,`itemid`,`itemtype`), KEY `type_objid_objtype_userid` (`type`,`itemid`,`itemtype`,`userid`), KEY `date` (`date`) ) ENGINE=INNODB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci

CREATE TABLE IF NOT EXISTS `avwp_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_520_ci

CREATE TABLE IF NOT EXISTS `avwp_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_520_ci

SET AUTOCOMMIT = 1;

 

Posts: 1602
(@anonymous20)
Noble Member
Joined: 8 years ago

That probably means that some of the plugin's  db was not installed.

Enable DEBUG LOG in your wp config and then Disable and Re-enable the plugin. And check your debug.log in wp-content.

Is that a new installation ?

Page 1 / 2