Upgrade to 4.2 fail.

  • Resolved Nicorel

    (@nicorel)


    4 years, 1 month ago

    Message: Failed to perform query “ALTER TABLE 1bB_redirection_logs ADD domain VARCHAR(255) NULL DEFAULT NULL AFTER url”
    Installed: 4.1
    Next: 4.2

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter Nicorel

    (@nicorel)

    Debug: Duplicate column name ‘domain’
    CREATE TABLE 1bB_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,
    match_data text COLLATE utf8mb4_unicode_ci,
    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 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(200)),
    KEY status (status),
    KEY regex (regex),
    KEY group_idpos (group_id,position),
    KEY group (group_id),
    KEY match_url (match_url(191))
    ) ENGINE=MyISAM AUTO_INCREMENT=7348 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

    CREATE TABLE 1bB_redirection_groups (
    id int(11) 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=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

    CREATE TABLE 1bB_redirection_logs (
    id int(11) unsigned NOT NULL AUTO_INCREMENT,
    created datetime NOT NULL,
    url mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
    domain varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    sent_to mediumtext COLLATE utf8mb4_unicode_ci,
    agent mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
    referrer mediumtext COLLATE utf8mb4_unicode_ci,
    http_code int(11) unsigned NOT NULL DEFAULT ‘0’,
    request_method varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    request_data mediumtext COLLATE utf8mb4_unicode_ci,
    redirect_by varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    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=MyISAM AUTO_INCREMENT=11645 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

    CREATE TABLE 1bB_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(250)),
    KEY referrer (referrer(250)),
    KEY ip (ip)
    ) ENGINE=MyISAM AUTO_INCREMENT=7025969 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

    Stage: add_extra_logging

    Plugin Author John Godley

    (@johnny5)

    As suggested in the error messages, this kind of thing is best sent direct to me, or put on Github.

    You appear to already have upgraded your site so can press the skip button.

    Thread Starter Nicorel

    (@nicorel)

    Thank you.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Upgrade to 4.2 fail.’ is closed to new replies.