Illegal mix of collations. PLEASE HELP !!!

[lindakipp]

SMF Version: SMF 1.1 RC3
Hi,
have just upgraded to 1.1 RC3 and I get the below error. Cannot solve the problem. Have searched for an answer but no joy. Please HELP !

Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set'
File: .....\forum\Sources\Admin.php
Line: 134

[青山 素子]

You'll need to adjust the character set for your database tables so they are the same. You can make this change in phpMyAdmin.

[lindakipp]

Thank you for your reply. For some reason did not receive a notice about your message.

There is a problem though. I do not have php MyAdmin. I am also not that experienced with all this, therefore would not know how to do it. 

Could you please give me more information and help?

[青山 素子]

It will be rather difficult to correct this without some way of directly accessing the database. Could you check with your host about providing phpMyAdmin or a similar tool?

[lindakipp]

Thanks for responding. I have got an application called Aqua Data Studio. With this one I can see my database and the tables.

How can I check the tables to find out what is wrong with the DB?

Thanks.

[青山 素子]

Check the table properties and set the character set to all be the same. (This might break posts or other things, make a backup before taking these kinds of actions).

[maxigs]

i have the same kind of error here too after update from RC2 to RC3

Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set'
File: /var/www/smf-update/Sources/PersonalMessage.php
Line: 380

i already checked the whole database by hand all collations are set to "utf8_general_ci"

the smf was RC2 with security patch and the update did not show any errors, but still everytime going on the personal message inbox this very annoying error occurs.

i have no idea how to fix it. especially since i thought the RC3 would fix these utf8-problems in RC2

does anybody have a solution for me? i would really appreciate it. ty

[maxigs]

ok little update here

with trying and trying and trying i'm on the way to get it to work...hopefully...

at least once i got it to work so far but since then not again (after trying a lot things i cant tell for sure which one it exactly did it)

here some clues, maybe someone can put a working sollution together on it:

1. backup of everything
2. update of board (normal update from rc2 to rc3)
3. clearing collations in phpmyadmin per hand (some tables somehow get changed to latin...)
4. clear install of a rc3 board parallel to the other one (choosing utf8)
5. converting the old database to clean utf8 (http://textsnippets.com/posts/show/84 after this guide)
6. importing the now cleaned database in the new installed rc3 (replacing the rc2-rc3 intallation with the clean rc3)

somehow like this it seemed to work but absolutely no gurantee on it since i could not do it a second time (dont ask me why, its really making me crazy)

[TarantinoArchives]

i have a similar problem when i go to my messages:

Koodi [Valitse] Laajenna

Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set'
File: /var/www/web2/html/forum/Sources/PersonalMessage.php
Line: 380

but all my tables are utf8 already.. i dont get it

[TarantinoArchives]

anyone? is that a mistake in a smf script maybe? all my tables are utf-8

another thing:
i use the same database for some other things (joomla, wiki..) and those are not utf-8... might that be a problem?

[geddeth]

Tarantino, did you find a solution? I'm having the same problem after I moved SMF into my Joomla DB and converted the tables to UTF-8.

[Oldiesmann]

That particular query deals with the pm_recipients table, so double-check the collation on that table.