I am in the process of upgrading my oldish Vbulletin to the newest version and the upgrade aborted twice at the same point in the upgrade path. Its a small, unmodified plane jane forum with a few plugins that I disabled prior to upgrading as per the manual. I tried upgrading 2x but it aborts with with the same error seen below. Despite the error, the forum seems to work, I can log in, but the page formatting and styling is broken, I think some of the css or the template files aren't 100% working correctly.
Any assistance would be greatly appreciated:
Following the upgrade log, it looks like it breaks during or after step 5 of upgrading to 4.1.11.....
Any assistance would be greatly appreciated:
Code:
Invalid SQL: SELECT pd.* FROM productdependency AS pd INNER JOIN product AS p ON (p.productid = pd.productid) WHERE ###pd.productid NOT IN ('','vbulletin')### pd.productid IN ('vbblog', 'vbcms', 'skimlinks', 'vbapi') AND p.active = 1 ORDER BY pd.dependencytype, pd.parentproductid, pd.minversion; Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '=']]></error> <error_html><![CDATA[<p>Database error in vBulletin 4.1.11</p> <p>Invalid SQL: SELECT pd.* FROM productdependency AS pd INNER JOIN product AS p ON (p.productid = pd.productid) WHERE ###pd.productid NOT IN ('','vbulletin')### pd.productid IN ('vbblog', 'vbcms', 'skimlinks', 'vbapi') AND p.active = 1 ORDER BY pd.dependencytype, pd.parentproductid, pd.minversion;<p> <p> <strong>MySQL Error</strong> : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='<br /> <strong>Error Number</strong> : 1267<br /> <strong>Request Date</strong> : Monday, March 5th 2012 @ 01:25:56 AM<br /> <strong>Error Date</strong> : Monday, March 5th 2012 @ 01:25:56 AM<br /> <strong>Classname</strong> : vB_Database<br /> <strong>MySQL Version</strong> : 5.1.52<br /> </p>]]></error_html> </errors>
Code:
Step 4 - Importing vbulletin-style.xml Step 4 - Import Done Step 5 - Importing vbulletin-mobile-style.xml Step 5 - Import Done aborted
Comment