Suite Database error
 

Please i need help for this error , it kill me because i changed all table collations from latin1_general_ci to latin1_swedish_ci and still get this error

Database error in vBulletin 3. 7.6:

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_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Saturday, February 13th 2010 @ 10:46:06 AM
Error Date : Saturday, February 13th 2010 @ 10:46:06 AM