تكرر مشكلة Database error

[مشعل السليمان]

Database error in vBulletin 3.7.3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Unregistered / Not Logged In',
    `description` = '',
    `usertitle` = 'Guest',
    `opentag` = '',
    `closetag` = '',
    `passwordexpires` = '0',
    `passwordhistory` = '0',
    `vbblog_general_permissions` = '112',
    `vbblog_entry_permissions` = '7744',
    `vbblog_comment_permissions` = '960',
    `forumpermissions` = '524291',
    `genericpermissions` = '0',
    `maxnewthread` = '',
    `maxnewtime` = '',
    `maxnewpost` = '',
    `maxnewposttime` = '',
    `pmquota` = '0',
    `pmpermissions` = '0',
    `pmsendmax` = '0',
    `calendarpermissions` = '0',
    `wolpermissions` = '0',
    `genericpermissions2` = '0',
    `genericoptions` = '0',
    `profilepicmaxwidth` = '100',
    `profilepicmaxheight` = '100',
    `profilepicmaxsize` = '65535',
    `avatarmaxwidth` = '80',
    `avatarmaxheight` = '80',
    `avatarmaxsize` = '20000',
    `signaturepermissions` = '0',
    `sigpicmaxwidth` = '500',
    `sigpicmaxheight` = '100',
    `sigpicmaxsize` = '20000',
    `sigmaxrawchars` = '1000',
    `sigmaxchars` = '500',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '7',
    `sigmaximages` = '25',
    `albumpermissions` = '0',
    `albumpicmaxwidth` = '600',
    `albumpicmaxheight` = '600',
    `albumpicmaxsize` = '100000',
    `albummaxpics` = '100',
    `albummaxsize` = '0',
    `usercsspermissions` = '0',
    `visitormessagepermissions` = '0',
    `socialgrouppermissions` = '0',
    `adminpermissions` = '0'
WHERE usergroupid=1;

MySQL Error   : Unknown column 'maxnewthread' in 'field list'
Error Number  : 1054
Request Date  : Thursday, October 30th 2008 @ 08:31:54 PM
Error Date    : Thursday, October 30th 2008 @ 08:31:54 PM
Script        : http://www.****.com/vb/admincp/usergroup.php?do=update
Referrer      : http://www.****.com/vb/admincp/usergroup.php?do=edit&usergroupid=1
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.51a-community
--> 

عند تعديل في لوحة التحكم أو تغيير في الخصائص , دائماً تاتيني رسالة خطأ وأجدها على الاميل

ما الحل لهذه المشكله !!

[dr-coder]

الاولي اكيد وانته ترقي تجازوت خطوة وهو جدول رسائل الادمن وها جدول جديد بالنسخة

نفذ الامر

DROP TABLE IF EXISTS adminmessage;
CREATE TABLE `adminmessage` (
  `adminmessageid` int(10) unsigned NOT NULL auto_increment,
  `varname` varchar(250) NOT NULL default '',
  `dismissable` smallint(5) unsigned NOT NULL default '0',
  `script` varchar(50) NOT NULL default '',
  `action` varchar(20) NOT NULL default '',
  `execurl` mediumtext NOT NULL,
  `method` enum('get','post') NOT NULL default 'post',
  `dateline` int(10) unsigned NOT NULL default '0',
  `status` enum('undone','done','dismissed') NOT NULL default 'undone',
  `statususerid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`adminmessageid`),
  KEY `script_action` (`script`,`action`),
  KEY `varname` (`varname`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; 

الثاني نفذ

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

اقتباس من الزميل ahmed-samara

http://www.swalif.net/softs/swalif59/softs181089/
تحياتى

[ahmed-samara]

اخي اضف هذا الكود من الــphpmyadmin

ALTER TABLE `usergroup` ADD `maxnewthread` INT( 11 ) DEFAULT '0' NOT NULL ;

واذا لم تنحل فأذن قم بمسح هذا الملف

includes/xml/bitfield_maxnew.xml


بالتوفيق

[مشعل السليمان]

dr-coder

ahmed-samara

جزاكم الله خيراً

أنحلت بمسح هذا الملف

includes/xml/bitfield_maxnew.xml

مشكورين وبارك الله فيكم