XF 1.5 Error upgrade xenforo 1.5.x to 2.0.x

[VanillaNeko]

Hello,

I have a problem trying to go from xenforo 1.5 to 2.0.

I encounter an SQL error, I have attached a screenshot.

Spoiler: Screenshot

Thanks in advance for your help

 

[Thangvip9x]

Please disable all add-ons and retry @VanillaNeko

 

[VanillaNeko]

Please disable all add-ons and retry @VanillaNeko

Everything is already disabled.

 

[Chris D]

Run this query manually and refresh the page. The error suggests the table is missing, so this query deletes and recreates the table. If there are still errors with this, then you may need to contact your host as it might suggest that the table is corrupted.

DROP TABLE IF EXISTS `xf_phrase_map`;
CREATE TABLE IF NOT EXISTS `xf_phrase_map` (
  `phrase_map_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `language_id` int(10) unsigned NOT NULL,
  `title` varbinary(100) NOT NULL,
  `phrase_id` int(10) unsigned NOT NULL,
  `phrase_group` varbinary(50) DEFAULT NULL,
  PRIMARY KEY (`phrase_map_id`),
  UNIQUE KEY `language_id_title` (`language_id`,`title`),
  KEY `phrase_id` (`phrase_id`),
  KEY `group_language` (`phrase_group`,`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 

[hemant_bhardwaj]

Run this query manually and refresh the page. The error suggests the table is missing, so this query deletes and recreates the table. If there are still errors with this, then you may need to contact your host as it might suggest that the table is corrupted.

DROP TABLE IF EXISTS `xf_phrase_map`;
CREATE TABLE IF NOT EXISTS `xf_phrase_map` (
  `phrase_map_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `language_id` int(10) unsigned NOT NULL,
  `title` varbinary(100) NOT NULL,
  `phrase_id` int(10) unsigned NOT NULL,
  `phrase_group` varbinary(50) DEFAULT NULL,
  PRIMARY KEY (`phrase_map_id`),
  UNIQUE KEY `language_id_title` (`language_id`,`title`),
  KEY `phrase_id` (`phrase_id`),
  KEY `group_language` (`phrase_group`,`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Too fast brother i was going to write same thing as borgan allredy mention it somewhere

 

[VanillaNeko]

Thank you, Chris.

Problem solved.