arthurakay

I just tried hitting the update database button too, and hit the error:

Message: Failed to perform query “CREATE TABLE wp_redirection_404 (
id int(11) unsigned NOT NULL AUTO_INCREMENT,
created datetime NOT NULL,
url varchar(255) NOT NULL DEFAULT ”,
agent varchar(255) DEFAULT NULL,
referrer varchar(255) DEFAULT NULL,
ip int(10) unsigned NOT NULL,
PRIMARY KEY (id),
KEY created (created),
KEY url (url(191)),
KEY ip (ip),
KEY referrer (referrer(191))
) DEFAULT CHARACTER SET utf8mb4 COLLATE=utf8mb4_unicode_520_ci”
Installed: 2.2
Next: 2.4
Debug:

Table ‘wp_redirection_404’ already exists
CREATE TABLE wp_redirection_items (
id int(11) unsigned NOT NULL AUTO_INCREMENT,
url mediumtext NOT NULL,
regex int(11) unsigned NOT NULL DEFAULT ‘0’,
position int(11) unsigned NOT NULL DEFAULT ‘0’,
last_count int(10) unsigned NOT NULL DEFAULT ‘0’,
last_access datetime NOT NULL,
group_id int(11) NOT NULL DEFAULT ‘0’,
status enum(‘enabled’,’disabled’) NOT NULL DEFAULT ‘enabled’,
action_type varchar(20) NOT NULL,
action_code int(11) unsigned NOT NULL,
action_data mediumtext,
match_type varchar(20) NOT NULL,
title varchar(50) DEFAULT NULL,
PRIMARY KEY (id),
KEY url (url(200)),
KEY status (status),
KEY regex (regex),
KEY group_idpos (group_id,position),
KEY group (group_id)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8

CREATE TABLE wp_redirection_groups (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(50) NOT NULL,
tracking int(11) NOT NULL DEFAULT ‘1’,
module_id int(11) unsigned NOT NULL DEFAULT ‘0’,
status enum(‘enabled’,’disabled’) NOT NULL DEFAULT ‘enabled’,
position int(11) unsigned NOT NULL DEFAULT ‘0’,
PRIMARY KEY (id),
KEY module_id (module_id),
KEY status (status)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8

CREATE TABLE wp_redirection_logs (
id int(11) unsigned NOT NULL AUTO_INCREMENT,
created datetime NOT NULL,
url mediumtext NOT NULL,
sent_to mediumtext,
agent mediumtext NOT NULL,
referrer mediumtext,
redirection_id int(11) unsigned DEFAULT NULL,
ip varchar(17) NOT NULL DEFAULT ”,
module_id int(11) unsigned NOT NULL,
group_id int(11) unsigned DEFAULT NULL,
PRIMARY KEY (id),
KEY created (created),
KEY redirection_id (redirection_id),
KEY ip (ip),
KEY group_id (group_id),
KEY module_id (module_id)
) ENGINE=MyISAM AUTO_INCREMENT=111391 DEFAULT CHARSET=utf8

CREATE TABLE wp_redirection_404 (
id int(11) unsigned NOT NULL AUTO_INCREMENT,
created datetime NOT NULL,
url varchar(255) NOT NULL DEFAULT ”,
agent varchar(255) DEFAULT NULL,
referrer varchar(255) DEFAULT NULL,
ip int(10) unsigned NOT NULL,
PRIMARY KEY (id),
KEY created (created),
KEY url (url),
KEY ip (ip,id),
KEY referrer (referrer)
) ENGINE=MyISAM AUTO_INCREMENT=216519 DEFAULT CHARSET=utf8

The message on my screen says:

Your current database is version 2.2, the latest is 2.4. Please update to use new features.

FWIW I also just updated to WP version 5.0.3

If I skip past that error, the next one I run into is:

Failed to perform query “ALTER TABLE wp_redirection_404 ADD INDEX ip (ip)”

Skipping past that error… I think everything is working? Can someone clarify that all is okay?