Forum Illegal mix of collations error - منتدى استراحات زايد

		منتدى استراحات زايد > استراحات اخرى > منتدى أخبار المواقع والمنتديات العربية والأجنبية
Forum Illegal mix of collations error

LinkBack

أدوات الموضوع

انواع عرض الموضوع

05-13-2010, 09:11 AM

محروم.كوم

عضو ماسي

بيانات محروم.كوم

رقم العضوية : 503

تاريخ التسجيل : Dec 2007

الجنس : female

علم الدوله : الدوله : United Arab Emirates

المشاركات : 2,100,613

عدد الـنقاط :3341

تقييم المستوى : 2139

Forum Illegal mix of collations error

Having tried to upgrade my forum from 3.8.2 to 4.0.3, I encountered an Illegal mix of collations error.

After submitting a support ticket I got an answer that set me on the right track.

Using phpMyAdmin I changed the collation value of database, tables and fields. First to latin1_danish_ci, where I was unable to change 2 fields due to error messages, and then to latin1_swedish_ci. Having changed all I could see to swedish, I was able to proceed with my install, which was stuck on upgrade400a1.php?step=9, for quite a while.

However, on finalupgrade.php?step=5 i encounter a similar error repeatedly, even though I have checked each table 3 or 4 times to se if any field still is set to danish.

This is the most recent error I get:

-----

Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT MIN(nextrun) AS nextrun
FROM tf_cron AS cron

LEFT JOIN tf_product AS product ON (cron.product = product.productid)
WHERE cron.active = 1
AND (product.productid IS NULL OR product.active = 1);

MySQL Error : Illegal mix of collations (latin1_danish_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Thursday, May 13th 2010 @ 1212 AM
Error Date : Thursday, May 13th 2010 @ 1214 AM
Script : [forum URL]/install/finalupgrade.php?step=5
Referrer : [forum URL]/install/finalupgrade.php?step=4&startat=60
IP Address : [IP address]
Username :
Classname : vB_Database_MySQLi
MySQL Version : 5.0.87-community

-----

I still can't find any fields set to latin1_danish_ci anywhere. Is there an SQL query I can use to locate such fields, if extant? __DEFINE_LIKE_SHARE__

إعلانات عشوائية

تعارف بلاك بيري	صور بلاك بيري	قروبات بلاك بيري	اخبار رياضية	العاب فلاش	اهداءات اغاني للهواتف	نغمات جوال
أغاني	مسلسلات رمضان	مسجات	سوق محروم	سيارات للبيع	ارقام سيارات للبيع	برودكاست