السلام عليكم
حل خطأ
حل خطأ
PHP:
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT pf.profilefieldcategoryid, pfc.location, pf.*
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 : Unknown column 'pfc.location' in 'field list'
Error Number : 1054
Request Date : Sunday, December 6th 2009 @ 08:29:31 PM
Error Date : Sunday, December 6th 2009 @ 08:29:31 PM
Script : http://www.eXample.com/vb/member.php?u=1289
Referrer : http://www.eXample.com/vb/index.php
IP Address : 41.238.20.000
Username : Support-ar.com
Classname : vB_Database
MySQL Version : 5.0.81-community
الحل
نفذ هالأمر بالقاعده
نفذ هالأمر بالقاعده
PHP:
alter table profilefieldcategory add `location` varchar(25) NOT NULL default '';