Support » Plugin: Redirection » 3.7.1 Error on Upgrade Database “Failed to perform query ALTER TABLE “

  • Resolved nathaningram

    (@nathaningram)


    Hello! I noticed on a previous thread that you released 3.7.1 to deal with this issue, but for me it persists.

    This happens after I click the button to update the database.

    Several of the tables update, then at 66%

    Message: Failed to perform query "ALTER TABLEwpmbha_redirection_404ADD INDEXip(ip`)”
    Installed: 2.3.3
    Next: 2.4
    Debug:

    Duplicate key name ‘ip’
    CREATE TABLE wpmbha_redirection_items (
    id int(11) unsigned NOT NULL AUTO_INCREMENT,
    url mediumtext COLLATE utf8_unicode_ci 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’) COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘enabled’,
    action_type varchar(20) COLLATE utf8_unicode_ci NOT NULL,
    action_code int(11) unsigned NOT NULL,
    action_data mediumtext COLLATE utf8_unicode_ci DEFAULT NULL,
    match_type varchar(20) COLLATE utf8_unicode_ci NOT NULL,
    title varchar(50) COLLATE utf8_unicode_ci 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 AUTO_INCREMENT=96 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

    CREATE TABLE wpmbha_redirection_groups (
    id int(11) NOT NULL AUTO_INCREMENT,
    name varchar(50) COLLATE utf8_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 utf8_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=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

    CREATE TABLE wpmbha_redirection_logs (
    id int(11) unsigned NOT NULL AUTO_INCREMENT,
    created datetime NOT NULL,
    url mediumtext COLLATE utf8_unicode_ci NOT NULL,
    sent_to mediumtext COLLATE utf8_unicode_ci DEFAULT NULL,
    agent mediumtext COLLATE utf8_unicode_ci NOT NULL,
    referrer mediumtext COLLATE utf8_unicode_ci DEFAULT NULL,
    redirection_id int(11) unsigned DEFAULT NULL,
    ip varchar(45) COLLATE utf8_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=MyISAM AUTO_INCREMENT=33918 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

    CREATE TABLE wpmbha_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=MyISAM AUTO_INCREMENT=114490 DEFAULT CHARSET=utf8`

    I then have the TRY AGAIN / SKIP / STOP buttons. Try again gives same error.

    Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘3.7.1 Error on Upgrade Database “Failed to perform query ALTER TABLE “’ is closed to new replies.