Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_german2_ci,IMPLICI

[cuphongle]

Invalid SQL:

SELECT prefix.*, prefixpermission.usergroupid AS restriction
FROM prefix AS prefix
LEFT JOIN prefixpermission AS prefixpermission ON (prefix.prefixid = prefixpermission.prefixid)
ORDER BY prefix.displayorder;

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_german2_ci,IMPLICIT) for operation '='

So i got that, and i tried to change 1 by 1 to all latin1, german2

and its still not working.

can you guys please help

thanks

[snakes1100]

I would guess you have columns in the same table with mis-matched collation settings.

Use phpmyadmin and check your column collation settings, i would tell you what table, but you failed to post the entire error msg.