illegal mix of collations

  • Resolved Blamedutchie

    (@blamedutchie)


    8 years, 4 months ago

    In Apache′s error log:

    mod_fcgid: stderr: WordPress database error Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation ‘=’ for query SELECT * FROM wp_pqjj_ewwwio_images WHERE path = ‘/path/to/image/wp-content/uploads/2016/10/xxx\xcc\x83o_01-1170×300.jpg’ made by do_action(‘wp_ajax_bulk_loop’), call_user_func_array, ewww_image_optimizer_bulk_loop, ewww_image_optimizer_resize_from_meta_data, ewww_image_optimizer_find_already_optimized, referer: https://blamedutchie.photography/wp-admin/upload.php?page=ewww-image-optimizer-bulk

    how to fix?

Viewing 1 replies (of 1 total)
  • Plugin Author nosilver4u

    (@nosilver4u)

    Never seen that before, but it seems there is a mismatch somewhere between the ewwwio_images collation and the WP database collation, or possibly something with the ‘path’ column collation.
    Using something like phpmyadmin, check to see what all of those three are set to for collation and/or character sets.

Viewing 1 replies (of 1 total)
  • The topic ‘illegal mix of collations’ is closed to new replies.