Announcement

Collapse
No announcement yet.

Can't see Profiles

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

  • Can't see Profiles

    I just transferred my forum from a shared server to VPS.

    when i click on a profile i get this error:

    Database error in vBulletin 3.6.7:
    Invalid SQL:
    SELECT pf.profilefieldid, pf.profilefieldcategoryid, pf.required, pf.type, pf.data, pf.def, pf.height
    FROM vbwf_profilefield AS pf
    LEFT JOIN vbwf_profilefieldcategory AS pfc ON(pfc.profilefieldcategoryid = pf.profilefieldcategoryid)
    WHERE pf.form = 0
    ORDER BY pfc.displayorder, pf.displayorder;
    MySQL Error : Table 'bestdest_vbwf.vbwf_profilefieldcategory' doesn't exist
    Error Number : 1146
    when i went into PHPmy admin, the table bolded above is not there.

    help
    My Brand New Forum:
    Best Destination Wedding

    http://www.adminfusion.com/forums/usercp.php

  • #2
    This error means that you did not upload all the 3.6.7 files or you have an add-on that is asking for a field that does not exist in 3.6.7 (profilefieldcategory).

    Reupload all the original vB 3.6.7 non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Then if you still have this problem, disable your plugins.
    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
      thanks steve...i'll try this.
      My Brand New Forum:
      Best Destination Wedding

      http://www.adminfusion.com/forums/usercp.php

      Comment


      • #4
        Originally posted by Steve Machol View Post
        This error means that you did not upload all the 3.6.7 files or you have an add-on that is asking for a field that does not exist in 3.6.7 (profilefieldcategory).

        Reupload all the original vB 3.6.7 non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Then if you still have this problem, disable your plugins.
        Hi Steve, i did the above and it still did not work so i disabled all my plug-ins and it is still not working...anything else I can try?

        i had 3.6.7 before i moved to a new server and it was working fine
        Last edited by friscogal; Thu 28 Jun '07, 7:27pm.
        My Brand New Forum:
        Best Destination Wedding

        http://www.adminfusion.com/forums/usercp.php

        Comment


        • #5
          Sorry, you are missing a table. Try this query to add that table:

          CREATE TABLE vbwf_profilefieldcategory (
          profilefieldcategoryid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
          displayorder SMALLINT NOT NULL DEFAULT '0',
          PRIMARY KEY (profilefieldcategoryid)
          );
          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


          • #6
            Originally posted by Steve Machol View Post
            Sorry, you are missing a table. Try this query to add that table:

            CREATE TABLE vbwf_profilefieldcategory (
            profilefieldcategoryid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
            displayorder SMALLINT NOT NULL DEFAULT '0',
            PRIMARY KEY (profilefieldcategoryid)
            );
            where do i go to do this? i am in the admincp and do not see this option.
            My Brand New Forum:
            Best Destination Wedding

            http://www.adminfusion.com/forums/usercp.php

            Comment


            • #7
              You can run queries in the SQL tab in phpMyAdmin, or to run queries from the Admin CP:

              Admin CP -> Maintenance -> Execute SQL Query -> Manual Query

              Then enter your query in the Manual Query box and click on 'Continue'.

              To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

              // ****** USERS WITH QUERY RUNNING PERMISSIONS ******
              // The users specified here will be allowed to run queries from the control panel.
              // See the above entries for more information on the format.
              // Please note that the ability to run queries is quite powerful. You may wish
              // to remove all user IDs from this list for security reasons.
              $config['SpecialUsers']['canrunqueries'] = 'x';


              ...with x being your userid number.
              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


              • #8
                it worked! thanks steve!!
                My Brand New Forum:
                Best Destination Wedding

                http://www.adminfusion.com/forums/usercp.php

                Comment


                • #9
                  I am working on what appears to be the same issue (I have another thread going in regards to this and will follow up with that on as well when I resolve this issue).

                  I am running into a problem though when I click on "execute sql query"....it tells me "You are not authorized to execute SQL queries"????

                  This is MY forum, I am the main admin, if I am not authorized then who is?

                  Any help would be greatly appreciated as my forum is down ATM

                  Comment


                  • #10
                    Originally posted by Steve Machol View Post

                    To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

                    // ****** USERS WITH QUERY RUNNING PERMISSIONS ******
                    // The users specified here will be allowed to run queries from the control panel.
                    // See the above entries for more information on the format.
                    // Please note that the ability to run queries is quite powerful. You may wish
                    // to remove all user IDs from this list for security reasons.
                    $config['SpecialUsers']['canrunqueries'] = 'x';


                    ...with x being your userid number.

                    OK read first open mouth afterwards...I'll give this ago

                    Comment


                    • #11
                      OK this time I followed the instructions above and it was accomplished, but the issue still remains...neither I or anyone else can view members profiles. Granted these instructions were not meant for me but it appears to be the same issue I am having so I gave it a go.

                      Any help would be appreciated

                      Comment


                      • #12
                        Ok, after my host/servers suggesting that I confirm my Smart FTP connection settings were set to passive mode, which they were, I went back in again and saw further down the page an option to "Force Server IP for PASV Mode" and only then was I able to complete the upgrade upload.

                        After completing the install.php it now appears as though the issue is resolved as I am now able to access and navigate all areas of the forum, those that I have tried so far anyway.

                        Maybe the above query did help in the long run? Who knows, its fixed so all I can do now is back up and be thankful.

                        Thanks for the help

                        Comment


                        • #13
                          I'm having this same problem, this is the error...

                          Database error in vBulletin 3.6.8:

                          Invalid SQL:

                          SELECT pf.profilefieldid, pf.profilefieldcategoryid, pf.required, pf.type, pf.data, pf.def, pf.height
                          FROM profilefield AS pf
                          LEFT JOIN profilefieldcategory AS pfc ON(pfc.profilefieldcategoryid = pf.profilefieldcategoryid)
                          WHERE pf.form = 0
                          ORDER BY pfc.displayorder, pf.displayorder;

                          MySQL Error : Table 'sportsfan.profilefieldcategory' doesn't exist
                          Error Number : 1146
                          When I execute the query above it says that table already exists...

                          An error occurred while attempting to execute your query. The following information was returned.
                          error number: 1050
                          error desc: Table 'vbwf_profilefieldcategory' already exists
                          I only have one plugin and that is the one to sort sub-forums into columns on the main page. I've tried disabling it (through the admincp and by adding define('DISABLE_HOOKS', true); to the config) and have the same problem. I've also tried re-uploading the files.
                          Last edited by Michael2; Mon 6 Aug '07, 11:28am.
                          HBO Forum - Discuss Game of Thrones, True Blood, Big Love, Boardwalk Empire, and more!
                          Disney Forums - Disney theme parks, vacation, entertainment, and more!
                          iLoveTalk - Our general discussion forum.
                          VeggieBoards - The largest and most active vegetarian forum!

                          Comment


                          • #14
                            Got it. Had to remove the vbwf_ from the query...

                            CREATE TABLE vbwf_profilefieldcategory (
                            profilefieldcategoryid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
                            displayorder SMALLINT NOT NULL DEFAULT '0',
                            PRIMARY KEY (profilefieldcategoryid)
                            );
                            HBO Forum - Discuss Game of Thrones, True Blood, Big Love, Boardwalk Empire, and more!
                            Disney Forums - Disney theme parks, vacation, entertainment, and more!
                            iLoveTalk - Our general discussion forum.
                            VeggieBoards - The largest and most active vegetarian forum!

                            Comment

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