WordPress database error Unknown character set

  • druideniggi

    (@druideniggi)


    1 year, 2 months ago

    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

    (@juaancmendez)

    1 year, 2 months ago

    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

    (@druideniggi)

    1 year, 1 month ago

    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.