New Posts come up as Database Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Arshes Nei
    New Member
    • Mar 2003
    • 22

    New Posts come up as Database Error

    Database error in vBulletin 3.0.7:

    Invalid SQL:
    SELECT threadid AS itemid, forumid,
    IF(postuserid = 2, 'self', 'other') AS starter
    FROM thread AS thread
    LEFT JOIN deletionlog AS delthread ON(delthread.primaryid = thread.threadid AND delthread.type = 'thread')
    WHERE threadid IN(9409, 9411)
    AND delthread.primaryid IS NULL
    AND thread.open <> 10
    AND thread.visible = 1
    AND thread.postuserid NOT IN (69.76.58.184)

    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 '.58.184)' at line 9

    mysql error number: 1064



    This is the error I'm receiving when a user tries to click on new posts.
  • 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

    • Arshes Nei
      New Member
      • Mar 2003
      • 22

      #3
      I had done so, but I will do it again.

      Comment

      • Arshes Nei
        New Member
        • Mar 2003
        • 22

        #4
        I figured out the problem. Apparently someone put an ID address instead of Username in Tachy Goes to Coventry Option. Is this loophole being fixed for future versions of VB?

        Comment

        • Zachery
          Former vBulletin Support
          • Jul 2002
          • 59097

          #5
          No, someone put an IP address, into the tatchy goes to converntry option instead of a USERID.

          It is clearly stated which sort of data you should be putting into that field.,

          Comment

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