Announcement

Collapse
No announcement yet.

I'm getting all kinds of MySQL Errors, please help

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

  • I'm getting all kinds of MySQL Errors, please help

    From an admin email I got:

    Database error in vBulletin 3.0.7:

    Invalid SQL:
    SELECT COUNT(*) AS threads,
    SUM(IF(lastpost>=1118237438 AND open<>10,1,0)) AS newthread
    FROM thread AS thread
    LEFT JOIN deletionlog AS deletionlog ON(thread.threadid =
    deletionlog.primaryid AND type = 'thread')
    WHERE forumid = 23
    AND sticky = 0
    AND visible = 1
    AND postuserid NOT IN (BWN?)
    AND lastpost >= 1115647311

    AND deletionlog.primaryid IS NULL

    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 lastpost >= 1115647311

    AND deletionlog.primaryid IS NULL' at line 8

    mysql error number: 1064

    Date: Wednesday 08th of June 2005 07:01:51 AM
    Script: http://www.carolinarides.com/forum/forumdisplay.php?f=23
    Referer: http://www.carolinarides.com/forum/
    Username: qcworm
    IP Address: 12.179.68.243

  • #2
    hhm, Seems like it was caused by adding username (BWN?) to the "Tachy Goes to Coventry" option.

    Removed the name, and all seems good. Whats the deal?
    Last edited by JoeyAnderson; Wed 8th Jun '05, 6:19am.

    Comment


    • #3
      As the option states you need to add a userid, which is a number and not a name, to that option

      Find that users userid (this is the number they are assigned when they are registered) and place that into the vBulletin Option and things should resume as normal

      Comment


      • #4
        Doh!

        Thanks for the help. I promise I'll be more intelligent next time.

        Comment

        Loading...
        Working...
        X