جميع حلول اخطاء واوامر قواعد البيانات للنسخ الجديده 4.0.0

Mohammad Kamal

:: مسؤول سابق ::
15 سبتمبر 2009
501
2
0
الأردن
الخطأ :

كود:
Database error in vBulletin 4.0.2: 

Invalid SQL: 
UPDATE language SET title = title, phrasegroup_vbsettings =  languageid = 1; 

MySQL Error   : Unknown column 'phrasegroup_emailbody' in 'field list' 
Error Number  : 1054

الحل :

كود:
ALTER TABLE `language` ADD `phrasegroup_emailbody` mediumtext
 

Mohammad Kamal

:: مسؤول سابق ::
15 سبتمبر 2009
501
2
0
الأردن
الخطأ :

كود:
Database error in vBulletin 4.0.2: 
MySQL Error : Unknown column 'filesize' in 'field list' 
 Error Number  : 1054

الحل :

كود:
ALTER TABLE `attachment` ADD `filesize` INT UNSIGNED NOT NULL DEFAULT 0

_____________________________________________________________________________

الخطأ :

كود:
Database error in vBulletin 4.0.2: 
MySQL Error   : Unknown column 'warnings' in 'field list'  
Error Number  : 1054

الحل :

كود:
ALTER TABLE `user` ADD `warnings` INT(10) UNSIGNED DEFAULT '0' NOT NULL;

______________________________________________________________________

الخطأ :

كود:
MySQL Error   : Unknown column 'a.displayorder' in 'field list'  
Error Number  : 1054

الحل :

كود:
ALTER TABLE `attachment` ADD `displayorder` int(10) unsigned NOT NULL default '0'
 

Mohammad Kamal

:: مسؤول سابق ::
15 سبتمبر 2009
501
2
0
الأردن
الخطأ :

كود:
MySQL Error   : Unknown column 'htmlstate' in 'field list'  
Error Number  : 1054

الحل :

كود:
ALTER TABLE post ADD htmlstate ENUM('off', 'on', 'on_nl2br') NOT NULL DEFAULT 'on_nl2br'
 

Mohammad Kamal

:: مسؤول سابق ::
15 سبتمبر 2009
501
2
0
الأردن
المشكله :

كود:
MySQL Error   : Unknown column 'newstylevars' in 'field list'
Error Number  : 1054

الحل :

كود:
ALTER TABLE `style` ADD `newstylevars` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL
 

Mohammad Kamal

:: مسؤول سابق ::
15 سبتمبر 2009
501
2
0
الأردن
المشكله :

كود:
MySQL Error   : Unknown column 'dateline' in 'field list'
Error Number  : 1054

الحل :

كود:
ALTER TABLE `style` ADD `dateline` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'
 

kikotoop

عضو جديد
17 أكتوبر 2010
5
0
0
بسم الله الرحمن الرحيم

مشكورين اولا على صرحكم العظيم

عندى مشكلة كنت منزل هاك وحين حذفتة اعطى المنتدى كامل 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 :
 

Alalawi9

عضو جديد
بسم الله الرحمن الرحيم

مشكورين اولا على صرحكم العظيم

عندى مشكلة كنت منزل هاك وحين حذفتة اعطى المنتدى كامل 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 :


أزرع:
PHP:
alter table `language` add `phrasegroup_cprofilefield` mediumtext;