WordPress database error: [Table ‘wp_itsec_log’ already exists]
CREATE TABLE wp_itsec_log ( log_id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, log_type varchar(20) NOT NULL DEFAULT ”, log_function varchar(255) NOT NULL DEFAULT ”, log_priority int(2) NOT NULL DEFAULT 1, log_date datetime NOT NULL DEFAULT ‘1000-01-01 00:00:00’, log_date_gmt datetime NOT NULL DEFAULT ‘1000-01-01 00:00:00’, log_host varchar(40), log_username varchar(60), log_user bigint(20) UNSIGNED, log_url varchar(255), log_referrer varchar(255), log_data longtext NOT NULL, PRIMARY KEY (log_id), KEY log_type (log_type), KEY log_date_gmt (log_date_gmt) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
WordPress database error: [Table ‘./gypsyspoonful_market/wp_itsec_log’ is marked as crashed and last (automatic?) repair failed]
INSERT INTO wp_itsec_log
(log_type
, log_priority
, log_function
, log_date
, log_date_gmt
, log_host
, log_username
, log_user
, log_url
, log_referrer
, log_data
) VALUES (‘brute_force’, 5, ‘Invalid Login Attempt’, ‘2017-08-07 04:39:24’, ‘2017-08-07 09:39:24’, ‘99.98.192.138’, ‘mi-creations’, ‘0’, ”, ”, ‘a:2:{s:6:\”source\”;s:12:\”wp-login.php\”;s:20:\”authentication_types\”;a:1:{i:0;s:21:\”username_and_password\”;}}’)