No announcement yet.

Please Help

  • Filter
  • Time
  • Show
Clear All
new posts

  • Please Help

    I have read all the threads and submitted a support ticket with no solution for this problem. This is the error:

    Database error in vBulletin 3.6.8:

    Invalid SQL:

    SELECT dateline, thumbnail_dateline, filename, filesize, visible, attachmentid, counter,
    postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize,
    attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
    FROM attachment
    LEFT JOIN attachmenttype AS attachmenttype USING (extension)
    WHERE postid IN (-1,676105,676145,681300,683130,683500,683510)
    ORDER BY attachmentid;

    MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_bin,IMPLICIT) for operation '='
    Error Number : 1267
    Date : Tuesday, April 8th 2008 @ 09:41:30 AM
    Script :
    Referrer :
    IP Address :
    Username : admin
    Classname : vb_database


    This should indicate a problem with collations in the attachment table, however, when I try to correct this problem per suggestions, it doesn't exist! See attached screen shot. Can someone PLEASE give me a clue?

    Thanks a bunch!
    Attached Files

  • #2

    For anyone else with this weird problem:

    In the config.php file, I had uncommented the line about UTF-8 encoding. Don't do that!

    I commented it back, ran install.php again, and everything returned.


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