Announcement

Collapse
No announcement yet.

Collation Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Collation Error

    I'm getting this error on Step 9

    I'm upgrading from 3.8.3 to 4.0.3

    Step 9) Albums System Alterations
    Moving picture 1 into the Attachment System


    Database error in vBulletin 3.8.3:

    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 (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
    Error Number : 1267
    Request Date : Sunday, May 9th 2010 @ 11:22:09 PM
    Error Date : Sunday, May 9th 2010 @ 11:22:09 PM
    Script : http://www.tuscanituner.com/forums/i...0a1.php?step=9
    Referrer : http://www.tuscanituner.com/forums/i...all.php?step=2
    IP Address : 97.101.244.192
    Username :
    Classname : vB_Database
    MySQL Version : 5.1.30

  • #2
    I managed to get past all the collation errors, the vb4 installed ok, but now when i try to bring up the site, i get this error:


    Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: Marquee_Text in [path]/includes/functions.php on line 3957

    Fatal error: Call to a member function hide_errors() on a non-object in /home/j0fishe/public_html/forums/includes/class_bootstrap.php(384) : eval()'d code on line 156

    Comment


    • #3
      tried to uninstall all mods, I also had the same problem and this way it functioned

      Comment

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