Upgrading database stuck at 0%

Hello,

I’m facing a problem during the upgrade. It’s the first time , I got asked to do it. Currently, the upgrade has been stopped with a error message. (Screenshot : https://goo.gl/VQi131 )

Here is the message I have :

Database problem : Failed to perform query "ALTER TABLE 'ucf_redirection_items' ADD INDEX 'match_url' ('match_url')"

Message: Failed to perform query "ALTER TABLE 'ucf_redirection_items' ADD INDEX 'match_url' ('match_url')"
Installed: 2.4
Next: 4.0
Debug:

Index column size too large. The maximum column size is 767 bytes.
CREATE TABLE 'ucf_redirection_items' (
  'id' int(11) unsigned NOT NULL AUTO_INCREMENT,
  'url' mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  'match_url' varchar(2000) COLLATE utf8mb4_unicode_520_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,
  'group_id' int(11) NOT NULL DEFAULT '0',
  'status' enum('enabled','disabled') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'enabled',
  'action_type' varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  'action_code' int(11) unsigned NOT NULL,
  'action_data' mediumtext COLLATE utf8mb4_unicode_520_ci,
  'match_type' varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  'title' text COLLATE utf8mb4_unicode_520_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 AUTO_INCREMENT=136 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

CREATE TABLE 'ucf_redirection_groups' (
  'id' int(11) NOT NULL AUTO_INCREMENT,
  'name' varchar(50) COLLATE utf8mb4_unicode_520_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_520_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_520_ci

CREATE TABLE 'ucf_redirection_logs' (
  'id' int(11) unsigned NOT NULL AUTO_INCREMENT,
  'created' datetime NOT NULL,
  'url' mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  'sent_to' mediumtext COLLATE utf8mb4_unicode_520_ci,
  'agent' mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  'referrer' mediumtext COLLATE utf8mb4_unicode_520_ci,
  'redirection_id' int(11) unsigned DEFAULT NULL,
  'ip' varchar(45) COLLATE utf8mb4_unicode_520_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 AUTO_INCREMENT=9814 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

CREATE TABLE 'ucf_redirection_404' (
  'id' int(11) unsigned NOT NULL AUTO_INCREMENT,
  'created' datetime NOT NULL,
  'url' varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  'agent' varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  'referrer' varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  'ip' varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  PRIMARY KEY ('id'),
  KEY 'created' ('created'),
  KEY 'url' ('url'(191)),
  KEY 'referrer' ('referrer'(191)),
  KEY 'ip' ('ip')
) ENGINE=InnoDB AUTO_INCREMENT=73261 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

Stage: add_match_url_400

"ALTER TABLE 'ucf_redirection_items' ADD INDEX 'match_url' ('match_url')" 

For resolving this issue, I have to three choices:
“Try again” , “skip this page” or “stop upgrade” , what should I do ?

Thanks you by advance for your help

• This topic was modified 5 years, 5 months ago by Jan Dembowski.