Title: The problem with the coding header
Last modified: November 18, 2016

---

# The problem with the coding header

 *  Resolved [ikiterder](https://wordpress.org/support/users/ikiterder/)
 * (@ikiterder)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/the-problem-with-the-coding-header/)
 * I have to use on your website testing a virtual plug-ins on your site through
   xampp.
 * That’s what I see on all Russian-language titles in the statistics:
 * ![Foto](https://i0.wp.com/i84.fastpic.ru/big/2016/1118/da/7b2d4b76713cfe75b38ebae66fd4eeda.
   png)
 * Previously, I’ve never anything like this does not come across. Because of this,
   I am afraid to use the plug-in on the real site. It can be fixed?
 * Virtual Server Settings:
 * ![Foto](https://i0.wp.com/i84.fastpic.ru/big/2016/1118/39/399055af9a2d907652bdb57387c73039.
   png)
 * Sorry for my English

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Plugin Author [Lester Chan](https://wordpress.org/support/users/gamerz/)
 * (@gamerz)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/the-problem-with-the-coding-header/#post-8455800)
 * I can’t reproduce this issue. [http://imgur.com/yRthKV2](http://imgur.com/yRthKV2)
 * Check to see if your database is using the correct encoding?
 * CHARSET is utf8mb4 and COLLATE is utf8mb4_unicode_ci
 * If it doesn’t work, try overwriting it with the dev version [https://github.com/lesterchan/wp-postratings/archive/master.zip](https://github.com/lesterchan/wp-postratings/archive/master.zip).
 * Only the new entries will be fixed as indicated in my screenshot.
 *  Thread Starter [ikiterder](https://wordpress.org/support/users/ikiterder/)
 * (@ikiterder)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/the-problem-with-the-coding-header/#post-8456981)
 * Encoding is correct. I went in the server logs and saw a set of such records.
   Maybe they will help in solving the problem:
 *     ```
       [Thu Nov 17 14:45:15.697412 2016] [:error] [pid 5764:tid 1588] [client ::1:50953] \xd0\x91\xd0\xb0\xd0\xb7\xd0\xb0 \xd0\xb4\xd0\xb0\xd0\xbd\xd0\xbd\xd1\x8b\xd1\x85 WordPress \xd0\xb2\xd0\xbe\xd0\xb7\xd0\xb2\xd1\x80\xd0\xb0\xd1\x82\xd0\xb8\xd0\xbb\xd0\xb0 \xd0\xbe\xd1\x88\xd0\xb8\xd0\xb1\xd0\xba\xd1\x83 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '<>' \xd0\xb2 \xd0\xbe\xd1\x82\xd0\xb2\xd0\xb5\xd1\x82 \xd0\xbd\xd0\xb0 \xd0\xb7\xd0\xb0\xd0\xbf\xd1\x80\xd0\xbe\xd1\x81 SELECT DISTINCT rating_username, rating_userid FROM wp_ratings WHERE rating_username != '\xd0\x93\xd0\xbe\xd1\x81\xd1\x82\xd1\x8c' ORDER BY rating_userid ASC, rating_username ASC, \xd0\xb2\xd1\x8b\xd0\xbf\xd0\xbe\xd0\xbb\xd0\xbd\xd0\xb5\xd0\xbd\xd0\xbd\xd1\x8b\xd0\xb9 include('D:\\Program Files\\xampp\\htdocs\\wordpress\\wp-content\\plugins\\wp-postratings\\postratings-manager.php'), referer: http://localhost/wordpress/wp-admin/plugins.php?plugin_status=all&paged=1&s
       [Thu Nov 17 14:45:30.725439 2016] [:error] [pid 5764:tid 1588] [client ::1:50953] \xd0\x91\xd0\xb0\xd0\xb7\xd0\xb0 \xd0\xb4\xd0\xb0\xd0\xbd\xd0\xbd\xd1\x8b\xd1\x85 WordPress \xd0\xb2\xd0\xbe\xd0\xb7\xd0\xb2\xd1\x80\xd0\xb0\xd1\x82\xd0\xb8\xd0\xbb\xd0\xb0 \xd0\xbe\xd1\x88\xd0\xb8\xd0\xb1\xd0\xba\xd1\x83 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '<>' \xd0\xb2 \xd0\xbe\xd1\x82\xd0\xb2\xd0\xb5\xd1\x82 \xd0\xbd\xd0\xb0 \xd0\xb7\xd0\xb0\xd0\xbf\xd1\x80\xd0\xbe\xd1\x81 SELECT DISTINCT rating_username, rating_userid FROM wp_ratings WHERE rating_username != '\xd0\x93\xd0\xbe\xd1\x81\xd1\x82\xd1\x8c' ORDER BY rating_userid ASC, rating_username ASC, \xd0\xb2\xd1\x8b\xd0\xbf\xd0\xbe\xd0\xbb\xd0\xbd\xd0\xb5\xd0\xbd\xd0\xbd\xd1\x8b\xd0\xb9 include('D:\\Program Files\\xampp\\htdocs\\wordpress\\wp-content\\plugins\\wp-postratings\\postratings-manager.php'), referer: http://localhost/wordpress/wp-admin/admin.php?page=wp-postratings%2Fpostratings-options.php
       [Thu Nov 17 14:47:09.854610 2016] [:error] [pid 5764:tid 1580] [client ::1:50985] \xd0\x91\xd0\xb0\xd0\xb7\xd0\xb0 \xd0\xb4\xd0\xb0\xd0\xbd\xd0\xbd\xd1\x8b\xd1\x85 WordPress \xd0\xb2\xd0\xbe\xd0\xb7\xd0\xb2\xd1\x80\xd0\xb0\xd1\x82\xd0\xb8\xd0\xbb\xd0\xb0 \xd0\xbe\xd1\x88\xd0\xb8\xd0\xb1\xd0\xba\xd1\x83 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '<>' \xd0\xb2 \xd0\xbe\xd1\x82\xd0\xb2\xd0\xb5\xd1\x82 \xd0\xbd\xd0\xb0 \xd0\xb7\xd0\xb0\xd0\xbf\xd1\x80\xd0\xbe\xd1\x81 SELECT DISTINCT rating_username, rating_userid FROM wp_ratings WHERE rating_username != '\xd0\x93\xd0\xbe\xd1\x81\xd1\x82\xd1\x8c' ORDER BY rating_userid ASC, rating_username ASC, \xd0\xb2\xd1\x8b\xd0\xbf\xd0\xbe\xd0\xbb\xd0\xbd\xd0\xb5\xd0\xbd\xd0\xbd\xd1\x8b\xd0\xb9 include('D:\\Program Files\\xampp\\htdocs\\wordpress\\wp-content\\plugins\\wp-postratings\\postratings-manager.php')
       [Thu Nov 17 14:47:39.224661 2016] [:error] [pid 5764:tid 1624] [client ::1:51003] \xd0\x91\xd0\xb0\xd0\xb7\xd0\xb0 \xd0\xb4\xd0\xb0\xd0\xbd\xd0\xbd\xd1\x8b\xd1\x85 WordPress \xd0\xb2\xd0\xbe\xd0\xb7\xd0\xb2\xd1\x80\xd0\xb0\xd1\x82\xd0\xb8\xd0\xbb\xd0\xb0 \xd0\xbe\xd1\x88\xd0\xb8\xd0\xb1\xd0\xba\xd1\x83 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '<>' \xd0\xb2 \xd0\xbe\xd1\x82\xd0\xb2\xd0\xb5\xd1\x82 \xd0\xbd\xd0\xb0 \xd0\xb7\xd0\xb0\xd0\xbf\xd1\x80\xd0\xbe\xd1\x81 SELECT DISTINCT rating_username, rating_userid FROM wp_ratings WHERE rating_username != '\xd0\x93\xd0\xbe\xd1\x81\xd1\x82\xd1\x8c' ORDER BY rating_userid ASC, rating_username ASC, \xd0\xb2\xd1\x8b\xd0\xbf\xd0\xbe\xd0\xbb\xd0\xbd\xd0\xb5\xd0\xbd\xd0\xbd\xd1\x8b\xd0\xb9 include('D:\\Program Files\\xampp\\htdocs\\wordpress\\wp-content\\plugins\\wp-postratings\\postratings-manager.php'), referer: http://localhost/wordpress/wp-admin/index.php
       [Thu Nov 17 14:49:34.758725 2016] [:error] [pid 5764:tid 1600] [client ::1:51095] \xd0\x91\xd0\xb0\xd0\xb7\xd0\xb0 \xd0\xb4\xd0\xb0\xd0\xbd\xd0\xbd\xd1\x8b\xd1\x85 WordPress \xd0\xb2\xd0\xbe\xd0\xb7\xd0\xb2\xd1\x80\xd0\xb0\xd1\x82\xd0\xb8\xd0\xbb\xd0\xb0 \xd0\xbe\xd1\x88\xd0\xb8\xd0\xb1\xd0\xba\xd1\x83 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '<>' \xd0\xb2 \xd0\xbe\xd1\x82\xd0\xb2\xd0\xb5\xd1\x82 \xd0\xbd\xd0\xb0 \xd0\xb7\xd0\xb0\xd0\xbf\xd1\x80\xd0\xbe\xd1\x81 SELECT DISTINCT rating_username, rating_userid FROM wp_ratings WHERE rating_username != '\xd0\x93\xd0\xbe\xd1\x81\xd1\x82\xd1\x8c' ORDER BY rating_userid ASC, rating_username ASC, \xd0\xb2\xd1\x8b\xd0\xbf\xd0\xbe\xd0\xbb\xd0\xbd\xd0\xb5\xd0\xbd\xd0\xbd\xd1\x8b\xd0\xb9 include('D:\\Program Files\\xampp\\htdocs\\wordpress\\wp-content\\plugins\\wp-postratings\\postratings-manager.php'), referer: http://localhost/wordpress/wp-admin/plugins.php?plugin_status=all&paged=1&s
       [Thu Nov 17 14:50:44.214686 2016] [:error] [pid 5764:tid 1576] [client ::1:51134] \xd0\x91\xd0\xb0\xd0\xb7\xd0\xb0 \xd0\xb4\xd0\xb0\xd0\xbd\xd0\xbd\xd1\x8b\xd1\x85 WordPress \xd0\xb2\xd0\xbe\xd0\xb7\xd0\xb2\xd1\x80\xd0\xb0\xd1\x82\xd0\xb8\xd0\xbb\xd0\xb0 \xd0\xbe\xd1\x88\xd0\xb8\xd0\xb1\xd0\xba\xd1\x83 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '<>' \xd0\xb2 \xd0\xbe\xd1\x82\xd0\xb2\xd0\xb5\xd1\x82 \xd0\xbd\xd0\xb0 \xd0\xb7\xd0\xb0\xd0\xbf\xd1\x80\xd0\xbe\xd1\x81 SELECT DISTINCT rating_username, rating_userid FROM wp_ratings WHERE rating_username != '\xd0\x93\xd0\xbe\xd1\x81\xd1\x82\xd1\x8c' ORDER BY rating_userid ASC, rating_username ASC, \xd0\xb2\xd1\x8b\xd0\xbf\xd0\xbe\xd0\xbb\xd0\xbd\xd0\xb5\xd0\xbd\xd0\xbd\xd1\x8b\xd0\xb9 include('D:\\Program Files\\xampp\\htdocs\\wordpress\\wp-content\\plugins\\wp-postratings\\postratings-manager.php'), referer: http://localhost/wordpress/wp-admin/admin.php?page=wp-postratings%2Fpostratings-manager.php
       ```
   
 *  Thread Starter [ikiterder](https://wordpress.org/support/users/ikiterder/)
 * (@ikiterder)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/the-problem-with-the-coding-header/#post-8457367)
 * Encoding is correct.
 * ![Foto](https://i0.wp.com/i84.fastpic.ru/big/2016/1119/0f/ab5b3902d9d29782def0c5739c55220f.
   png)
 * The server log a lot of records on this issue. Maybe this will help.
    [http://www.mediafire.com/file/oz34azkgmiv83ag/log.txt](http://www.mediafire.com/file/oz34azkgmiv83ag/log.txt)
 *  Plugin Author [Lester Chan](https://wordpress.org/support/users/gamerz/)
 * (@gamerz)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/the-problem-with-the-coding-header/#post-8459828)
 * Looks like a table issue, try googling “Illegal mix of collations (latin1_swedish_ci,
   IMPLICIT)”
 *  Thread Starter [ikiterder](https://wordpress.org/support/users/ikiterder/)
 * (@ikiterder)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/the-problem-with-the-coding-header/#post-8460030)
 * Thanks for the help. To understand the causes of the problem 🙂

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘The problem with the coding header’ is closed to new replies.

 * ![](https://ps.w.org/wp-postratings/assets/icon.svg?rev=978014)
 * [WP-PostRatings](https://wordpress.org/plugins/wp-postratings/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-postratings/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-postratings/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-postratings/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-postratings/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-postratings/reviews/)

 * 6 replies
 * 2 participants
 * Last reply from: [ikiterder](https://wordpress.org/support/users/ikiterder/)
 * Last activity: [9 years, 6 months ago](https://wordpress.org/support/topic/the-problem-with-the-coding-header/#post-8460030)
 * Status: resolved