The Support Forums will be in read-only mode for a scheduled maintenance window on 01 September 2016 14:00 UTC - 20:00 UTC. More information.

Sudden database error! (1 post)

  1. junipingla
    Posted 8 years ago #

    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!

Topic Closed

This topic has been closed to new replies.

About this Topic