[tjdrico]

Originally Posted by Wolffman

When I tried to edit the permissions this came up:

Database error in vBulletin 3.0.1:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	title = 'Members',
	description = '',
	usertitle = '',
	opentag = '',
	closetag = '',
	passwordexpires = '0',
	passwordhistory = '0',
	attachlimit = '0',
	canpostvbookieevent = '1',
	caneditothersvbookieevents = '1',
	canbet = '1',
	avatarmaxwidth = '150',
	avatarmaxheight = '150',
	avatarmaxsize = '50000',
	profilepicmaxwidth = '200',
	profilepicmaxheight = '200',
	profilepicmaxsize = '65535',
	pmquota = '40',
	pmsendmax = '5',
	uttstore_discount = '0',
	forumpermissions = '127487',
	pmpermissions = '3',
	calendarpermissions = '17',
	wolpermissions = '1',
	adminpermissions = '0',
	genericpermissions = '7879',
	genericoptions = '30',
	shoutboxpermissions = '0',
	siguploaderpermissions = '0',
	arcadepermissions = '0'
WHERE usergroupid=2
mysql error: Unknown column 'canpostvbookieevent' in 'field list'

mysql error number: 1054

According to my local mySQL, those columns shouldn't be in usergroup anyway:

mysql> show columns from vb_usergroup;
+---------------------+----------------------+------+-----+---------+----------------+
| Field               | Type                 | Null | Key | Default | Extra          |
+---------------------+----------------------+------+-----+---------+----------------+
| usergroupid         | smallint(5) unsigned |      | PRI | NULL    | auto_increment |
| title               | varchar(100)         |      |     |         |                |
| description         | varchar(250)         |      |     |         |                |
| usertitle           | varchar(100)         |      |     |         |                |
| passwordexpires     | smallint(5) unsigned |      |     | 0       |                |
| passwordhistory     | smallint(5) unsigned |      |     | 0       |                |
| pmquota             | smallint(5) unsigned |      |     | 0       |                |
| pmsendmax           | smallint(5) unsigned |      |     | 5       |                |
| pmforwardmax        | smallint(5) unsigned |      |     | 5       |                |
| opentag             | varchar(100)         |      |     |         |                |
| closetag            | varchar(100)         |      |     |         |                |
| canoverride         | smallint(5) unsigned |      |     | 0       |                |
| ispublicgroup       | smallint(5) unsigned |      |     | 0       |                |
| forumpermissions    | int(10) unsigned     |      |     | 0       |                |
| pmpermissions       | int(10) unsigned     |      |     | 0       |                |
| calendarpermissions | int(10) unsigned     |      |     | 0       |                |
| wolpermissions      | int(10) unsigned     |      |     | 0       |                |
| adminpermissions    | int(10) unsigned     |      |     | 0       |                |
| genericpermissions  | int(10) unsigned     |      |     | 0       |                |
| genericoptions      | int(10) unsigned     |      |     | 0       |                |
| pmpermissions_bak   | int(10) unsigned     |      |     | 0       |                |
| attachlimit         | int(10) unsigned     |      |     | 0       |                |
| avatarmaxwidth      | smallint(5) unsigned |      |     | 0       |                |
| avatarmaxheight     | smallint(5) unsigned |      |     | 0       |                |
| avatarmaxsize       | int(10) unsigned     |      |     | 0       |                |
| profilepicmaxwidth  | smallint(5) unsigned |      |     | 0       |                |
| profilepicmaxheight | smallint(5) unsigned |      |     | 0       |                |
| profilepicmaxsize   | int(10) unsigned     |      |     | 0       |                |
| arcadepermissions   | int(10) unsigned     | YES  |     | 0       |                |
| uttstore_discount   | varchar(20)          |      |     | 0       |                |
+---------------------+----------------------+------+-----+---------+----------------+
30 rows in set (0.02 sec)

It looks like you didn't follow the installation instructions correctly. Those three columns (canpostvbookieevent, caneditothersvbookieevents, canbet) should have gone directly below "'canseedelnotice' => 262144," in init.php which would make them part of the 'forumpermissions' group.

I recommend that you go through the installation instructions again, double-checking them against what you've actually done.