Database Problem
-
I am trying to upgrade a plugin from 2.4 to 4.1:
Failed to perform query “ALTER TABLE
wp_6_redirection_items
ADDmatch_url
VARCHAR(2000) NULL DEFAULT NULL AFTERurl
” – Insufficient database permissions detected. Please give your database user appropriate permissions.update log:
Message: Failed to perform query “ALTER TABLE
wp_6_redirection_items
ADDmatch_url
VARCHAR(2000) NULL DEFAULT NULL AFTERurl
” – Insufficient database permissions detected. Please give your database user appropriate permissions.
Installed: 2.4
Next: 4.1
Debug: ALTER command denied to user ‘wordpress’@’localhost’ for table ‘wp_6_redirection_items’
CREATE TABLEwp_6_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
),
KEYurl
(url
(200)),
KEYstatus
(status
),
KEYregex
(regex
),
KEYgroup_idpos
(group_id
,position
),
KEYgroup
(group_id
)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8CREATE TABLE
wp_6_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
),
KEYmodule_id
(module_id
),
KEYstatus
(status
)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8CREATE TABLE
wp_6_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
),
KEYcreated
(created
),
KEYredirection_id
(redirection_id
),
KEYip
(ip
),
KEYgroup_id
(group_id
),
KEYmodule_id
(module_id
)
) ENGINE=InnoDB AUTO_INCREMENT=1486 DEFAULT CHARSET=utf8CREATE TABLE
wp_6_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
),
KEYcreated
(created
),
KEYurl
(url
),
KEYip
(ip
),
KEYreferrer
(referrer
)
) ENGINE=InnoDB AUTO_INCREMENT=35446 DEFAULT CHARSET=utf8Stage: add_match_url_400
- The topic ‘Database Problem’ is closed to new replies.