![]() |
Forum Step 8 Database Error Upgrading I have been upgrading to VB4 from VB 3.8.4 when I got to step 8 and got this error message, Code: Database error in vBulletin 3.8.4: 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_german2_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' Error Number : 1267 Request Date : Wednesday, February 17th 2010 @ 12:35:40 AM Error Date : Wednesday, February 17th 2010 @ 12:35:41 AM Script : http://www.warwickshireonline.com/fo...0a1.php?step=8 Referrer : http://www.warwickshireonline.com/fo...0a1.php?step=7 IP Address : 92.8.237.227 Username : Classname : vB_Database MySQL Version : 5.0.89-community I'm really stuck here, how do I fix it please? |
الساعة الآن 10:13 PM |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir