No announcement yet.

DB error

  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] DB error

    I have been getting this error for over a month now:

    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,, 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!='10' AND thread.forumid NOT IN(90,)
    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
    I can't seem to find the cause. Any ideas?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.