Database error in vBulletin 3.0.6

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lazorde
    Member
    • Jul 2003
    • 48

    Database error in vBulletin 3.0.6

    hi ihave error in Database


    Code:
    Database error in vBulletin 3.0.6:
    
    Invalid SQL: 
                            SELECT  filename,filedata, filesize, visible, attachmentid, counter, postid, IF(thumbnail = '', 0, 1) AS hasthumbnail, LENGTH(thumbnail) AS thumbnailsize
                            SELECT filename, filesize, visible, attachmentid, counter, postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize
                            FROM attachment
                            WHERE postid IN (-1,20809,20841,20843,20844,20846,20851,20857,20888,20900,20924,20980,21066)
                            ORDER BY dateline
                    
    mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT filename, filesize, visible, attachmentid, counter, post
    
    mysql error number: 1064
    
    Date: Tuesday 25th of January 2005 07:27:28 PM
    Script: http://www.lazorde.com/vb/showthread.php?t=4267
    Referer: http://www.lazorde.com/vb/forumdisplay.php?f=8&page=3&sort=lastpost&order=&pp=50&daysprune=-1
    Username: lazorde
    IP Address: 82.167.0.21
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    The first thing I recommend is that you reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    😀
    😂
    🥰
    😘
    🤢
    😎
    😞
    😡
    👍
    👎