MySQL Error : Unknown column 'pfc.allowprivacy' in 'where clause
حل مشكله 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 ''
07-08-2010, 04:28 PM
MySQL Error : Unknown column 'pfc.allowprivacy' in 'where clause 
العرض العادي
المواضيع المتشابهه 
