db error step 8

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Candostum
    New Member
    • Sep 2009
    • 6
    • 3.8.x

    [Suite] db error step 8

    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
  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24325
    • 5.7.X

    #2
    This thread has some things you can check:

    http://www.vbulletin.com/forum/showthread.php?t=259250

    Some customers recommend this third party utility for converting a database:

    http://vcharset.com/

    Note that conversions are not always possible, and sometimes result in a few bad characters.
    Vote for:

    - Admin Settable Paid Subscription Reminder Timeframe (vB6)
    - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...