“Illegal mix of collations” errors during install

  • twidget

    (@twidget)


    19 years, 8 months ago

    My host is using MySQL v4.1.7-standard, and when I install WordPress I get a number of “Illegal mix of collations” errors. Is that WordPress’ fault, or is http://bugs.mysql.com/bug.php?id=3611 to blame?

    The errors I see are:

    WordPress database error: [Illegal mix of collations (utf8_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), (latin1_swedish_ci,COERCIBLE) for operation ‘replace’]
    UPDATE cs_options SET option_value = REPLACE(option_value, ‘wp-links/links-images/’, ‘wp-images/links/’) WHERE option_name LIKE ‘links_rating_image%’ AND option_value LIKE ‘wp-links/links-images/%’

    WordPress database error: [Illegal mix of collations (utf8_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), (latin1_swedish_ci,COERCIBLE) for operation ‘replace’]
    UPDATE cs_comments SET comment_type=’trackback’, comment_content = REPLACE(comment_content, ”, ”) WHERE comment_content LIKE ‘%’

    WordPress database error: [Illegal mix of collations (utf8_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), (latin1_swedish_ci,COERCIBLE) for operation ‘replace’]
    UPDATE cs_comments SET comment_type=’pingback’, comment_content = REPLACE(comment_content, ”, ”) WHERE comment_content LIKE ‘%’

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter twidget

    (@twidget)

    19 years, 8 months ago

    In 1.2.2 (“Mingus”) I only get the following error:

    Database error: [Illegal mix of collations (utf8_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), (latin1_swedish_ci,COERCIBLE) for operation ‘replace’]
    UPDATE cs_options SET option_value = REPLACE(option_value, ‘wp-links/links-images/’, ‘wp-images/links/’) WHERE option_name LIKE ‘links_rating_image%’ AND option_value LIKE ‘wp-links/links-images/%’

    mattesonweb

    (@mattesonweb)

    19 years, 7 months ago

    ILLEGAL COLLATION FIX

    I was getting the same “Illegal Mix…” errors during my install as well (I am running Windows XP SP1, Apache 2.0, PHP 4.3.x, MySQL 4.1.3b, phpMyAdmin 2.6.0-pl2).

    When I created the database in phpMyAdmin, I assumed I would need to set the Collation to “utf8-general”. However, this is exactly why I got the error.

    Here is how I fixed my install issue with the “Illegal Mix” errors:

    I dropped the “wordpress” database I setup and re-created it with the default Collation (latin1-swedish-ci) then re-ran the setup.

    Everything worked fine after that. Hopefully this helps!

    -mattesonweb

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘“Illegal mix of collations” errors during install’ is closed to new replies.