If you can figure this out, you can be tech admin on my forum.

[Kyle™]

If you can figure this out, you can be tech admin on my forum.

How do you fix this?



Database error in vBulletin 3.6.1:

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 : Unknown column 'pf.profilefieldcategoryid' in 'field list'
Error Number : 1054
Date : Monday, January 21st 2008 @ 06:12:35 PM
Script : http://football101.co.uk/forums/member.php?u=1
Referrer : http://football101.co.uk/forums/showthread.php?t=124
IP Address : 78.145.162.134
Username : El Nino
Classname : vb_database

[Born_To_Live]

Why 3.6.1? Update to 3.6.8.

[VPSwow]

Maybe nulled?

I would run the upgrade to fix tables if i was you :D

[Born_To_Live]

Maybe nulled?

I would run the upgrade to fix tables if i was you :D

I Thought that, but why have such a early version :S

[Kyle™]

It's happened to a few people, it happened to me after i (tried) installing hide hack.

[VPSwow]

Disable hide hack then :D

[Born_To_Live]

Update your version or Check your files.

[Naruto!]

I went on his forum yesterday and it was 3.6.8 I think.

[Born_To_Live]

In that case, you may have installed a backup???

Update your version & it should work if it does not then just contact VB maybe you are missing a profile file?

[Mentor]

you may need to run an install on a mod or hack u installed, as currenlty its saying it cant find a colum in the db, with the name "profilefieldcategoryid"

alterninatly it may be an obscure sql error that appeared in one of the newest versions of it. It effects old ipb 1.3.x installs so i incounted that which causes a simlar error message.

[Kyle™]

The only install file with a hack i have is CPMS or something.

[Born_To_Live]

Did you update your version?

Compare your current profile based files to the ones you should have.

[Kyle™]

How do i update???

[Born_To_Live]

Are you serious?

Visit the Members area on VB's Site in which you bought the licence.

http://www.vbulletin.com/

Left hand side;

Latest Version: 3.6.8 Patch Level 2 (http://www.vbulletin.com/forum/showthread.php?postid=1442161)

Download Now