Dear Support and vBulletin..
I wasupgrading my board from 3.8 to 4.2! I been doing the upgrade a few times befor, and a few times i got the Illegal mix of coalition error, which I always fixed it by checking all my tables and editing my language coalition one by one..
But this time its giving another error, befor It used to be Illegal mix of collations (utf8_swedish_ci,IMPLICIT) and
(utf8_general_ci,IMPLICIT) ... But now it saying something different! All tho I did fix the tables, but getting the same error again..
Below is how the first line of the error looks:
I fixed all the tables with wrong coaltion one by one, and still 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 also found online I found out that it can happen that even that the coalition is the same, The error will still appear because another type of convesation may have been used by my own server... I have attached a few images to show all my tables and database is the same... Still I get the error.. Can some tell me a fix to thise
Image of Myphpadmin Frontpage
Image of my tables, and all looks the same
Below is the which I am talking about, I get this everytime
Unexpected Text:
Hopefully I get some help fixing this once for all! - Thank you very much in ADVANCE, By CM
I wasupgrading my board from 3.8 to 4.2! I been doing the upgrade a few times befor, and a few times i got the Illegal mix of coalition error, which I always fixed it by checking all my tables and editing my language coalition one by one..
But this time its giving another error, befor It used to be Illegal mix of collations (utf8_swedish_ci,IMPLICIT) and
(utf8_general_ci,IMPLICIT) ... But now it saying something different! All tho I did fix the tables, but getting the same error again..
Below is how the first line of the error looks:
<strong>MySQL Error</strong> : Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='<br />
I also found online I found out that it can happen that even that the coalition is the same, The error will still appear because another type of convesation may have been used by my own server... I have attached a few images to show all my tables and database is the same... Still I get the error.. Can some tell me a fix to thise
Image of Myphpadmin Frontpage
Image of my tables, and all looks the same
Below is the which I am talking about, I get this everytime
Unexpected Text:
Code:
<?xml version="1.0" encoding="windows-1252"?> <?xml version="1.0" encoding="windows-1252"?> <errors> <error><=!=[=C=D=A=T=A=[<p>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 '=']=]=></error> <error_html><=!=[=C=D=A=T=A=[<p>Database error in vBulletin 3.8.7</p> <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' );<p> <p> <strong>MySQL Error</strong> : Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='<br /> <strong>Error Number</strong> : 1267<br /> <strong>Request Date</strong> : Tuesday, October 23rd 2012 @ 09:05:44 AM<br /> <strong>Error Date</strong> : Tuesday, October 23rd 2012 @ 09:05:46 AM<br /> <strong>Script</strong> : install/upgrade.php<br /> <strong>Referrer</strong> : install/upgrade.php<br /> <strong>Classname</strong> : vB_Database<br /> <strong>MySQL Version</strong> : 5.0.92-log<br /> </p>]=]=></error_html> </errors>
Comment