No announcement yet.

vBulletin Database Error!

  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] vBulletin Database Error!

    i need help

    Database error in vBulletin 4.0.3:

    Invalid SQL:

    SELECT COUNT(*) AS posts, post.threadid, post.dateline, thread.forumid
    FROM post as post
    LEFT JOIN thread AS thread ON (thread.threadid = post.threadid)
    WHERE post.visible = '1' AND thread.forumid NOT IN(138,141,150,142,) AND post.dateline >= 1271317377
    GROUP BY post.threadid;

    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 ') AND post.dateline >= 1271317377
    GROUP BY post.threadid' at line 4

  • #2
    Try disabling your modifications/plugins and see if you still have this problem.
    Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

    PHP Code:

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools &lt;- awesome site for html/css help


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