Announcement

Collapse
No announcement yet.

how do i fix this (user table)

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

  • how do i fix this (user table)

    Database error in vBulletin Control Panel 2.2.6:

    Invalid SQL: SELECT COUNT(*) AS users FROM user,usergroup WHERE user.usergroupid=usergroup.usergroupid AND usergroup.cancontrolpanel=1 AND user.userid<>
    mysql error: You have an error in your SQL syntax near '' at line 1

    mysql error number: 1064

    Date: Tuesday 25th of June 2002 03:48:03 PM
    Script: http://www.newcelica.org/forums/forums/admin/user.php
    Referer: http://www.newcelica.org/forums/admi...it&userid=9394

    Im sure that that I have to do something through phpmyadmin but I dont know what that is, where to get it or how to use it.. can anyone help me out here?? Im having alot of issues that all seem to be based on the user table..
    Larry D
    www.newcelica.org

  • #2
    Can you upload a file called phpinfo.php to your forums with the following text in it and post the url here.

    PHP Code:
    <?php
    phpinfo
    ();
    ?>
    Scott MacVicar

    My Blog | Twitter

    Comment


    • #3
      I noticed the same error some days ago, and i'm running vb 2.2.1... I think it's because my host upgraded something, all was working fine before !

      Comment


      • #4
        here is the link

        http://www.newcelica.org/phpinfo.php
        Larry D
        www.newcelica.org

        Comment


        • #5
          And here is the solution
          http://www.vbulletin.com/forum/showt...adid=44820this

          Comment


          • #6
            so we just have to make sure that we have got register_globals turned ON in the php.ini file??
            Larry D
            www.newcelica.org

            Comment


            • #7
              Yes + download the fix attached in the post...
              Last edited by ced; Wed 26 Jun '02, 4:53am.

              Comment


              • #8
                cool thanks.. ill try that later
                Larry D
                www.newcelica.org

                Comment


                • #9
                  No you are running 2.2.6 allegedly.
                  You shouldnt have to upload that patch and register_globals can be left off.

                  Did you overwrite all the files while uploading the 2.2.6 files? If not then upload all the files again. This will make your vBulletin work with php 4.2.0./4.2.1 and register_globals off
                  Scott MacVicar

                  My Blog | Twitter

                  Comment


                  • #10
                    I did overwrite allt he files when I upgraded but I had a couple problems so I reuploaded the old index.php and postings.php I believe its called.. would that be a problem?
                    Larry D
                    www.newcelica.org

                    Comment


                    • #11
                      Try uploading all the original 2.2.6 files and if you have problems then post them here and we will sort them. Though that your currently having suggests that you didnt overwrite user.php in the admin folder.
                      Scott MacVicar

                      My Blog | Twitter

                      Comment

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