• Resolved AllxAlx

    (@allxalx)


    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 ADD match_url VARCHAR(2000) NULL DEFAULT NULL AFTER url
    Installed: 2.4
    Next: 4.0
    Debug:

    Duplicate column name ‘match_url’
    CREATE TABLE wp_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),
    KEY url (url(191)),
    KEY status (status),
    KEY regex (regex),
    KEY group_idpos (group_id,position),
    KEY group (group_id)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

    CREATE 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),
    KEY module_id (module_id),
    KEY status (status)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

    CREATE 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),
    KEY created (created),
    KEY redirection_id (redirection_id),
    KEY ip (ip),
    KEY group_id (group_id),
    KEY module_id (module_id)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

    CREATE 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),
    KEY created (created),
    KEY url (url(191)),
    KEY referrer (referrer(191)),
    KEY ip (ip)
    ) ENGINE=InnoDB AUTO_INCREMENT=7928 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

    Stage: add_match_url_400

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Redirection’s database needs to be updated – click to update.’ is closed to new replies.