The database character set is set to utf8mb4 but I can’t edit it

  • Resolved shinchaya

    (@shinchaya)


    1 month, 2 weeks ago

    WordPress の データベースの文字セットは utf8mb4 になっているのに
    編集画面でメニューを移動し、保存をクリックすると以下のアラートがでて何もできない

    Although the character set of the WordPress database is set to utf8mb4, when I move the menu on the editing screen and click save, the following alert appears and I can’t do anything.

    —————————————–

    Error: Could not save menu settings.
    Last database error: “WordPress database error: Failed to process the value for the following field: option_value.
    The provided value may be too long or contain invalid data.”

    Last database error: “WordPress データベースエラー: 次のフィールドの値の処理に失敗しました: option_value。
    提供された値が長すぎるか、無効なデータを含んでいる可能性があります。”

    Warning: The wp_options database table uses the outdated utf8 character set.
    This can prevent you from saving settings that contain emojis, certain Chinese characters, and so on.
    It is recommended to convert the table to the utf8mb4 character set.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Janis Elsts

    (@whiteshadow)

    Please verify that the option_value column in the wp_options table is also set to utf8mb4. Different tables and table columns can have different character sets, so even if the default character set for the database is correct, the character set of a specific column could be wrong/outdated.

    Thread Starter shinchaya

    (@shinchaya)

    問題が解消した。ありがとう。

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.