problem with user profile

[piloto-43]

Hi when i want view the profile the any user this database error appear, mmm i can restore a user profile ?

thanks

Database error in vBulletin 3.6.8:

Invalid SQL:

        SELECT * FROM profilefieldcategory
        ORDER BY displayorder;

MySQL Error  : Table 'desconectadoz.profilefieldcategory' doesn't exist
Error Number : 1146
Date         : Friday, December 14th 2007 @ 11:51:08 PM
Script       : http://www.desconectados.net/admincp/profilefield.php?do=modify
Referrer     : http://www.desconectados.net/admincp/index.php?do=nav
IP Address   : 201.240.242.59
Username     : desconectado
Classname    : vb_database 

[Jake Bunce]

You are missing one of the default tables (profilefieldcategory). Did you recently upgrade to 3.6.x? If so, make sure you ran the "install/upgrade.php" file to completion. Otherwise you can manually add the missing table by running this query:

CREATE TABLE profilefieldcategory (
profilefieldcategoryid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
displayorder SMALLINT NOT NULL DEFAULT '0',
PRIMARY KEY (profilefieldcategoryid)
)

[piloto-43]

hi how i run this query ... sorry i am a newbie

[Steve Machol]

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.

[piloto-43]

Hi!

i did that .. mm and look!

Ha ocurrido un error mientras se intentaba ejecutar tu consulta. La siguiente información fue devuelta.
número de error: 1064
descripción del 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 'Reply With Quote' at line 6

[Steve Machol]

It looks like the ; is missing. Try this:

CREATE TABLE profilefieldcategory (
profilefieldcategoryid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
displayorder SMALLINT NOT NULL DEFAULT '0',
PRIMARY KEY (profilefieldcategoryid)
);

[piloto-43]

now this

Ha ocurrido un error mientras se intentaba ejecutar tu consulta. La siguiente información fue devuelta.
número de error: 1064
descripción del 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 ';
Reply With Quote' at line 5

[Steve Machol]

That query is correct. I just tried it myself. Make sure you copy-n-paste it exactly.

[piloto-43]

check, I paste this

http://img177.imageshack.us/img177/8889/ejecutarconsultasqldescqk0.png

same

Ha ocurrido un error mientras se intentaba ejecutar tu consulta. La siguiente información fue devuelta.
número de error: 1064
descripción del 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 ';
Reply With Quote' at line 5

[peterska2]

Delete the last line. You have copied too much and have the extra text Reply With Quote on the last line that you have pasted.

[piloto-43]

my bad! sorry ... I did again and check

http://img176.imageshack.us/img176/2034/ejecutarconsultasqldescvj4.png

but when I want view the profile... show me that.

http://img510.imageshack.us/img510/3766/desconectadosdatabaseereb3.png

[peterska2]

Please submit a support ticket then we can look into this.

http://www.vbulletin.com/members/membersupport_contactform.php