WordPress.org

Support

Support » How-To and Troubleshooting » Sudden database error!

Sudden database error!

  • junipingla

    @junipingla

    This morning I tried to log in to my admin panel and I got this error:

    WordPress database error: [Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘=’]
    SELECT ID FROM wp_users WHERE user_login = ‘Åse’

    I couldn’t log in so I changed my login name from Åse to admin in php my admin and I got in. However, my whole blog that uses ISO-8859-1 looked totally weird!!! All my Å,Ä and Ös were all messed up.
    I have tried reuploading my sv_SE.mo but stilled messed up. When changing to UTF-8 in wp-admin my posts turns up fine again.

    Is there a problem with my SQL and how do I fix it?
    Thank you!

  • The topic ‘Sudden database error!’ is closed to new replies.