Dr Ahmed
2009-02-09, 04:21 PM
السلام عليكم
المشكله
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
رمز الخطا
;
MySQL Error : Unknown column 'maxnewtime' in 'field list'
الحل
قم بتنفيذ الامر
ALTER TABLE `usergroup` ADD `maxnewtime` INT( 11 ) DEFAULT '0' NOT NULL ;
حيظهر لك خطا ثاني
قم بتنفيذ الامر الثاني
ALTER TABLE `usergroup` ADD `maxnewpost` INT( 11 ) DEFAULT '0' NOT NULL ;
واحتمال يظهر لك خطا ثالث
اخر امر سيتم تنفيذه
ALTER TABLEALTER TABLE `usergroup` ADD `maxnewposttime` INT( 11 ) DEFAULT '0' NOT NULL ;
بالتوفيق للجميع
المشكله
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
رمز الخطا
;
MySQL Error : Unknown column 'maxnewtime' in 'field list'
الحل
قم بتنفيذ الامر
ALTER TABLE `usergroup` ADD `maxnewtime` INT( 11 ) DEFAULT '0' NOT NULL ;
حيظهر لك خطا ثاني
قم بتنفيذ الامر الثاني
ALTER TABLE `usergroup` ADD `maxnewpost` INT( 11 ) DEFAULT '0' NOT NULL ;
واحتمال يظهر لك خطا ثالث
اخر امر سيتم تنفيذه
ALTER TABLEALTER TABLE `usergroup` ADD `maxnewposttime` INT( 11 ) DEFAULT '0' NOT NULL ;
بالتوفيق للجميع