No announcement yet.


  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] hi

    greetings I have this problem and how to fix it is not someone please hand me god bless

    Database error in vBulletin 4.1.4:

    Invalid SQL:

    SELECT thread.threadid, thread.forumid, thread.title, thread.prefixid, thread.taglist, postusername, postuserid,
    thread.lastpost, thread.replycount,
    forum.title AS forumtitle
    ,post.pagetext AS preview
    , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed

    FROM vb_thread AS thread
    INNER JOIN vb_forum AS forum ON (forum.forumid = thread.forumid)
    LEFT JOIN vb_post AS post ON (post.postid = thread.firstpostid)
    LEFT JOIN vb_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)

    WHERE thread.threadid IN (26554,6640,14756,6002,5754) AND thread.visible = 1

    AND thread.postuserid NOT IN (

    ORDER BY lastpost DESC;

    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 '.118.66)

    ORDER BY lastpost DESC' at line 15
    Error Number : 1064
    Request Date : Tuesday, November 22nd 2011 @ 04:14:51 PM
    Error Date : Tuesday, November 22nd 2011 @ 04:14:51 PM
    Script :
    Referrer :
    IP Address : xxxxxxxxxxxxx
    Username : knelo1
    Classname : vB_Database
    MySQL Version : 5.0.87.d10-ourdelta

  • #2
    Check AdminCP > Settings > Options > User Banning Options > Global Ignore. That should be a userid, not an IP.

    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 <- awesome site for html/css help


    • #3
      That in itself was perfect friend and I did everything under the best thank you very much god bless you


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