Announcement

Collapse
No announcement yet.

Getting this database Error...

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

  • Getting this database Error...

    In my adminCP:
    --------------

    Database error in vBulletin 3.6.4:
    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
    Last edited by Rolodex; Tue 5th Dec '06, 7:03pm.
    Is it true that "Cannibals" don't eat Clowns because they taste funny? :eek:

  • #2
    You need to make sure all your tables use the same collation, you seem to have two that are different.
    Baby, I was born this way

    Comment


    • #3
      Originally posted by Paul M View Post
      You need to make sure all your tables use the same collation, you seem to have two that are different.
      Thanks for responding Paul, I went into phpMyAdmin and changed the contents of one table latin-general c1 to latin-sweedish c1 and the error went away!
      Is it true that "Cannibals" don't eat Clowns because they taste funny? :eek:

      Comment

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