NameSilo

Need SQL Help can't read this...

Spaceship Spaceship
Watch

mattonline

Established Member
Impact
2
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
 
0
•••
The views expressed on this page by users and staff are their own, not those of NamePros.
.US domains.US domains
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.
 
0
•••
0
•••
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?
 
0
•••
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.
 
0
•••
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.
 
0
•••
Are you still geting the problem?
 
0
•••
0
•••
Appraise.net

We're social

Unstoppable Domains
Domain Recover
NameMaxi - Your Domain Has Buyers
  • The sidebar remains visible by scrolling at a speed relative to the page’s height.
Back