Serious Profile Problem

[westpac]

umm wen ever someone tries to click on anyone elses name and trys to view there profile this is what im getting:

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 vbprofilefield AS pf
LEFT JOIN vbprofilefieldcategory AS pfc ON(pfc.profilefieldcategoryid = pf.profilefieldcategoryid)
WHERE pf.form = 0
ORDER BY pfc.displayorder, pf.displayorder;

---im not showing the other info its private----

[Eikinskjaldi]

Originally Posted by westpac

umm wen ever someone tries to click on anyone elses name and trys to view there profile this is what im getting:

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 vbprofilefield AS pf
LEFT JOIN vbprofilefieldcategory AS pfc ON(pfc.profilefieldcategoryid = pf.profilefieldcategoryid)
WHERE pf.form = 0
ORDER BY pfc.displayorder, pf.displayorder;

---im not showing the other info its private----

Well you are going to have to give a bit more info, specifically the bit at the end which says what the error actually is!

[elricstorm]

This should fix your issue:

CREATE TABLE `profilefieldcategory` (
  `profilefieldcategoryid` smallint(5) unsigned NOT NULL auto_increment,
  `displayorder` smallint(5) unsigned NOT NULL,
  PRIMARY KEY  (`profilefieldcategoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

and then..

ALTER TABLE `profilefield` ADD`profilefieldcategoryid` smallint(5) unsigned NOT NULL