حل مشكله المجموعات" Unknown column 'maxnewtime' in 'field list' "

Eng Ahmed

ادارة المنتدى
9 مارس 2008
3,318
11
38
www.support-ar.com
السلام عليكم


المشكله



PHP:
Database error in vBulletin 3.8.1: 

Invalid SQL: 
UPDATE usergroup SET 

### UPDATE QUERY GENERATED BY fetch_query_sql() ### 
    `title` = '{ المراقب العام }', 
    `description` = '<font color=\"#FF0000\"> الّـُوُحْـــدًةً بـٍتــُقـْتُـُلًْــنـــٍْيٍ </font></p>', 
    `usertitle` = '', 
    `opentag` = '<font color=\"#800080\">', 
    `closetag` = '</font>', 
    `passwordexpires` = '0', 
    `passwordhistory` = '0', 
    `maxnewthread` = '0', 
    `maxnewtime` = '', 
    `maxnewpost` = '', 
    `maxnewposttime` = '0', 
    `forumpermissions` = '16769023', 
    `genericpermissions` = '1610569675', 
    `attachlimit` = '0', 
    `pmquota` = '50', 
    `pmpermissions` = '7', 
    `pmsendmax` = '0', 
    `pmthrottlequantity` = '0', 
    `calendarpermissions` = '63', 
    `wolpermissions` = '5', 
    `adminpermissions` = '1', 
    `genericpermissions2` = '1', 
    `genericoptions` = '63', 
    `profilepicmaxwidth` = '180', 
    `profilepicmaxheight` = '300', 
    `profilepicmaxsize` = '65535', 
    `avatarmaxwidth` = '180', 
    `avatarmaxheight` = '300', 
    `avatarmaxsize` = '20000', 
    `signaturepermissions` = '245759', 
    `sigpicmaxwidth` = '2000', 
    `sigpicmaxheight` = '2000', 
    `sigpicmaxsize` = '110000', 
    `sigmaxrawchars` = '800', 
    `sigmaxchars` = '500', 
    `sigmaxlines` = '0', 
    `sigmaxsizebbcode` = '7', 
    `sigmaximages` = '4', 
    `albumpermissions` = '255', 
    `albumpicmaxwidth` = '600', 
    `albumpicmaxheight` = '600', 
    `albumpicmaxsize` = '100000', 
    `albummaxpics` = '30', 
    `albummaxsize` = '0', 
    `usercsspermissions` = '63', 
    `visitormessagepermissions` = '63', 
    `socialgrouppermissions` = '65535', 
    `maximumsocialgroups` = '5', 
    `groupiconmaxsize` = '65535' 
WHERE usergroupid=5; 

MySQL Error   : Unknown column 'maxnewtime' in 'field list' 
Error Number  : 1054 
Request Date  : Monday, February 9th 2009 @ 05:26:34 AM 
Error Date    : Monday, February 9th 2009 @ 05:26:35 AM 
Script        : http://www.0000.com/admincp/usergroup.php?do=update 
Referrer      : http://www.0000.com/admincp/usergroup.php?do=edit&usergroupid=5 
IP Address    :؟؟؟؟؟ 
Username      : 00000
Classname     : vB_Database 
MySQL Version : 5.0.67-community



رمز الخطا

PHP:
;

MySQL Error   : Unknown column 'maxnewtime' in 'field list'


الحل

قم بتنفيذ الامر

PHP:
 ALTER TABLE `usergroup` ADD `maxnewtime` INT( 11 ) DEFAULT '0' NOT NULL ;
حيظهر لك خطا ثاني

قم بتنفيذ الامر الثاني

PHP:
 ALTER TABLE `usergroup` ADD `maxnewpost` INT( 11 ) DEFAULT '0' NOT NULL ;
واحتمال يظهر لك خطا ثالث

اخر امر سيتم تنفيذه


PHP:
ALTER TABLE `usergroup` ADD `maxnewposttime` INT( 11 ) DEFAULT '0' NOT NULL ;



بالتوفيق للجميع

 

mr.cobra

عضو جديد
23 أبريل 2009
138
0
0
المشكلة مانحلت

يسلمووووووو اخووي