AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

Filter by custom fields

Topic prefix

AI Assistant
Notifications
Clear all

[Closed] Add Topic Error

6 Posts
2 Users
0 Reactions
2,661 Views
Posts: 4
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@dipass)
Active Member
Joined: 7 years ago
[#10526]

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.

 Prova

5 Replies
Posts: 4
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@dipass)
Active Member
Joined: 7 years ago

Any solution? @anonymous20 @Sofy


Posts: 1593
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@anonymous20)
Noble Member
Joined: 10 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
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@dipass)
Active Member
Joined: 7 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;

 

 Prova 2

Posts: 1593
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@anonymous20)
Noble Member
Joined: 10 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
Share: