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_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Sunday, February 22nd 2009 @ 08:39:14 AM
Error Date : Sunday, February 22nd 2009 @ 08:39:15 AM
****** : http://www.......com/vb/install/upgr...0a2.php?step=5
Referrer : http://www.......com/vb/install/upgr...0a2.php?step=4
IP Address : 00.000.000.00
User**** :
Class**** : vB_Data****
MySQL Version : 5.0.67-community-log

ثم الذهاب الى
phpmyadmin
واختيار قاعدة البيانات المطلوبه
ومن ثم الذهاب الى الجدول prefixpermission
ومنه اختيار التعديل على prefix
ومن ثم تعديل اللغه المعروضه من latin1_swedish_ci,IMPLICIT
الى latin1_general_ci,IMPLICIT