Redirection database need to be update
-
Hi,
I got this message when I tried to update the DB, so I tried to do it manually but I notice that I dont have this wp_5dcmpzp4fr_redirection_groups… how i can install, do you got the parameters to create it?Message: Failed to perform query “UPDATE wp_5dcmpzp4fr_redirection_groups SET module_id=1 WHERE module_id > 2”
Installed: 2.3.2
Next: 4.1
Debug: Table ‘dama41424249923.wp_5dcmpzp4fr_redirection_groups’ doesn’t exist
CREATE TABLEwp_5dcmpzp4fr_redirection_items(
idint(11) unsigned NOT NULL AUTO_INCREMENT,
urlmediumtext NOT NULL,
regexint(11) unsigned NOT NULL DEFAULT ‘0’,
positionint(11) unsigned NOT NULL DEFAULT ‘0’,
last_countint(10) unsigned NOT NULL DEFAULT ‘0’,
last_accessdatetime NOT NULL,
group_idint(11) NOT NULL DEFAULT ‘0’,
statusenum(‘enabled’,’disabled’) NOT NULL DEFAULT ‘enabled’,
action_typevarchar(20) NOT NULL,
action_codeint(11) unsigned NOT NULL,
action_datamediumtext,
match_typevarchar(20) NOT NULL,
titlevarchar(50) DEFAULT NULL,
PRIMARY KEY (id),
KEYurl(url(200)),
KEYstatus(status),
KEYregex(regex),
KEYgroup_idpos(group_id,position),
KEYgroup(group_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8La tabla “wp_5dcmpzp4fr_redirection_groups” no existe
CREATE TABLEwp_5dcmpzp4fr_redirection_logs(
idint(11) unsigned NOT NULL AUTO_INCREMENT,
createddatetime NOT NULL,
urlmediumtext NOT NULL,
sent_tomediumtext,
agentmediumtext NOT NULL,
referrermediumtext,
redirection_idint(11) unsigned DEFAULT NULL,
ipvarchar(17) NOT NULL DEFAULT ”,
module_idint(11) unsigned NOT NULL,
group_idint(11) unsigned DEFAULT NULL,
PRIMARY KEY (id),
KEYcreated(created),
KEYredirection_id(redirection_id),
KEYip(ip),
KEYgroup_id(group_id),
KEYmodule_id(module_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8CREATE TABLE
wp_5dcmpzp4fr_redirection_404(
idint(11) unsigned NOT NULL AUTO_INCREMENT,
createddatetime NOT NULL,
urlvarchar(255) NOT NULL DEFAULT ”,
agentvarchar(255) DEFAULT NULL,
referrervarchar(255) DEFAULT NULL,
ipint(10) unsigned NOT NULL,
PRIMARY KEY (id),
KEYcreated(created),
KEYurl(url),
KEYip(ip),
KEYreferrer(referrer)
) ENGINE=MyISAM AUTO_INCREMENT=607109 DEFAULT CHARSET=utf8Stage: fix_invalid_groups_233
The topic ‘Redirection database need to be update’ is closed to new replies.