[wp-trac] [WordPress Trac] #60362: Emojis cause "Updating failed. Could not update post in the database." error

[WordPress Trac]

#60362: Emojis cause "Updating failed. Could not update post in the database."
error
-------------------------------------------------+-------------------------
 Reporter:  mikefitzman                          |       Owner:  (none)
     Type:  defect (bug)                         |      Status:  new
 Priority:  normal                               |   Milestone:  Awaiting
                                                 |  Review
Component:  Database                             |     Version:
 Severity:  normal                               |  Resolution:
 Keywords:  has-testing-info needs-testing       |     Focuses:
  needs-screenshots                              |
-------------------------------------------------+-------------------------

Comment (by salzano):

 OK. I deactivated all plugins. I still can't save a flag emoji in a
 Template Part.

 I found that my tables were not all the same collation. I ran the query
 `SHOW TABLE STATUS` and found they looked like this:


 {{{
 wp_cf_form_entries      utf8mb4_unicode_520_ci
 wp_cf_form_entry_meta   utf8mb4_unicode_520_ci
 wp_cf_form_entry_values utf8mb4_unicode_520_ci
 wp_cf_forms     utf8mb4_unicode_520_ci
 wp_cf_pro_messages      utf8mb4_unicode_520_ci
 wp_cf_queue_failures    utf8mb4_unicode_520_ci
 wp_cf_queue_jobs        utf8mb4_unicode_520_ci
 wp_commentmeta  utf8mb3_general_ci
 wp_comments     utf8mb3_general_ci
 wp_edd_adjustmentmeta   utf8mb4_unicode_520_ci
 wp_edd_adjustments      utf8mb4_unicode_520_ci
 wp_edd_customer_addresses       utf8mb4_unicode_520_ci
 wp_edd_customer_email_addresses utf8mb4_unicode_520_ci
 wp_edd_customermeta     utf8mb3_general_ci
 wp_edd_customers        utf8mb3_general_ci
 wp_edd_license_activations      utf8mb3_general_ci
 wp_edd_licensemeta      utf8mb3_general_ci
 wp_edd_licenses utf8mb3_general_ci
 wp_edd_logmeta  utf8mb4_unicode_520_ci
 wp_edd_logs     utf8mb4_unicode_520_ci
 wp_edd_logs_api_requestmeta     utf8mb4_unicode_520_ci
 wp_edd_logs_api_requests        utf8mb4_unicode_520_ci
 wp_edd_logs_file_downloadmeta   utf8mb4_unicode_520_ci
 wp_edd_logs_file_downloads      utf8mb4_unicode_520_ci
 wp_edd_notemeta utf8mb4_unicode_520_ci
 wp_edd_notes    utf8mb4_unicode_520_ci
 wp_edd_notifications    utf8mb4_unicode_520_ci
 wp_edd_order_addresses  utf8mb4_unicode_520_ci
 wp_edd_order_adjustmentmeta     utf8mb4_unicode_520_ci
 wp_edd_order_adjustments        utf8mb4_unicode_520_ci
 wp_edd_order_itemmeta   utf8mb4_unicode_520_ci
 wp_edd_order_items      utf8mb4_unicode_520_ci
 wp_edd_order_transactions       utf8mb4_unicode_520_ci
 wp_edd_ordermeta        utf8mb4_unicode_520_ci
 wp_edd_orders   utf8mb4_unicode_520_ci
 wp_gf_addon_feed        utf8mb4_unicode_520_ci
 wp_gf_draft_submissions utf8mb4_unicode_520_ci
 wp_gf_entry     utf8mb4_unicode_520_ci
 wp_gf_entry_meta        utf8mb4_unicode_520_ci
 wp_gf_entry_notes       utf8mb4_unicode_520_ci
 wp_gf_form      utf8mb4_unicode_520_ci
 wp_gf_form_meta utf8mb4_unicode_520_ci
 wp_gf_form_revisions    utf8mb4_unicode_520_ci
 wp_gf_form_view utf8mb4_unicode_520_ci
 wp_gf_rest_api_keys     utf8mb4_unicode_520_ci
 wp_links        utf8mb3_general_ci
 wp_nextend2_image_storage       utf8mb3_general_ci
 wp_nextend2_section_storage     utf8mb3_general_ci
 wp_nextend2_smartslider3_generators     utf8mb3_general_ci
 wp_nextend2_smartslider3_sliders        utf8mb3_general_ci
 wp_nextend2_smartslider3_sliders_xref   utf8mb3_general_ci
 wp_nextend2_smartslider3_slides utf8mb3_general_ci
 wp_options      utf8mb3_general_ci
 wp_p2p  utf8mb4_unicode_520_ci
 wp_p2pmeta      utf8mb4_unicode_520_ci
 wp_postmeta     utf8mb3_general_ci
 wp_posts        utf8mb3_general_ci
 wp_redirection_404      utf8mb4_unicode_520_ci
 wp_redirection_groups   utf8mb4_unicode_520_ci
 wp_redirection_items    utf8mb4_unicode_520_ci
 wp_redirection_logs     utf8mb4_unicode_520_ci
 wp_term_relationships   utf8mb3_general_ci
 wp_term_taxonomy        utf8mb3_general_ci
 wp_termmeta     utf8mb3_general_ci
 wp_terms        utf8mb3_general_ci
 wp_usermeta     utf8mb3_general_ci
 wp_users        utf8mb3_general_ci
 }}}


 I used the linked github page to run queries to change them. Every table
 in the database is now utf8mb4_unicode_ci. I still can't save the flag
 emoji in a Template Part.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/60362#comment:11>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform