
07-05-2006, 08:13 PM
|
|
|
Join Date: Jun 2006
Location: Michigan
Posts: 97
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
I uploaded and overwrote the previous version.
When I go into my usergroup manager and try to grant permission to use the chat room, I get this message upon saving.
Quote:
Database error in vBulletin 3.5.4:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '782847',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions` = '67638851',
`genericoptions` = '30',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`abouttodaypermissions` = '167',
`pagerpermissions` = '5',
`pagerquota` = '0',
`pagerminpost` = '0',
`pagerminpostperday` = '0',
`pagermaxperday` = '0',
`pagersendmax` = '0',
`pagersendmaxchar` = '0',
`sigmaperms` = '1'
WHERE usergroupid=2;
MySQL Error : Unknown column 'sigmaperms' in 'field list'
Error Number : 1054
Date : Wednesday, July 5th 2006 @ 02:11:49 PM
Script : admincp/usergroup.php
Referrer : admincp/usergroup.php?do=edit&usergroupid=2
IP Address :
Username :
Classname : vb_database
|
For some reason, this code in the product file didn't get executed upon upload. Luckily, I have access to my sql server and just ran the sql statement manually. I was then able to modify the chat settings for each user group.
ALTER TABLE usergroup ADD sigmaperms INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ;
|