[ مشكله ] : مشكلة عند الترقية للجيل الرابع واظن انها قاعدة البيانات
 

السلام عليكم

ممممممم قررت انا و شباب في الموقع انه نعمل ترقية من الجيل الثالث 3.8.7 للجيل الرابع

و كانت الفكرة انه تكون النسخة يا 4.1.3 او فوق

ف جربنا على النسخ هاي 4.1.3 و 4.1.4 و 4.1.5

و كانوا كلهم يعطونا بالترقية نفس المشكلة مع العلم اني جربت الترقية على 4 سيرفرات وكان يعطيني نفس الخطا

و هي نص الخطأ

رمز Code:
Unexpected Text:




Database Error</p>

Invalid SQL:

(SELECT 'package' AS classtype, package.packageid AS typeid, package.packageid AS packageid,
package.productid AS productid, if(package.productid = 'vbulletin', 1, product.active) AS enabled,
package.class AS class, -1 as isaggregator
FROM package AS package
LEFT JOIN product AS product
ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin'
)

UNION

(SELECT 'contenttype' AS classtype, contenttypeid AS typeid, contenttype.packageid AS packageid,
1, 1, contenttype.class AS class , contenttype.isaggregator
FROM contenttype AS contenttype
INNER JOIN package AS package ON package.packageid = contenttype.packageid
LEFT JOIN product AS product ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin' );

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '=']]>
Database error in vBulletin 3.8.7</p>

Invalid SQL:

(SELECT 'package' AS classtype, package.packageid AS typeid, package.packageid AS packageid,
package.productid AS productid, if(package.productid = 'vbulletin', 1, product.active) AS enabled,
package.class AS class, -1 as isaggregator
FROM package AS package
LEFT JOIN product AS product
ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin'
)

UNION

(SELECT 'contenttype' AS classtype, contenttypeid AS typeid, contenttype.packageid AS packageid,
1, 1, contenttype.class AS class , contenttype.isaggregator
FROM contenttype AS contenttype



INNER JOIN package AS package ON package.packageid = contenttype.packageid
LEFT JOIN product AS product ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin' );


MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='

Error Number : 1267

Request Date : Thursday, August 18th 2011 @ 06:08:41 AM

Error Date : Thursday, August 18th 2011 @ 06:08:42 AM

Script : http://rap962.com/forum/install/upgrade.php

Referrer : http://rap962.com/forum/install/upgrade.php

Classname : vB_Database

MySQL Version : 5.0.92-community



]]>

بتمنى من اخواني بمعهد ترايدنت يساعدوني لانه صراحة انا صرلي تقريبا 28 ساعة شغال على الموضوع و بضل يطلعلي نفس المشكلة