
04-18-2008, 12:28 AM
|
|
|
Join Date: Feb 2007
Posts: 469
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
I ran into problems running into changing usergroup permissions.
It looks like your install code did not run properly as I had to create the proper tables/columns manually.
Quote:
Database error in vBulletin 3.7.0 Release Candidate 3:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<font color=\"#DF7E4E\">',
`closetag` = '</font>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`ugphelpcenter` = '1983',
`forumpermissions` = '8380415',
`genericpermissions` = '2147483583',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '55',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '120',
`avatarmaxheight` = '120',
`avatarmaxsize` = '40000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '31',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '511',
`mgc_cb_evo_permissions` = '255',
`mgc_cb_evo_nbmsg_show` = '0',
`mgc_cb_evo_nbmsg_perday_show` = '0',
`mgc_cb_evo_default_color` = '000000'
WHERE usergroupid=6;
MySQL Error : Unknown column 'ugphelpcenter' in 'field list'
Error Number : 1054
Date : Thursday, April 17th 2008 @ 07:26:07 PM
Script : http://www.xxxxxx.net/forum/admincp/....php?do=update
Referrer : http://www.xxxxx.net/forum/admincp/u...&usergroupid=6
IP Address : xxxxxx
Username : Hasselhoff
Classname : vB_Database
MySQL Version : 5.0.45-community-log
|
|