بسم الله ارحمن الرحيم
مشكلة واجهتني عند الترقية الى النسخة الاخيرة في الخطوة الخامسة
علما ان نسختي هي vb3.7.4
وتم حذف جميع الاستايلات والهاكات
Database error in vBulletin 3.7.4:
Invalid SQL:
SELECT prefix.*, prefixpermission.usergrou pid 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,IMPLIC IT) and (latin1_general_ci,IMPLIC IT) for operation '='
Error Number : 1267
Request Date : Monday, January 26th 2009 @ 06:29:04 PM
Error Date : Monday, January 26th 2009 @ 06:29:04 PM
Script : http://www.xxxx/xx/install/upgrade_380a2.php?step=5
Referrer : http://www.xxxx/xx/install/upgrade_380a2.php?step=4
IP Address : 84.23.102.202
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community
وتم تغيير ترميز جداول ال prefix
وتمت الترقية بسلام
فواجهتنا مشكله وهي عند اضافة موضوع جديد
وهذا مضمون الخطاء
تطلع الرسالة الاتية
Database error in vBulletin 3.8.0:
Invalid SQL:
SELECT prefix.*, prefixpermission.usergroupid AS restriction
FROM forumprefixset AS forumprefixset
INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid)
INNER JOIN prefix AS prefix ON (prefix.prefixsetid = prefixset.prefixsetid)
LEFT JOIN prefixpermission AS prefixpermission ON (prefix.prefixid = prefixpermission.prefixid)
WHERE forumprefixset.forumid = 23
ORDER BY prefixset.displayorder, prefix.displayorder;
MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Wednesday, January 28th 2009 @ 04:27:35 PM
Error Date : Wednesday, January 28th 2009 @ 04:27:35 PM
Script : http://www.vb.ebda4supp.com/newthrea...newthread&f=23
Referrer : http://www.vb.ebda4supp.com/index.php
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community
نرجو الحل