Support » Installing WordPress » upgrading to 2.9, Database, Illegal mix of collations

  • Hello All,

    I have done an upgrade to 2.9 (from 2.8.4 or 2.8.6, can’t remember).

    I know get errors

    WordPress database error: [Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘=’]
    SELECT aiwp_redirection_items.*,aiwp_redirection_groups.tracking, AS module_id FROM aiwp_redirection_items INNER JOIN aiwp_redirection_groups ON AND aiwp_redirection_groups.status=’enabled’ INNER JOIN aiwp_redirection_modules ON AND aiwp_redirection_modules.type=’wp’ WHERE (aiwp_redirection_items.regex=1 OR aiwp_redirection_items.url=’/five-elements-japanese-philosophy-godai-%e4%ba%94%e5%a4%a7/’ OR aiwp_redirection_items.url=’/five-elements-japanese-philosophy-godai-五大/’) ORDER BY aiwp_redirection_groups.position,aiwp_redirection_items.position

    Which looks like it is caused because I have Japanese characters in the address.

    sample post:五大/

    Did 2.9 Mess up with the DB? All was fine before the upgrade, including Japanese characters.

    What is the fix? 😉

    Please help! Many thanks!


Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘upgrading to 2.9, Database, Illegal mix of collations’ is closed to new replies.