حل مشكله MySQL Error : Unknown column 'pfc.allowprivacy' in 'where clause'

ENG MUHAMED

[ADMIN]
طاقم الإدارة
25 فبراير 2008
10,079
43
48
support-ar.net
حل مشكله MySQL Error : Unknown column 'pfc.allowprivacy' in 'where clause'

الخطأ كامل

PHP:
Database error in vBulletin 3.8.4:

Invalid SQL:

        SELECT pfc.profilefieldcategoryid AS id
        FROM profilefieldcategory AS pfc
        INNER JOIN profilefield pf
         ON pf.profilefieldcategoryid = pfc.profilefieldcategoryid
        WHERE pfc.allowprivacy = 1
        GROUP BY pfc.profilefieldcategoryid
        ORDER BY pfc.location, pfc.displayorder;

MySQL Error   : Unknown column 'pfc.allowprivacy' in 'where clause'
Error Number  : 1054
Request Date  : Tuesday, December 8th 2009 @ 12:14:34 AM
Error Date    : Tuesday, December 8th 2009 @ 12:14:34 AM
Script        : http://www.example.com/vb/profile.php?do=privacy
Referrer      : http://www.example.com/vb/usercp.php
IP Address    : t1.001.28.225
Username      : ٍSupport-ar.com
Classname     : vB_Database
MySQL Version : 5.0.81-community

الحل تنفيذ الامر التالى بقاعده البيانات

PHP:
alter table profilefieldcategory add `allowprivacy` varchar(25) NOT NULL default ''