Log in

View Full Version : problem with user profile


piloto-43
12-15-2007, 05:13 AM
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



http://img528.imageshack.us/img528/174/profilern9.png

Marco van Herwaarden
12-15-2007, 06:25 AM
The table seems missing.

Did you do any recent maintenance, or did something happen that caused this table to be missing?

The most safe solution would be to restore a recent backup.

piloto-43
12-15-2007, 12:35 PM
I did that :( i restore a recent backup but nothing, any solution more plz?

Marco van Herwaarden
12-16-2007, 06:58 AM
To troubleshoot this, please remove any hacks and disable your plugins, then see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

If this still does not solve your problem, then it is a mistery to me why this table is gone both from your database and your backup. Is the backup made using the same vBulletin version as you have installed now? Also as asked before, did you do any recent maintenance or such?