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

[Mohammad Kamal]

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

نص الخطأ

حل المشكله

شرح زراعة أمر في قاعدة البيانات :

https://support-ar.net/forums/showthread.php?t=359

الموضوع متجدد بإذن الله .

تحياتي، محمد​

 

[Mohammad Kamal]

الخطأ :

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]

الخطأ :

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]

الخطأ :

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]

المشكله :

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]

المشكله :

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

الحل :

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

 

[kikotoop]

بسم الله الرحمن الرحيم

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

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

أزرع:

alter table `language` add `phrasegroup_cprofilefield` mediumtext;