Need SQL Help can't read this...

[mattonline]

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 profilefield AS pf
LEFT JOIN 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 'matt_database.profilefieldcategory' doesn't exist
Error Number : 1146
Date : Friday, June 22nd 2007 @ 09:00:33 AM


So, i have created the database table 'profilefieldcategory' but i don't know what fields to put in there, from the above quoted.
Please could you tell me what fields i need to create in the table, thanks alot

 

[neroux]

As you said you created the database I assume you arent getting the error anymore, right?

Anyhow, it seems this is a vbulletin installation, so running path-to-your-installation/install/install.php should setup your database.

 

[mattonline]

thanks for the reply, i have installed the DB but do i need to create any tables, and this is a backup of my old Database on www.EntrepreneurForum.co.uk - so i re-installed it and just put the DB into php admin.

i installed the table and it still has this error when i go to view a profile

http://www.entrepreneurforum.co.uk/member.php?find=lastposter&f=51

 

[neroux]

As far as I can see the table "profilefield" is missing the column "profilefieldcategoryid".

Did you use another version of vbulletin when you created the backup than you are using now?

 

[mattonline]

yes i backed up in Vbulletin 3.65 i think and re-installed it in 3.67 maybe thats the problem, is there an easy way i can update? or will i have to downgrade.

 

[neroux]

Yes this might be very well a reason. I suppose there are upgrade scripts to make the necessary database changes for the new version. The best would be probably to contact jelsoft.

 

[arnold123]

Are you still geting the problem?

 

[mattonline]

yeh i'm still getting a similar problem, such as can't view profile
http://www.entrepreneurforum.co.uk/member.php?find=lastposter&f=3

and when i post a reply theres a mysql error (but the message will still post) could this be a missing file...