vBulletin 2.3.0 mysql error number: 1064

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • GULFBOY
    Member
    • Oct 2002
    • 41
    • 3.0.0 Gamma

    vBulletin 2.3.0 mysql error number: 1064

    HOW I CAN FXIT PLZ
    www.gulfnet.ws/vb

    Database error in vBulletin 2.3.0:

    Invalid SQL: SELECT SUM(views) AS personalviews FROM thread WHERE postuserid= AND open!='10'
    mysql error: You have an error in your SQL syntax near 'AND open!='10'' at line 1

    mysql error number: 1064

    Date: Friday 11th of April 2003 08:41:40 AM
    Script: http://www.gulfnet.ws/vb/~gulfnet/vb/showthread.php?threadid=1973
    Referer: http://www.gulfnet.ws/~gulfnet/vb/forumdisplay.php?daysprune=1000&forumid=11
    Last edited by GULFBOY; Fri 11 Apr '03, 5:00am.
  • Cary
    Senior Member
    • Apr 2002
    • 4433
    • 3.6.x

    #2
    Reupload your original showthread.php file overwriting the one you currently have on your server. Also, make sure to upload in ASCII Transfer Mode.

    Comment

    • GULFBOY
      Member
      • Oct 2002
      • 41
      • 3.0.0 Gamma

      #3
      thinkes
      for you q help

      Comment

      • GULFBOY
        Member
        • Oct 2002
        • 41
        • 3.0.0 Gamma

        #4
        stil have the Message problem plz help

        Comment

        • Wayne Luke
          vBulletin Technical Support Lead
          • Aug 2000
          • 74161

          #5
          That query is not part of vBulletin 2.3.0's showthread.php. It has to be from a hack that you were installing. As such, you can re-upload the original file that you download from the Member's Area and remove the hack. We cannot provide support for third party code modifications such as hacks.
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API

          Comment

          • GULFBOY
            Member
            • Oct 2002
            • 41
            • 3.0.0 Gamma

            #6
            stil have the Message problem plz help

            Comment

            • Steve Machol
              Former Customer Support Manager
              • Jul 2000
              • 154488

              #7
              As Wayne said, that error is from a hack you've installed. You need to reupload the original vB files and remove your hacks. Otherwise ask for help on the appropriate hack thread at vbulletin.org.
              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

              • GULFBOY
                Member
                • Oct 2002
                • 41
                • 3.0.0 Gamma

                #8
                ok i well see

                Comment

                • GULFBOY
                  Member
                  • Oct 2002
                  • 41
                  • 3.0.0 Gamma

                  #9
                  ok how uninstalled that hack ??
                  plz

                  Comment

                  • Brian Briscoe

                    #10
                    You need to re-upload all your original vBulletin files like Steve Machol said:
                    Originally posted by Steve Machol
                    As Wayne said, that error is from a hack you've installed. You need to reupload the original vB files and remove your hacks. Otherwise ask for help on the appropriate hack thread at vbulletin.org.

                    Comment

                    • Brian Briscoe

                      #11
                      Also, if you made any database changes you will need to revert those also. For further help on this problem revert back to threads on vBulletin.org from which these hacks came from.

                      Comment

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