Notifications
Clear all

Limited Support

Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed.
We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.

 

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

6 Posts
2 Users
0 Reactions
1,908 Views
Posts: 4
Topic starter
(@dipass)
Active Member
Joined: 6 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: 6 years ago

Any solution? @anonymous20 @Sofy

Posts: 1599
(@anonymous20)
Noble Member
Joined: 9 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: 6 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: 1599
(@anonymous20)
Noble Member
Joined: 9 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