Illegal Mix of Collations Errors

  • This error is showing up in my logs:

    WordPress database error Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘=’ for query SELECT wp_redirection_items.*,wp_redirection_groups.tracking,wp_redirection_modules.id AS module_id FROM wp_redirection_items INNER JOIN wp_redirection_groups ON wp_redirection_groups.id=wp_redirection_items.group_id AND wp_redirection_groups.status=’enabled’ INNER JOIN wp_redirection_modules ON wp_redirection_modules.id=wp_redirection_groups.module_id AND wp_redirection_modules.type=’404′ WHERE (wp_redirection_items.regex=1 OR wp_redirection_items.url=’/1%E2%AC%A62%E2%AC%A63%E2%AC%A6o4p-for-victory-grrrrrrrrrr/’ OR wp_redirection_items.url=’/1a?|2a?|3a?|o4p-for-victory-grrrrrrrrrr/’) ORDER BY wp_redirection_groups.position,wp_redirection_items.position made by require, require_once, do_action, call_user_func_array, Error404_Module->template_redirect, Red_Item->get_for_url

    Do I need to go into PHP MyAdmin manually and set every database to UTF-8? If that is the prescribed course of action, is there anything else I should look for? Thanks much.

Viewing 1 replies (of 1 total)
  • Thread Starter devitor

    (@devitor)

    I answered my own question here and it is an unqualified yes. Apparently, when my database was migrated from one provider to the other months ago, some of the tables switched from URTF-8 to Latin Swedish. I did manually go in to PHP MyAdmin, and changed the structure of each of the affected tables back to UTF-8. You also need to change the query (under operations) to UTF-8, or the change will not reflect.

    Having done this the illegal collation error ceased appearing in my error logs. Additionally another error I posted about also ceased, which means the illegal collation was the root cause.

    All database tables and queries upon them should be consistent – and in most cases should be UTF-8.

    This question may be closed and marked as solved.

Viewing 1 replies (of 1 total)
  • The topic ‘Illegal Mix of Collations Errors’ is closed to new replies.