I use vb 3.8.4 patch level 1 and I want upgrade vb4 but step 8 db error
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_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' Error Number : 1267 Request Date : Tuesday, December 22nd 2009 @ 09:27:45 PM Error Date : Tuesday, December 22nd 2009 @ 09:27:45 PM Script : [URL]http://www.forumsancak.com/install/upgrade_400a1.php?step=8[/URL] Referrer : [URL]http://www.forumsancak.com/install/upgrade_400a1.php?step=7[/URL] IP Address : Username : Classname : vB_Database MySQL Version : 5.0.87-community
Comment