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:
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.
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
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 (http://pics.gts-stuff.com/data/media/1/smf_personal_messages.png)
PM Recipients (http://pics.gts-stuff.com/data/media/1/smf_pm_recipients.png)
This is how I solved my problem. But you may find interesting informations here:
http://www.simplemachines.org/community/index.php?topic=41241.0
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 ;)