|
Illegal mix of collations utf8_unicode_ci and utf8_general_ci (Upgrade from 3.8 to 4.2 error) Hi everyone.. I am upgrading my board from 3.8 to 4.2! I get the Language Coalition mysql error! I been doing the upgrade a few times befor, and I always fixed it by checking all my tables and editing the languages back to normal! Thanks to Lynne the admin helped me with a topic she made long ago, so I followed each step. The first line of the errot is looking like this: Quote: MySQL Error : Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' So basicly it tells me that there are a mixed of other languages involved right ? and i am using utf8_unicode_ci and there were 3 tables from vBadvanced which had a utf8_general_ci, and since I already had uninstalled the product, I deleted the 3 tables as well. Now there is no other tables with wrong language coalition.. Then I tried to run the upgrade again, and I got mysql error again. Right now my language is set to utf8_unicode_ci and all my tables are also set toutf8_unicode_ci, I cant see any other or different or wrong language code.. Now what am I doing wrong since everything is looking ook, but still giving me an error... I even openned each of the tables to see inside if any other tables had a wrong language code! But all of them have the same as usual. Image of Myphpadmin Frontpage 1.png Image of my tables, and all looks the same 2.png Below is the which I am talking about, I get this everytime Unexpected Text: Quote: 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 (utf8_unicode_ci,IMPLICIT) and (utf8_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 (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' Error Number : 1267 Request Date : Tuesday, October 23rd 2012 @ 09:05:44 AM Error Date : Tuesday, October 23rd 2012 @ 09:05:46 AM Script : upgrade.php Referrer : upgrade.php Classname : vB_Database MySQL Version : 5.0.92-log ]]> I cant wait to hear a solution to this, Because I used almost 3 hours uninstalling all my plugins, so hopefully I get some help fixing this once for all! Thank you very much in ADVANCE, By CM Attached Images |
| الساعة الآن 12:01 PM |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir