SQL Error: 1267 - Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_persian_ci,IMPLICIT) for operation '='

Question

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:

1267 - Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_persian_ci,IMPLICIT) for operation '='

Query:

SELECT t.*
    ,t.subject AS threadsubject
    ,u.username
    ,u.usergroup
    ,u.displaygroup
    ,i.*
    ,i.NAME AS iconname
    ,t.dateline AS threaddate
    ,t.lastpost AS threadlastpost
FROM mybb_threads t
LEFT JOIN mybb_icons i ON (i.iid = t.icon)
LEFT JOIN mybb_users u ON (t.lastposter = u.username)
WHERE t.visible = '1'
    AND t.uid = '54445'
GROUP BY t.tid
ORDER BY threadlastpost DESC LIMIT 5

Please contact the MyBB Group for technical support.

image1

image 2

Possible duplicate of [Illegal mix of collations MySQL Error](http://stackoverflow.com/questions/1008287/illegal-mix-of-collations-mysql-error) — Evert, Dec 04 '16 at 06:58
Typically the result of poorly designed tables. Are t.lastposter and u.username defined to have the same collation? — jarlh, Dec 04 '16 at 08:20
Try my solution. maybe it will work for you. https://stackoverflow.com/questions/11770074/illegal-mix-of-collations-utf8-unicode-ci-implicit-and-utf8-general-ci-implic/71659466#71659466 — pankaj, Mar 29 '22 at 10:06

score 0 · Answer 1 · edited May 23 '17 at 11:45

0

Check solution of Ross Smith II. He wrote about defining collation in sql statement.

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

edited May 23 '17 at 11:45

Community

1
1

answered Dec 04 '16 at 06:56

Lemjur

338
3
11

Please provide more detailed guidance – abbas Jul 15 '17 at 03:40

SQL Error: 1267 - Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_persian_ci,IMPLICIT) for operation '='

1 Answers1