Notifications
Clear all

wpForo 1.x.x [Closed] Problems Found in Database - doesn't exist in engine

2 Posts
2 Users
0 Reactions
927 Views
Posts: 6
Topic starter
(@mc_deimon)
Active Member
Joined: 6 years ago

Hello! I am receiving these errors from my database.

Problems Found in Database

Table: wp_bienwpforo_visits
Missing fields:  id, userid, name, ip, time, forumid, topicid
Table: wp_bienwpforo_visits
Missing keys:  id, userid, forumid, topicid, time, ip, time_forumid, time_topicid, unique_tracking

I used the "solve database problems" button but I can't fix it.

 

I have accessed my database and in the sql tab I have placed the following text in the console:

SET AUTOCOMMIT = 0;
ALTER TABLE `wp_bienwpforo_visits` ADD `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `wp_bienwpforo_visits` ADD `userid` BIGINT UNSIGNED NOT NULL;
ALTER TABLE `wp_bienwpforo_visits` ADD `name` VARCHAR(60) NOT NULL;
ALTER TABLE `wp_bienwpforo_visits` ADD `ip` VARCHAR(60) NOT NULL;
ALTER TABLE `wp_bienwpforo_visits` ADD `time` INT UNSIGNED NOT NULL;
ALTER TABLE `wp_bienwpforo_visits` ADD `forumid` INT UNSIGNED NOT NULL;
ALTER TABLE `wp_bienwpforo_visits` ADD `topicid` BIGINT UNSIGNED NOT NULL;
ALTER TABLE `wp_bienwpforo_visits` ADD KEY `userid` (`userid`);
ALTER TABLE `wp_bienwpforo_visits` ADD KEY `forumid` (`forumid`);
ALTER TABLE `wp_bienwpforo_visits` ADD KEY `topicid` (`topicid`);
ALTER TABLE `wp_bienwpforo_visits` ADD KEY `time` (`time`);
ALTER TABLE `wp_bienwpforo_visits` ADD KEY `ip` (`ip`);
ALTER TABLE `wp_bienwpforo_visits` ADD KEY `time_forumid` (`time`,`forumid`);
ALTER TABLE `wp_bienwpforo_visits` ADD KEY `time_topicid` (`time`,`topicid`);
ALTER TABLE `wp_bienwpforo_visits` ADD UNIQUE KEY `unique_tracking` (`userid`,`ip`,`forumid`,`topicid`);
SET AUTOCOMMIT = 1;

And I receive the following error:

ALTER TABLE `wp_bienwpforo_visits` ADD `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT

Can you help me?

Thanks!

 
1 Reply
Sofy
Posts: 4472
 Sofy
Admin
(@sofy)
Support Team
Joined: 6 years ago

Hi @mc_deimon,

The same issue is described here:  https://wordpress.org/support/topic/error-creating-a-discussion/

You should contact to your hosting service and let them know that the tables can’t be created in your website database.