data base errors

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • deano
    Member
    • Jan 2002
    • 40

    data base errors

    hello
    i keep getting this error
    don't know what it means
    ----------------------------------------------

    Database error in vBulletin 3.6.1:

    Invalid SQL:

    SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, thread.iconid, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
    FROM thread AS thread LEFT JOIN user AS user ON (user.username = thread.lastposter) WHERE NOT ISNULL(thread.threadid) AND thread.visible!=0 AND thread.forumid NOT IN (0,)
    ORDER BY views DESC LIMIT 0, 3;

    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 ')
    ORDER BY views DESC LIMIT 0, 3' at line 2
    Error Number : 1064
    Date : Wednesday, October 4th 2006 @ 12:46:00 AM
    Script : http://www.deanosworld.net/vb/newthread.php?do=newthread&f=36
    Referrer :
    IP Address : 72.30.177.124
    Username : Unregistered
    Classname : vb_database

  • Colin F
    Senior Member
    • May 2004
    • 17689

    #2
    First I recommend reuploading all the default vBulletin non-image files in ASCII mode, overwriting your current files. Also, turn off plugins globally in your vBulletin Options. Does this problem still occur then?
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment

    • deano
      Member
      • Jan 2002
      • 40

      #3
      i just upgraded to 3.6.2
      i'll see if that fixes it
      and post results here

      Comment

      • deano
        Member
        • Jan 2002
        • 40

        #4
        Originally posted by Colin F
        First I recommend reuploading all the default vBulletin non-image files in ASCII mode, overwriting your current files. Also, turn off plugins globally in your vBulletin Options. Does this problem still occur then?
        it happend again
        on the 3.6.2 VB

        i would have over writen everything in the upload of the new VB files
        turning off plugin will kill my plugins

        a friend of mine has the same plugins with the same version of VB
        he does not have this problem

        could anything else cause this ?

        Comment

        • Colin F
          Senior Member
          • May 2004
          • 17689

          #5
          Still, please disable the plugins.
          Best Regards
          Colin Frei

          Please don't contact me per PM.

          Comment

          • deano
            Member
            • Jan 2002
            • 40

            #6
            Originally posted by Colin F
            Still, please disable the plugins.
            i reinstalled the top ten stats hack
            with the latest version
            that was 2 days ago
            has not happend yet, still waiting
            if it happens again i'll disable plugins
            and let you know what happens after that

            Thanks

            Comment

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