Error Log Full of Redirection Errors

  • rhythmdoctor

    (@rhythmdoctor)


    13 years, 4 months ago

    Hello – I have all these errors that keep showing up in my error.log in the root of my wordpress site. The content of the errors is as follows (latest example).

    [20-Nov-2010 12:31:35] 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=’wp’ WHERE (wp_redirection_items.regex=1 OR wp_redirection_items.url=’/search/?cx=partner-pub-1806767993637739%3A587msj-9w3w&cof=FORID%3A11&ie=ISO-8859-1&q=%D1%85%D0%B8%D0%BC%D0%B5%D1%80%D0%B0&sa.x=30&sa.y=15′ OR wp_redirection_items.url=’/search/?cx=partner-pub-1806767993637739:587msj-9w3w&cof=FORID:11&ie=ISO-8859-1&q=химера&sa.x=30&sa.y=15′) ORDER BY wp_redirection_groups.position,wp_redirection_items.position made by require, require_once, require_once, require_once, do_action, call_user_func_array, WordPress_Module->init, Red_Item->get_for_url, W3_Db->query

    It looks like it may be an issue with the Google CSE that Im using for search. How can I fix this? Thanks.

Viewing 2 replies - 1 through 2 (of 2 total)
  • tommyg73

    (@tommyg73)

    13 years, 4 months ago

    It looks like you’re using different collations on your database – it actually says so on your error log.
    Go to your phpMyAdmin (or other DB editor that you have) and change the collation on the table which has “latin1_swedish_ci” to “utf8_general_ci” – or the other way around, depending on which collation the rest of your tables are in this database.
    Also check that the DB’s own collation is the same for the sake of other plugins that may need to create an addintional table on your DB.

    Thread Starter rhythmdoctor

    (@rhythmdoctor)

    13 years, 3 months ago

    Tommy. Thanks. Kinda scared to do this. The core wordpress, of course is UTF8_general, but the redirection plugin along with a few others has the latin1_swedish – which by the way, is what the redirection plugin installs as. I uninstalled and removed the databases and then reinstalled and got the same thing. Is it possible that I could just change them all to UTF8, or would that screw things up? Thanks again so much for the help. I wonder what that might be doing in terms of performance on the site?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Error Log Full of Redirection Errors’ is closed to new replies.