Announcement

Collapse
No announcement yet.

data base errors

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

  • 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


  • #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


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

      Comment


      • #4
        Originally posted by Colin F View Post
        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


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

          Please don't contact me per PM.

          Comment


          • #6
            Originally posted by Colin F View Post
            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

            Loading...
            Working...
            X