• 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 TABLE wp_5dcmpzp4fr_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 DEFAULT CHARSET=utf8

    La tabla “wp_5dcmpzp4fr_redirection_groups” no existe
    CREATE TABLE wp_5dcmpzp4fr_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 DEFAULT CHARSET=utf8

    CREATE TABLE wp_5dcmpzp4fr_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),
    KEY referrer (referrer)
    ) ENGINE=MyISAM AUTO_INCREMENT=607109 DEFAULT CHARSET=utf8

    Stage: fix_invalid_groups_233

The topic ‘Redirection database need to be update’ is closed to new replies.