Error Message: “Redirection needs to be updated to version 2.4”

If you press the upgrade link what happens?

I got the same error message. I went to the Plugins page in WordPress and noticed Redirection had red lettering saying “upgrade database.” I clicked on the link and it brought me to a page that explained the Redirection database was version 2.3.3 and should be 2.4.

On that page, it had a button to upgrade the database, so I clicked it. It upgraded the database and all is working as it should.

Ok, great. It’s not an error message, it’s a upgrade notice. I will reword the original message so this is more clear

Hi, when I follow the steps to upgrade I get an error as follows, any idea how to solve the problem ? Thank you very much

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

Message: Failed to perform query “ALTER TABLE wp_redirection_404 ADD INDEX ip (ip)”
Installed: 2.3.3
Next: 2.4
Debug:

Duplicate key name ‘ip’
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=20 DEFAULT CHARSET=latin1

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=latin1

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(45) DEFAULT NULL,
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=3508 DEFAULT CHARSET=latin1

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 varchar(45) DEFAULT NULL,
PRIMARY KEY (id),
KEY created (created),
KEY url (url),
KEY ip (id),
KEY referrer (referrer)
) ENGINE=MyISAM AUTO_INCREMENT=320043 DEFAULT CHARSET=utf8

Also after getting this error I got 2 options : SKIP or STOP so far I prefered to STOP, bu is it fine if I try to SKIP maybe, won’t have any problems ?

I tried a few times but keep getting the same error.

I’ve released 3.7.1 which should clarify the wording, and not show the above error.

I see this message “Redirection’s database needs to be updated – click to update from 2.3.3 to 2.4”, I click the link but I’m not seeing the update button on this page /wp-admin/tools.php?page=redirection.php with Redirection 3.7.1?

And the Redirection settings page just redirects to the above so I am not able to see settings.

@johnny5
Thank you I just tried again the upgrade and it worked fine. Thank you for your prompt assistance !
—
Setting up Redirection
Progress: 100%
Expand size of redirect titles

Finished! ??
—–
Have a good day

@benid, great, glad it worked!

@clivewalker are you saying there is no upgrade notice on the Redirection admin page at all, but you get a notice elsewhere in /wp-admin/?

I see the upgrade notices on all pages. However, when I click through from this, there is no upgrade button on the page /wp-admin/tools.php?page=redirection.php

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?

@clivewalker is it possible that your pages may be cached in some way? It’s very strange it would alert you to an upgrade on one page, and not on another – the code to detect the difference is the same. If you don’t think its cached then would it be possible to check things out myself? I can be contacted at https://redirection.me/contact/

@arthurakay It seems you already had things installed, and then it tried to install over them. I’m not sure why that would happen and unfortunately it’s too late to see what could trigger it. If you did happen to have a backup of your database then I’d certainly be interested to see what the state of some of your settings were. Things should work fine after skipping anyway.

I have reverted back to Redirection 3.6.3 for the moment. This is so I can export my 301 redirects and check the 404s before I do any more on this.

Just to re-iterate, I cannot see any settings or an update button on this page /wp-admin/tools.php?page=redirection.php with Redirection 3.7.1. There are no errors in logs.

I have done a hard refresh and viewed the page in other incognito windows and other browsers but get the same problem. I cannot do anything with the plugin after 3.7.1 upgrade, presumably because the database has not been updated.

I will check it on a local version tomorrow.