[aceofspades]

Hi,

When I click on a users profile on my forum I get the following database error:

Database error in vBulletin 3.6.2:

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 'xxx.profilefieldcategory' doesn't exist
Error Number : 1146
Date : Sunday, July 12th 2009 @ 05:10:20 PM
Script : xxx
Referrer : xxx/
IP Address : 90.194.25.38
Username : xxx
Classname : vB_Database

I asked my website support to look at it and they said:

----
mysql> 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;
ERROR 1146 (42S02): Table 'xxx_vb.profilefieldcategory' doesn't exist
----

We could find only 'profilefield' table but there is no table named 'profilefieldcategory'. We have also checked the available backup of the database 'xxx_vb'. But it was also overwritten by the modified one.

------
root@rampage [/backup/cpbackup/daily/xxx/mysql]# ll xxx_vb.sql
-rw-r--r-- 1 root root 88888645 Jul 12 06:52 xxx.sql
root@rampage [/backup/cpbackup/daily/xxx/mysql]# grep profilefieldcategory xxx_vb.sql
root@rampage [/backup/cpbackup/daily/xxx/mysql]#
------

It looks like I lost a whole table somehow! I have no idea how. Is this table default VB? Is it replaceable?

I would really appreciate any help with this, its driving my users nuts.

James