How to Fix WordPress database error Table ‘wp_termmeta’ doesn’t exist

WordPress database error

Recently I got so many errors log contains WordPress database error Table ‘wpdb.wp_termmeta’ doesn’t exist for query SELECT term_id … . I don’t know why it happened but it says that the table wp_termmeta does not exists.

WordPress Error Database Term Meta Does Not Exists

Error log

[08-Feb-2016 15:19:13 UTC] WordPress database error Table 'wpdb.wp_termmeta' doesn't exist for query SELECT term_id, meta_key, meta_value FROM wp_termmeta WHERE term_id IN (20,55,36,3,8,41,113,117,200,12,14,15,112,6,22,78,7,13,16,17,31,34,61,64,75,93,96,103,107,108,109,110,144,155,202,19,23,4,47,48,49,51,52,40,42) ORDER BY meta_id ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/mythemes/single.php'), get_sidebar, locate_template, load_template, require_once('/themes/mythemes/sidebar.php'), wp_tag_cloud, get_terms, update_termmeta_cache, update_meta_cache
[08-Feb-2016 15:19:23 UTC] WordPress database error Table 'wpdb.wp_termmeta' doesn't exist for query SELECT term_id, meta_key, meta_value FROM wp_termmeta WHERE term_id IN (1,28) ORDER BY meta_id ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/mythemes/single.php'), get_header, locate_template, load_template, require_once('/themes/mythemes/header.php'), wp_nav_menu, wp_get_nav_menu_items, get_terms, update_termmeta_cache, update_meta_cache

Solution

To solve this problem, I created table wp_termmeta

CREATE TABLE IF NOT EXISTS `wp_termmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext,
  PRIMARY KEY (`meta_id`),
  KEY `term_id` (`term_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;