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

VanillaNeko

Active member
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.

erreur.png

Thanks in advance for your help
 

Chris D

XenForo developer
Staff member
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.
SQL:
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

Well-known member
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.
SQL:
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 :D
 
Top