Announcement

Collapse
No announcement yet.

SQL errors -- can't decipher this error message

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

  • sqzdog
    started a topic [Forum] SQL errors -- can't decipher this error message

    SQL errors -- can't decipher this error message

    I had a bunch of these error messages emailed to me overnight from my host. I can't decipher them..

    Code:
    Subject: vBulletin Database Error!
    
    Database error in vBulletin 4.0.2:
    
    Invalid SQL:
    
                            SELECT thread.threadid, thread.title,
    thread.lastpost, thread.forumid, thread.replycount, thread.postusername,
    thread.postuserid, thread.lastposter, thread.lastposterid,
    thread.dateline, thread.views, thread.visible, thread.open,
    user.usergroupid, user.displaygroupid
                            FROM vbthread AS thread
                            LEFT JOIN vbuser AS user ON (user.userid =
    thread.lastposterid)
                            WHERE NOT ISNULL(thread.threadid) AND
    thread.visible = '1' AND thread.open!='10'  AND thread.forumid NOT
    IN(34,33,51,52,59,24,47,48,49,50,8,35,11,12,13,14,15,58,37,38,60,)
                            ORDER BY lastpost DESC
                            LIMIT 0, 15;
    
    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 ')
                            ORDER BY lastpost DESC
                            LIMIT 0, 15' at line 4
    Error Number  : 1064
    Request Date  : Thursday, February 25th 2010 @ 05:09:36 AM
    Error Date    : Thursday, February 25th 2010 @ 05:09:37 AM
    Script        :
    http://www.mysite.com/support/forums/forumdisplay.php?f=40
    Referrer      :
    IP Address    : 
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version :

Related Topics

Collapse

  • aristor
    Database Errors
    by aristor
    What causes this error?

    Code:
    [FONT=-moz-fixed][SIZE=14px] Database error in vBulletin 5.1.0:  
    Invalid SQL: SELECT DISTINCT node.nodeid, node.contenttypeid FROM vb5_node AS starter INNER JOIN vb5_node AS node[/][/]
    ...
    Sat 26 Apr '14, 10:24pm
Working...
X