حل مشكله 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 ''