WordPress.org

1. yusiye
   Member
   Posted 4 years ago #

   WordPress database error: [Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=']
   SELECT series_id FROM wp_in_series_3_0_6_series WHERE series_name='测试' AND owner_id='14'

   WordPress database error: [Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=']
   SELECT series_id FROM wp_in_series_3_0_6_series WHERE series_name='测试' AND owner_id='14'

   Warning: Cannot modify header information - headers already sent by (output started at /home/.stevens/freemoren/freemoren.com/wp-includes/wp-db.php:160) in /home/.stevens/freemoren/freemoren.com/wp-includes/pluggable.php on line 391

   here's the error result i got. Hope this will be corrected in future release.
   Thank you for the great plugin!

2. Quandary
   Member
   Posted 4 years ago #

   I would prefer any support requests be directed to the plugin's site, either via comments, the contact form, or a message posted to the mailing list. I do not, as a rule, monitor these forums.

   The issue here is that your database's default character set is not UTF-8 (or some Chinese-specific charset). In Series uses the database's default character set for all string fields, whereas WordPress (by default) overrides to use UTF-8 (it can be overriden to use other charsets).

   In Series probably should use $wpdb->charset to determine the character set/collation. It doesn't right now, for a variety of reasons. It does still work for all MySQL configurations that use UTF-8 (or any other character set that's appropriate for your region) by default. Gentoo (my development platform) configures MySQL to use UTF-8 by default, though a completely unconfigured MySQL will default to latin1 (the behavior that you're experiencing).

Topic Closed

This topic has been closed to new replies.