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.