Code:
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