Dr Ahmed
2009-04-05, 06:25 AM
السلام عليكم ورحمة الله وبركاته
بعد الترقية للنسخة الجديدة 3.8.2
وكان هنالك خطاء عند المحاولة لتعديل المجموعات
وكان هذا هو الخطاء
Database error in vBulletin 3.8.2:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'موقوفين',
`description` = '',
`usertitle` = 'موقــوف',
`opentag` = '<font color=\"#77640a\">',
`closetag` = '</font>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`awardpermissions` = '1',
`forumpermissions` = '0',
`genericpermissions` = '0',
`maxnewthread` = '',
`maxnewtime` = '',
`maxnewpost` = '',
`maxnewposttime` = '',
`attachlimit` = '0',
`pmquota` = '0',
`pmpermissions` = '0',
`pmsendmax` = '0',
`pmthrottlequantity` = '0',
`calendarpermissions` = '0',
`wolpermissions` = '0',
`adminpermissions` = '0',
`genericpermissions2` = '0',
`genericoptions` = '0',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '0',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '2000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '0',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '0',
`visitormessagepermissions` = '0',
`socialgrouppermissions` = '64',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535'
WHERE usergroupid=8;
MySQL Error : Unknown column 'maxnewthread' in 'field list'
Error Number : 1054
Request Date : Tuesday, March 10th 2009 @ 04:26:08 PM
Error Date : Tuesday, March 10th 2009 @ 04:26:08 PM
Script : http://www.****//usergroup.php?do=update
Referrer : http://ww/usergroup.php?do=edit&usergroupid=8
IP Address :
Username :
Classname : vb_database
MySQL Version : 5.0.67-community
حاولت ووجدت حل واحد وهو زراعة أمر بقاعدة البيانات
وهذا هو
تزرع الامر التالى
ALTER TABLE `usergroup` ADD `maxnewthread` INT( 11 ) DEFAULT '0' NOT NULL ; ALTER TABLE `usergroup` ADD `maxnewtime` INT( 11 ) DEFAULT '0' NOT NULL ; ALTER TABLE `usergroup` ADD `maxnewpost` INT( 11 ) DEFAULT '0' NOT NULL ; ALTER TABLE `usergroup` ADD `maxnewposttime` INT( 11 ) DEFAULT '0' NOT NULL ;
==================
اللى ما يظبط معاه زراعه الاوامر ولسه الخطأ يظهر
استبدل الملف التالى باخر
bitfield_vbtube.xml
على المسار التي
/www/vb/includes/xml
وتقبلو تحياتي لكم
بعد الترقية للنسخة الجديدة 3.8.2
وكان هنالك خطاء عند المحاولة لتعديل المجموعات
وكان هذا هو الخطاء
Database error in vBulletin 3.8.2:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'موقوفين',
`description` = '',
`usertitle` = 'موقــوف',
`opentag` = '<font color=\"#77640a\">',
`closetag` = '</font>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`awardpermissions` = '1',
`forumpermissions` = '0',
`genericpermissions` = '0',
`maxnewthread` = '',
`maxnewtime` = '',
`maxnewpost` = '',
`maxnewposttime` = '',
`attachlimit` = '0',
`pmquota` = '0',
`pmpermissions` = '0',
`pmsendmax` = '0',
`pmthrottlequantity` = '0',
`calendarpermissions` = '0',
`wolpermissions` = '0',
`adminpermissions` = '0',
`genericpermissions2` = '0',
`genericoptions` = '0',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '0',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '2000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '0',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '0',
`visitormessagepermissions` = '0',
`socialgrouppermissions` = '64',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535'
WHERE usergroupid=8;
MySQL Error : Unknown column 'maxnewthread' in 'field list'
Error Number : 1054
Request Date : Tuesday, March 10th 2009 @ 04:26:08 PM
Error Date : Tuesday, March 10th 2009 @ 04:26:08 PM
Script : http://www.****//usergroup.php?do=update
Referrer : http://ww/usergroup.php?do=edit&usergroupid=8
IP Address :
Username :
Classname : vb_database
MySQL Version : 5.0.67-community
حاولت ووجدت حل واحد وهو زراعة أمر بقاعدة البيانات
وهذا هو
تزرع الامر التالى
ALTER TABLE `usergroup` ADD `maxnewthread` INT( 11 ) DEFAULT '0' NOT NULL ; ALTER TABLE `usergroup` ADD `maxnewtime` INT( 11 ) DEFAULT '0' NOT NULL ; ALTER TABLE `usergroup` ADD `maxnewpost` INT( 11 ) DEFAULT '0' NOT NULL ; ALTER TABLE `usergroup` ADD `maxnewposttime` INT( 11 ) DEFAULT '0' NOT NULL ;
==================
اللى ما يظبط معاه زراعه الاوامر ولسه الخطأ يظهر
استبدل الملف التالى باخر
bitfield_vbtube.xml
على المسار التي
/www/vb/includes/xml
وتقبلو تحياتي لكم