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.
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.
