No announcement yet.

Database Error collations?

  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Error collations?

    Since upgrading from 3.5.3, I am receiving the following database error when I try to move members from one group to another:

    Database error in vBulletin 3.6.8:

    Invalid SQL:

    SELECT COUNT(*) AS users
    FROM user
    WHERE userid <> 77438
    usergroupid IN(6,5)
    OR FIND_IN_SET('6', membergroupids)
    OR FIND_IN_SET('5', membergroupids)

    MySQL Error : Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'find_in_set'
    Error Number : 1267
    Date : Monday, April 7th 2008 @ 10:59:34 AM
    Script :
    Referrer :
    IP Address :
    Username : admin
    Classname : vb_database

    Thanks for any help you can provide.


  • #2
    Here are the possible causes of the 'Illegal mix of collations' error and the ways to fix this:

    1. The db is set to use one collation type and the tables are set to another. You need to change these to match one another. You can do this in phpMyAdmin.

    2. The table collations do not match. They need to all be the same type and match the db collation. This too you can fix in phpMyAdmin.

    3. The table collation does not match the collation of the individual fields in that table. You need to change these fields to match the table.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


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