Illegal mix of collations ... Problem

[hackrishna]

Help! Anyone ?? 

I am using SMF 2.0.2 ... While replying to a Personal Message, i noticed this now ..

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation 'ifnull'
File: /home/epicm/public_html/tech/Sources/PersonalMessage.php
Line: 1657

Anyone please help .. I had suffered many errors recently, all were solved by myself ... But this one is something m not able to understand.. I searched the SMF forum, but could't find a related query 

[Oldiesmann]

There's a minor issue with your database.

It's being generated by this part of the query:

Code Select Expand

IFNULL(mem.real_name, pm.from_name)

It means that the "real_name" column in the members table has a different collation than the "from_name" column in the personal_mesasges table.

Fortunately, it's an easy fix.

Go into phpMyAdmin and run this query:

Code Select Expand

ALTER TABLE smf_personal_messages CHANGE from_name from_name TINYTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL

[hackrishna]

omg .. omg ... can't believe .... it got solved 

Thanksss alottt