Announcement

Collapse
No announcement yet.

Database Error collations?

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

  • Steve Machol
    replied
    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.

    Leave a comment:


  • lbravo
    started a topic Database Error collations?

    Database Error collations?

    Hello,
    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
    AND
    (
    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 : http://www.newtek.com/forums/admincp/user.php?do=update
    Referrer : http://www.newtek.com/forums/admincp...o=edit&u=77438
    IP Address : 207.71.33.174
    Username : admin
    Classname : vb_database
    ---------------------

    Thanks for any help you can provide.

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