Can't see Profiles

[friscogal]

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

[Steve Machol]

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.

[friscogal]

thanks steve...i'll try this.

[friscogal]

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

[Steve Machol]

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)
);

[friscogal]

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.

[Steve Machol]

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.

[friscogal]

it worked! thanks steve!!

[mcharley94]

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

[mcharley94]

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

[mcharley94]

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

[mcharley94]

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

[Michael2]

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.

[Michael2]

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)
);