Hi @viosys,
I’m sorry to hear that you are experiencing that error. Typically, that error message would be accompanied by another error message indicating what went wrong when trying to create the table.
Is there any other part of that error message?
Could you check your site’s error logs for messages that start with “WordPress database error”?
Thread Starter
viosys
(@viosys)
Hi,
no, there is no other error. The text in the first post is the only text shown in WP-Backend for this.
There is no other error in error.log.
But: its a network-installation. The main dashboard does not show the error, only one sub-website in the network show it. I run network-update twice without any change.
Actual there are 8 database-tables with “itsec” in the database. None of them are used by a sub-website-db. e.g.:
prefix_itsec_log
Any other hints for this?
only one sub-website in the network show it
That is strange. It should either be showing on any site dashboard, or not at all. The upgrade only happens at the network level, there isn’t a per-site upgrade.
Actual there are 8 database-tables with “itsec” in the database. None of them are used by a sub-website-db. e.g.:
prefix_itsec_log
Could you share that list of tables including any prefix? It is correct that they shouldn’t have a blog prefix like wp_1_itsec but would have the base prefix set in wp-config.php. So wp_itsec.
Thread Starter
viosys
(@viosys)
I must correct me: the error is shown on every sub-website in dashboard. 😐
Following tables exists:
- prefix_itsec_distributed_storage
- prefix_itsec_fingerprints
- prefix_itsec_geolocation_cache
- prefix_itsec_lockouts
- prefix_itsec_log
- prefix_itsec_logs
- prefix_itsec_opaque_tokens
- prefix_itsec_temp
That’s very strange. At this point, I can only recommend trying to install the tables manually. If you have access to phpMyAdmin or similar tools, you can run the following SQL to create those tables. Make sure to replace the prefix_ with the correct $table_prefix for your installation.
CREATE TABLE prefix_itsec_user_groups (
group_id char(36) NOT NULL,
group_label varchar(255) NOT NULL default '',
group_roles TEXT,
group_canonical TEXT,
group_users TEXT,
group_min_role varchar(255),
group_created_at DATETIME,
PRIMARY KEY (group_id)
);
CREATE TABLE prefix_itsec_mutexes (
mutex_id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
mutex_name varchar(100) NOT NULL,
mutex_expires int(11) UNSIGNED NOT NULL,
PRIMARY KEY (mutex_id),
UNIQUE KEY mutex_name (mutex_name)
);
Thread Starter
viosys
(@viosys)
Thanks for your help. Creating the missed tables manually worked.
Glad to hear that worked!
