No announcement yet.

Upgrade from 3.0.1 to 3.8.1 problem

  • Filter
  • Time
  • Show
Clear All
new posts

  • Colin F
    You most likely changed the default collation of your database at one point, so you now have multiple collations, namely latin1_swedish_ci and latin1_general_ci.

    You can set the collation in phpMyAdmin, but you'll need to do this for the database (in the Operations tab), each table (in the Operations tab of that table), and each field that uses text (by editing the field).

    If you look at the database in phpMyAdmin you'll see the collations listed on the overview, in it's own column. Most likely one collation will be fairly dominant, and hopefully you'll only have a few tables with a different collation.

    You'll then want to set the databases default collation to your dominant collation, and edit all the tables as well as the rows in those tables which are using the less-used collation to use the dominant one.

    It may take a bit to go through the tables, but once everything is using the same collation you shouldn't receive this error anymore.

    Leave a comment:

  • Ohiosweetheart
    started a topic Upgrade from 3.0.1 to 3.8.1 problem

    Upgrade from 3.0.1 to 3.8.1 problem

    I just did an upgrade from 3.0.1 to 3.8.1 and got this database error after logging back in to the admin CP -

    Database error in vBulletin 3.8.1:
    Invalid SQL:
        SELECT adminmessage.adminmessageid
        FROM adminmessage AS adminmessage
        INNER JOIN adminlog AS adminlog ON (adminlog.script = adminmessage.script AND adminlog.action = adminmessage.action)
        WHERE adminmessage.status = 'undone'
            AND adminmessage.script <> ''
            AND adminlog.dateline > adminmessage.dateline
        GROUP BY adminmessage.adminmessageid;
    MySQL Error   : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
    Error Number  : 1267
    Request Date  : Tuesday, February 24th 2009 @ 08:15:48 AM
    Error Date    : Tuesday, February 24th 2009 @ 08:15:48 AM
    Script        : http://****************************/index.php?do=home
    Referrer      : http://*******************************/index.php
    IP Address    : **.***.***.**
    Username      : *****
    Classname     : vb_database
    MySQL Version : 5.0.19-log
    I have no idea what this means. help please?

Related Topics