[TheMayhem]

Originally Posted by stuky4ever

I tried to edit group permissions and i got a database error.

Database error in vBulletin 4.0.1:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Owner',
`description` = '',
`usertitle` = 'Owner',
`opentag` = '<span style=\"color:#104E8B;font-size:20pt;\">',
`closetag` = '</span>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`market_permissions` = 'Array',
`market_discount` = '0.0000',
`market_maxdonate` = '0.00000',
`market_undo_time` = '',
`market_undo_penalty` = '',
`forumpermissions` = '16777215',
`genericpermissions` = '2113929151',
`attachlimit` = '0',
`pmquota` = '500',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '245759',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '262143',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535'
WHERE usergroupid=6;

MySQL Error : Unknown column 'market_undo_time' in 'field list'
Error Number : 1054
Request Date : Wednesday, January 13th 2010 @ 02:56:29 AM
Error Date : Wednesday, January 13th 2010 @ 02:56:29 AM
Script : http://domain.com/forums/admincp/use....php?do=update
Referrer : http://domain.com/forums/admincp/use...&usergroupid=6
IP Address : XXXXXXXXXXXXX
Username : Stuky
Classname : vB_Database
MySQL Version : 5.0.81-community

Are you upgrading or doing a fresh install?

I just retried it on an upgrade from 1.0.1 to 1.0.2 and it worked perfectly fine. In addition, I tried it as a fresh install and that also worked. Please make sure you are using the correct version of 1.0.2 and reimport the 1.0.2 pointmarket product file (select overwrite to yes). Afterwards retry and let me know what you get.

Is anyone else having this issue?