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 :(
There's a minor issue with your database.
It's being generated by this part of the query:
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:
ALTER TABLE smf_personal_messages CHANGE from_name from_name TINYTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
omg .. omg ... can't believe .... it got solved O:)
Thanksss alottt ;D ;D