Database Error... Any idea?
 

Hi,

After transfering database everything seems to be working fine..but...

I recently got the following error and i think it is when somebody tried to send a PM via a forum.
------

Database error in vBulletin 3.6.5:

Invalid SQL:

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

MySQL Error : Table 'fcpas3_forum.bl_profilefieldcategory' doesn't
exist
Error Number : 1146
Date : Sunday, June 10th 2007 @ 01:04:11 PM
Script : http://site/member.php?u=1
Referrer : http://site/memberlist.php
IP Address : .............
Username : .......
Classname : vb_database

-----------------

Im thinking I should create the database stated above as "doesnt exist" what whats best way to do it if that the way to go fixing this? If I make this table manually, is there any fields I should add to the table or can someone just give me sql code I can paste and have it added?

You said you transferred your database - did you recently do an upgrade?
Also, you might want to remove your username/IP address information.

Yes, i did do an upgrade to newer version.

I think I got it, just need to add that table to database. The thing is I already have this table with different index, anyway to rename a table?

What you may need to do is re-run the upgrade script, as there may be more issues than just that one table missing.

Thanks , after upgrade it works great. Any idea why it still shows "Latest version available: 3.6.7 PL1. You are currently running vBulletin version 3.6.7." in admin area after I intalled the new version already and upgraded?

Did you install the 3.6.7 PL1 patch ???

What may have happened was that you grabbed the 3.6.7 version right before the 3.6.7 PL1 was released (I did that too). You will need to get the 3.6.7 PL1 or patch.