How to fix XF\Db\Exception: MySQL query error [1932]: Table 'xf_phrase_map' doesn't exist

  • Thread starter Thread starter AdminAdmin is verified member.
  • Start date Start date
Admin

AdminAdmin is verified member.

Well-Known Member
Staff member
Administrator
Today tuoitreit.vn will teach you "How to fix XF\Db\Exception: MySQL query error [1932]: Table 'xf_phrase_map' doesn't exist in engine in src/XF/Db/AbstractStatement.php at line 212"

28767407297_c2167b12df_o.png


Go to phpmyadmin > SQL and run

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;

Good luck!
 

Facebook Comments

Similar threads

Admin
Replies
0
Views
1K
AdminAdmin is verified member.
Admin
Admin
Replies
0
Views
5K
AdminAdmin is verified member.
Admin
Admin
Replies
0
Views
1K
AdminAdmin is verified member.
Admin
Admin
Replies
0
Views
2K
AdminAdmin is verified member.
Admin
Admin
Replies
0
Views
2K
AdminAdmin is verified member.
Admin
Back
Top