لدي مشكلة في قاعدة البيانات SELECT varname, value, datatype FROM setting;

[arabic-host.com]

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

اخواني اعضاء سوالف سوفت

انا احاول ترقية نسخة المنتدى

وعند محاولة الترقية تظهر لي الرسالة التالية


--------------------------------------------------

Database error in vBulletin :

Invalid SQL:
SELECT varname, value, datatype FROM setting;

MySQL Error : Unknown column 'value' in 'field list'
Error Number : 1054
Request Date : Sunday, February 19th 2012 @ 12:29:32 AM
Error Date : Sunday, February 19th 2012 @ 12:29:32 AM
Script : http://www.*******.com/vb/install/upgrade.php
Referrer : http://www.********.com/vb/install/install.php?step=2
IP Address : **********
Username :
Classname : vB_Database
MySQL Version : 5.0.92-community

--------------------------------------------------


ماهو الحل
افيدوني يا اصحاب الخبرة جزاكم الله خيرا

[arabic-host.com]

حسب نصيحة احد الاخوة نفذت الاوامر التالية

-------------------------
DROP TABLE `setting`
-------------------------

ثم نفذت التالي

-------------------------
CREATE TABLE IF NOT EXISTS `setting` ( `varname` varchar(100) NOT NULL default '', `grouptitle` varchar(50) NOT NULL default '', `value` mediumtext, `defaultvalue` mediumtext, `optioncode` mediumtext, `displayorder` smallint(5) unsigned NOT NULL default '0', `advanced` smallint(6) NOT NULL default '0', `volatile` smallint(5) unsigned NOT NULL default '0', `datatype` enum('free','number','boolean','bitfield','usernam e','integer','posint') NOT NULL default 'free', `product` varchar(25) NOT NULL default '', `validationcode` text, `blacklist` smallint(6) NOT NULL default '0', PRIMARY KEY (`varname`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1
-------------------------


راحت المشكلة لكن ظهرت لدي مشكلة جديدة



-------------------------
It is not possible to upgrade directly from vBulletin 2 to vBulletin versions 3.8.x and newer due to incompatabilities in data structures.

If you are currently running vBulletin 2 and would like to upgrade to the latest version of vBulletin, please begin by downloading a version of vBulletin 3.6 from the vBulletin Members' Area.

Upload the extracted files from the archive you download over the existing files here and run the upgrade process until it is complete.

After completing the upgrade process to 3.6.x, download the most recent version of vBulletin from the Members' area, and upload the extracted files here, then continue to run the upgrade process until it is completed.

-------------------------


ارجو الافادة لمن لديه الخبرة في هذا المجال
او مرت عليه نفس المشكلة