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, topicidTable: 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!
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.