Table oc_bruteforce_attempts is missing

ℹ️ Support
1

Hi there,

I just migrated the nextcloud to a new server and got the error about failed to select table " oc_bruteforce_attempts" from …

disabling the bruteforce the server works fine, It is clear that the table is missing. What should I do to create the table again in mysql server?

thanks

2

It can be created using following SQL:

CREATE TABLE oc_bruteforce_attempts (
id bigint(20) UNSIGNED NOT NULL,
action varchar(64) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
occurred int(10) UNSIGNED NOT NULL DEFAULT ‘0’,
ip varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
subnet varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
metadata varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

GOT it from a new installation and exported

3

Thanks Bila but my oc_bruteforce_attempts database was corrupted, i can’t use my backup
I can use webmin but i don’t know the prerequisite for recreate this table…
As this example, don’t work with my mariadb
CREATE TABLE oc_bruteforce_attempts (
id bigint(20) UNSIGNED NOT NULL,
action varchar(64) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
occurred int(10) UNSIGNED NOT NULL DEFAULT ‘0’,
ip varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
subnet varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
metadata varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;