• Resolved Leinad4Mind

    (@leinad4mind)


    Got an error when updating:

    Message: No upgrades found for version 2.4
    Installed: 2.4
    Next: 4.1

    Debug: CREATE TABLEwp_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=InnoDB AUTO_INCREMENT=217 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=InnoDB 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=InnoDB AUTO_INCREMENT=155297 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=InnoDB AUTO_INCREMENT=5171319 DEFAULT CHARSET=utf8

    Stage: swap_ip_column_240`

    • This topic was modified 5 years, 3 months ago by Leinad4Mind.
    • This topic was modified 5 years, 3 months ago by Leinad4Mind.
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Cannot update’ is closed to new replies.