بسم الله الرحمن الرحيم
مشكورين اولا على صرحكم العظيم
عندى مشكلة كنت منزل هاك وحين حذفتة اعطى المنتدى كامل database error
كلمت المستضيف رجع المنتدى بس بقيت المشكلة متواجدة كلما فتح عضو الملف الشخصى
او اى زائر حابب يسجل يعطية database error
اعتقد فى ملف ناقص او امر sql
مشكورين للمساعده
Database error in vBulletin 4.0.2:
Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_wol AS phrasegroup_wol,
language.phrasegroup_user AS phrasegroup_user,
language.phrasegroup_messaging AS phrasegroup_messaging,
language.phrasegroup_cprofilefield AS phrasegroup_cprofilefield,
language.phrasegroup_reputationlevel AS phrasegroup_reputationlevel,
language.phrasegroup_infractionlevel AS phrasegroup_infractionlevel,
language.phrasegroup_posting AS phrasegroup_posting,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 3, user.languageid))
WHERE user.userid = 1;
MySQL Error : Unknown column 'language.phrasegroup_cprofilefield' in 'field list'
Error Number : 1054
Request Date : Sunday, October 17th 2010 @ 08:25:55 AM
Error Date : Sunday, October 17th 2010 @ 08:25:55 AM
Script :
http://www.xxxxxx.com/forum/member.php?u=3421
Referrer :
http://www.xxxxx.com/forum/forum.php
IP Address :
Username :
Classname : vB_Database
MySQL Version :