[wp-trac] [WordPress Trac] #32279: Creating new posts/terms with non-latin characters is broken for tables with cp1251 collation in 4.1.5

[WordPress Trac]

#32279: Creating new posts/terms with non-latin characters is broken for tables
with cp1251 collation in 4.1.5
--------------------------+-----------------------
 Reporter:  vloo          |       Owner:  dd32
     Type:  defect (bug)  |      Status:  reopened
 Priority:  high          |   Milestone:  4.2.3
Component:  Database      |     Version:  4.1.5
 Severity:  critical      |  Resolution:
 Keywords:                |     Focuses:
--------------------------+-----------------------
Changes (by SergeyBiryukov):

 * status:  closed => reopened
 * resolution:  fixed =>


Comment:

 I can still reproduce the issue in 4.2.3 with the steps from comment:3,
 and I'm seeing a lot of similar reports on support forums from those using
 the `cp1251` charset.

 Steps to reproduce:
 1. Get a [https://bg.wordpress.org/ Bulgarian] or
 [https://ru.wordpress.org/ Russian] package.
 2. Before installing, set `DB_CHARSET` to `cp1251` in `wp-config.php`.
 3. Proceed with installing.

 * When you try to view the site after installing, the default content is
 missing.
 * If you try to create a post or page, you'll always see
 [https://core.trac.wordpress.org/browser/tags/4.2.3/src/wp-admin/edit-
 form-advanced.php#L48 _wp_posts_page_notice()] instead of the editor,
 because [https://core.trac.wordpress.org/browser/tags/4.2.3/src/wp-
 admin/includes/post.php#L571 get_default_post_to_edit()] never succeeds
 due to `__( 'Auto Draft' )` being translated into Cyrillic.
 * If installing with `WP_DEBUG` enabled, there's a bunch of errors in the
 process:

 {{{
 Notice: Undefined index: x_term_id in wp-includes/wp-db.php on line 2751
 Notice: Undefined index: x_slug in wp-includes/wp-db.php on line 2751
 Notice: Undefined index: x_term_group in wp-includes/wp-db.php on line
 2751

 Notice: Undefined index: x_post_author in wp-includes/wp-db.php on line
 2751
 Notice: Undefined index: x_post_date in wp-includes/wp-db.php on line 2751
 Notice: Undefined index: x_post_date_gmt in wp-includes/wp-db.php on line
 2751
 Notice: Undefined index: x_post_content in wp-includes/wp-db.php on line
 2751
 Notice: Undefined index: x_post_excerpt in wp-includes/wp-db.php on line
 2751
 Notice: Undefined index: x_post_name in wp-includes/wp-db.php on line 2751
 Notice: Undefined index: x_post_modified in wp-includes/wp-db.php on line
 2751
 Notice: Undefined index: x_post_modified_gmt in wp-includes/wp-db.php on
 line 2751
 Notice: Undefined index: x_guid in wp-includes/wp-db.php on line 2751
 Notice: Undefined index: x_comment_count in wp-includes/wp-db.php on line
 2751
 Notice: Undefined index: x_to_ping in wp-includes/wp-db.php on line 2751
 Notice: Undefined index: x_pinged in wp-includes/wp-db.php on line 2751
 Notice: Undefined index: x_post_content_filtered in wp-includes/wp-db.php
 on line 2751

 Notice: Undefined index: x_comment_post_ID in wp-includes/wp-db.php on
 line 2751
 Notice: Undefined index: x_comment_author_email in wp-includes/wp-db.php
 on line 2751
 Notice: Undefined index: x_comment_author_url in wp-includes/wp-db.php on
 line 2751
 Notice: Undefined index: x_comment_date in wp-includes/wp-db.php on line
 2751
 Notice: Undefined index: x_comment_date_gmt in wp-includes/wp-db.php on
 line 2751
 Notice: Undefined index: x_comment_content in wp-includes/wp-db.php on
 line 2751

 Notice: Undefined index: x_post_author in wp-includes/wp-db.php on line
 2751
 Notice: Undefined index: x_post_date in wp-includes/wp-db.php on line 2751
 Notice: Undefined index: x_post_date_gmt in wp-includes/wp-db.php on line
 2751
 Notice: Undefined index: x_post_content in wp-includes/wp-db.php on line
 2751
 Notice: Undefined index: x_post_excerpt in wp-includes/wp-db.php on line
 2751
 Notice: Undefined index: x_post_name in wp-includes/wp-db.php on line 2751
 Notice: Undefined index: x_post_modified in wp-includes/wp-db.php on line
 2751
 Notice: Undefined index: x_post_modified_gmt in wp-includes/wp-db.php on
 line 2751
 Notice: Undefined index: x_guid in wp-includes/wp-db.php on line 2751
 Notice: Undefined index: x_post_type in wp-includes/wp-db.php on line 2751
 Notice: Undefined index: x_to_ping in wp-includes/wp-db.php on line 2751
 Notice: Undefined index: x_pinged in wp-includes/wp-db.php on line 2751
 Notice: Undefined index: x_post_content_filtered wp-includes/wp-db.php on
 line 2751
 }}}

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