Redirection’s database needs to be updated – click to update.
-
Hi,
Can you help me? please
When I want to uptade the data base, I get this error:Message: Failed to perform query “ALTER TABLE
wp_redirection_items
ADDmatch_url
VARCHAR(2000) NULL DEFAULT NULL AFTERurl
”
Installed: 2.4
Next: 4.0
Debug:Duplicate column name ‘match_url’
CREATE TABLEwp_redirection_items
(
id
int(11) unsigned NOT NULL AUTO_INCREMENT,
url
mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
match_url
varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT 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 DEFAULT ‘0000-00-00 00:00:00’,
group_id
int(11) NOT NULL DEFAULT ‘0’,
status
enum(‘enabled’,’disabled’) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ‘enabled’,
action_type
varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
action_code
int(11) unsigned NOT NULL,
action_data
mediumtext COLLATE utf8mb4_unicode_ci,
match_type
varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
title
text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (id
),
KEYurl
(url
(191)),
KEYstatus
(status
),
KEYregex
(regex
),
KEYgroup_idpos
(group_id
,position
),
KEYgroup
(group_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ciCREATE TABLE
wp_redirection_groups
(
id
int(11) unsigned NOT NULL AUTO_INCREMENT,
name
varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
tracking
int(11) NOT NULL DEFAULT ‘1’,
module_id
int(11) unsigned NOT NULL DEFAULT ‘0’,
status
enum(‘enabled’,’disabled’) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ‘enabled’,
position
int(11) unsigned NOT NULL DEFAULT ‘0’,
PRIMARY KEY (id
),
KEYmodule_id
(module_id
),
KEYstatus
(status
)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ciCREATE TABLE
wp_redirection_logs
(
id
int(11) unsigned NOT NULL AUTO_INCREMENT,
created
datetime NOT NULL,
url
mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
sent_to
mediumtext COLLATE utf8mb4_unicode_ci,
agent
mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
referrer
mediumtext COLLATE utf8mb4_unicode_ci,
redirection_id
int(11) unsigned DEFAULT NULL,
ip
varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
module_id
int(11) unsigned NOT NULL,
group_id
int(11) unsigned DEFAULT NULL,
PRIMARY KEY (id
),
KEYcreated
(created
),
KEYredirection_id
(redirection_id
),
KEYip
(ip
),
KEYgroup_id
(group_id
),
KEYmodule_id
(module_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ciCREATE TABLE
wp_redirection_404
(
id
int(11) unsigned NOT NULL AUTO_INCREMENT,
created
datetime NOT NULL,
url
varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ”,
agent
varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
referrer
varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
ip
varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (id
),
KEYcreated
(created
),
KEYurl
(url
(191)),
KEYreferrer
(referrer
(191)),
KEYip
(ip
)
) ENGINE=InnoDB AUTO_INCREMENT=7928 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ciStage: add_match_url_400
The page I need help with: [log in to see the link]
- The topic ‘Redirection’s database needs to be updated – click to update.’ is closed to new replies.