Announcement

Collapse
No announcement yet.

Please Help

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

  • lbravo
    replied
    Resolved.

    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.

    Leave a comment:


  • lbravo
    started a topic Please Help

    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 : http://www.newtek.com/forums/showthread.php?t=81911
    Referrer : http://www.newtek.com/forums/forumdisplay.php?f=207
    IP Address : 207.71.33.174
    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X