No announcement yet.

1267 error

  • Filter
  • Time
  • Show
Clear All
new posts

  • 1267 error

    Database error in vBulletin 3.5.5:
    Invalid SQL:
    SELECT atype.extension, atype.thumbnail, atype.newwindow, aperm.usergroupid,
    atype.height AS default_height, atype.width AS default_width, atype.size AS default_size,
    aperm.height AS custom_height, aperm.width AS custom_width, aperm.size AS custom_size,
    aperm.attachmentpermissions AS custom_permissions
    FROM attachmenttype AS atype
    LEFT JOIN attachmentpermission AS aperm USING (extension)
    WHERE enabled = 1
    ORDER BY extension;
    MySQL Error : Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_bin,IMPLICIT) for operation '='
    Error Number : 1267
    Date : Thursday, August 3rd 2006 @ 11:10:58 PM
    Script :
    Referrer :
    IP Address :
    Username :

    Im getting the error on step 11 , my stuff is
    Windows 2003 standard edition,
    phpMyAdmin 2.6.0-pl3

    MySQL 4.1.7-nt running on localhost as @localhost

    upgraging from 3.5.4 fresh install to 3.6

    I tried to change the tables to latin1_swedish_ci but some tables are InnoDB utf8_general_ci and the tables are stuck in utf8_general_ci is there any way to fix this?

  • #2
    It would really help if you were running a more recent verison of MySQL, your version is fairly old and IIRC MySQL 4.1.7 was still beta code. Try upgrading.


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