Announcement

Collapse
No announcement yet.

1267 error

Collapse
X
 
  • 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 : http://www.e.com/forum/install/upgra...b1.php?step=11
    Referrer : http://www.e.com/forum/install/upgra...b1.php?step=10
    IP Address : 67.3.3.133
    Username :
    on http://www.e.com/forum/install/upgra...b1.php?step=11

    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.

    Comment

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