benid

@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

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