Title: WordPress database error Unknown character set
Last modified: February 24, 2025

---

# WordPress database error Unknown character set

 *  [druideniggi](https://wordpress.org/support/users/druideniggi/)
 * (@druideniggi)
 * [1 year, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-unknown-character-set/)
 * My server error log reports this only error. Everything up to date. How do I 
   solve the problem?
 * [Mon Feb 24 00:09:52.180892 2025] [fcgid:warn] [pid 150655:tid 150818] [client
   192.0.89.0:57796] mod_fcgid: stderr: WordPress database error Unknown character
   set: ‘utf8mb4_general_ci’ for query
   [Mon Feb 24 00:09:52.180904 2025] [fcgid:
   warn] [pid 150655:tid 150818] [client 192.0.89.0:57796] mod_fcgid: stderr: \t\
   t\t\t\t\tCREATE TABLE wp_yith_wcwl_itemmeta ([Mon Feb 24 00:09:52.180907 2025][
   fcgid:warn] [pid 150655:tid 150818] [client 192.0.89.0:57796] mod_fcgid: stderr:\
   t\t\t\t\t\t\tmeta_id BIGINT( 20 ) NOT NULL AUTO_INCREMENT,[Mon Feb 24 00:09:52.180909
   2025] [fcgid:warn] [pid 150655:tid 150818] [client 192.0.89.0:57796] mod_fcgid:
   stderr: \t\t\t\t\t\t\tyith_wcwl_item_id BIGINT( 20 ) NOT NULL,[Mon Feb 24 00:
   09:52.180911 2025] [fcgid:warn] [pid 150655:tid 150818] [client 192.0.89.0:57796]
   mod_fcgid: stderr: \t\t\t\t\t\t\tmeta_key varchar(255) NULL,[Mon Feb 24 00:09:
   52.180913 2025] [fcgid:warn] [pid 150655:tid 150818] [client 192.0.89.0:57796]
   mod_fcgid: stderr: \t\t\t\t\t\t\tmeta_value longtext NULL,[Mon Feb 24 00:09:52.180916
   2025] [fcgid:warn] [pid 150655:tid 150818] [client 192.0.89.0:57796] mod_fcgid:
   stderr: \t\t\t\t\t\t\tPRIMARY KEY ( meta_id ),[Mon Feb 24 00:09:52.180918 2025][
   fcgid:warn] [pid 150655:tid 150818] [client 192.0.89.0:57796] mod_fcgid: stderr:\
   t\t\t\t\t\t\tKEY item_id ( yith_wcwl_item_id ),[Mon Feb 24 00:09:52.180920 2025][
   fcgid:warn] [pid 150655:tid 150818] [client 192.0.89.0:57796] mod_fcgid: stderr:\
   t\t\t\t\t\t\tKEY meta_key ( meta_key )[Mon Feb 24 00:09:52.180922 2025] [fcgid:
   warn] [pid 150655:tid 150818] [client 192.0.89.0:57796] mod_fcgid: stderr: \t\
   t\t\t\t\t) DEFAULT CHARACTER SET utf8mb4_general_ci made by require(‘wp-blog-
   header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘
   wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters,
   YITH_WCWL_Install->maybe_install, YITH_WCWL_DB::maybe_update, YITH_WCWL_DB::create_tables,
   dbDelta[Mon Feb 24 00:09:52.180928 2025] [fcgid:warn] [pid 150655:tid 150818][
   client 192.0.89.0:57796] mod_fcgid: stderr: WordPress database error Too many
   keys specified; max 64 keys allowed for query ALTER TABLE wp_yith_wcwl_lists 
   CHANGE COLUMN `wishlist_token` wishlist_token VARCHAR( 64 ) NOT NULL UNIQUE made
   by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘
   wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook-
   >do_action, WP_Hook->apply_filters, YITH_WCWL_Install->maybe_install, YITH_WCWL_DB::
   maybe_update, YITH_WCWL_DB::create_tables, dbDelta

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Juan Coronel](https://wordpress.org/support/users/juaancmendez/)
 * (@juaancmendez)
 * [1 year, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-unknown-character-set/#post-18330569)
 * Hello there,
   thanks for contacting us!
 * I recommend you perform the following tests to see if the problem disappears 
   at some point:
    - update WC and WP to the latest version.
    - change to a default WP theme like 2017.
    - leave only WC and our plugin active, and activate your plugins in batches 
      until you find the one that is in conflict.
 * Please let us know.
 * Best regards.
 *  Thread Starter [druideniggi](https://wordpress.org/support/users/druideniggi/)
 * (@druideniggi)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-unknown-character-set/#post-18377397)
 * Sorry for the late answer. We took all your suggestions into account. The error
   report is still there.
 * Is this conflict possibly our website character set utf8mb4_general_ci?
 * Which character set does Yith recommend?

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘WordPress database error Unknown character set’ is closed to new replies.

 * ![](https://ps.w.org/yith-woocommerce-wishlist/assets/icon-128x128.gif?rev=3129302)
 * [YITH WooCommerce Wishlist](https://wordpress.org/plugins/yith-woocommerce-wishlist/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/yith-woocommerce-wishlist/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/yith-woocommerce-wishlist/)
 * [Active Topics](https://wordpress.org/support/plugin/yith-woocommerce-wishlist/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/yith-woocommerce-wishlist/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/yith-woocommerce-wishlist/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [druideniggi](https://wordpress.org/support/users/druideniggi/)
 * Last activity: [1 year, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-unknown-character-set/#post-18377397)
 * Status: not resolved