Announcement

Collapse
No announcement yet.

profile lookup error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • profile lookup error

    I'm very new to VB and have not been able to figure this out yet.
    Any Ideas?

    Database error in vBulletin 3.6.3:
    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 : Table 'vBulletin.profilefieldcategory' doesn't exist
    Error Number : 1146
    Date : Monday, December 3rd 2007 @ 11:26:54 AM
    Script : http://forums.xxx.com/member.php?u=9
    Referrer : http://forums.xxx.com/
    IP Address : 204.244.252.153
    Username : slashman
    Classname : vb_database

  • #2
    You are missing one of the default tables (profilefieldcategory). Did you recently upgrade to 3.6.x? If so, make sure you ran the "install/upgrade.php" file to completion. Otherwise you can manually add the missing table by running this query:

    CREATE TABLE profilefieldcategory (
    profilefieldcategoryid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
    displayorder SMALLINT NOT NULL DEFAULT '0',
    PRIMARY KEY (profilefieldcategoryid)
    )

    Comment

    Loading...
    Working...
    X