Getting error message "Illegal mix of collations"

[GTSdll]

Hi there.

I've upgraded to SMF 1.1 RC2 yesterday, and i noticed when i try to view my PM-Inbox now, i get the following errormessage:

Code Select Expand


Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_unicode_ci,IMPLICIT) for operation 'find_in_set'
File: /*************/Sources/PersonalMessage.php
Line: 380


I've checked all my tables, i have NO table that has the collation "latin1_swedish_ci". Everything in my database is set to "utf8_unicode_ci", and it worked perfectly with SMF 1.0.7.

I tried the search function, but i couldn't find a satisfying solution.

[Elmacik]

You have no table that has the collation "latin1_swedish_ci" but the columns in your tables does have.
Just enter the structure of the personal_messages and pm_recipients tables, convert swedish collations to utf8

[GTSdll]

Nope, the columns in my table are utf_unicode_ci too, i checked it of course ^^

I can prove it with screenshots, if you want

Personal Messages [nofollow]
PM Recipients [nofollow]

[Elmacik]

This is how I solved my problem. But you may find interesting informations here:
http://www.simplemachines.org/community/index.php?topic=41241.0

[GTSdll]

Thanks, Elmacik.

I solved it by setting the collations to latin1, as suggested in this thread ... i hope the final release will fix this, some of my members won't like having to talk english in PM's