Announcement

Collapse
No announcement yet.

Sql Error

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

  • Sql Error

    I am not very good with databases. I dont even know what this means. I was hoping someone could fill me in on a fix.

    I get this error message emailed to me at least once a day

    Invalid SQL:
    UPDATE subscribethread AS subscribethread
    SET emailupdate = 0
    WHERE subscribethreadid IN (0,7,3,2,6,5,4,1) AND
    userid = 25

    mysql error: You have an error in your SQL syntax near 'AS subscribethread
    SET emailupdate = 0
    WHERE subscribethreadid IN (0,7' at line 2

    mysql error number: 1064

  • #2
    What version are you running? What is the complete error message, including script info?
    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


    • #3
      Database error in vBulletin 3.0.0 Gamma:

      Invalid SQL:
      UPDATE subscribethread AS subscribethread
      SET emailupdate = 0
      WHERE subscribethreadid IN (0,7,3,2,6,5,4,1) AND
      userid = 25

      mysql error: You have an error in your SQL syntax near 'AS subscribethread
      SET emailupdate = 0
      WHERE subscribethreadid IN (0,7' at line 2

      mysql error number: 1064

      Date: Tuesday 23rd of December 2003 05:41:15 PM
      Script: http://hereyah.com/bb/subscription.php
      Referer: http://hereyah.com/bb/subscription.php?do=viewsubscription
      Username: standalone
      IP Address: 167.127.107.11

      Comment


      • #4
        It's in the Bug Tracker:

        http://www.vbulletin.com/forum/bugs....iew&bugid=1400
        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

        Loading...
        Working...
        X