[Welshy2008]

Originally Posted by Welshy2008

I have installed it and got the following database error when adding the permissions in Group Permissions - on EVERY group that I tried setting the permissins for. (I have 3.8.1 PL1)

Naturally - when I try to view the downloads section (for example http://www.myforumaddress.com/downloads.php) I get a "You do not have permission to acess this page.

How do I overcome this, Please?

The following is the database error that I received...

Database error in vBulletin 3.8.1: 

Invalid SQL:
UPDATE vbusergroup SET 

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'A - superadministrators',
`description` = 'super Administrators',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '1',
`unreq_perms` = '3',
`forumpermissions` = '16777215',
`genericpermissions` = '2113929215',
`attachlimit` = '1000000',
`pmquota` = '500',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '47',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '140',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '25000',
`avatarmaxwidth` = '50',
`avatarmaxheight` = '50',
`avatarmaxsize` = '20000',
`signaturepermissions` = '241663',
`sigpicmaxwidth` = '0',
`sigpicmaxheight` = '0',
`sigpicmaxsize` = '0',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '25000',
`memarea_permissions` = '0',
`ecdownloadpermissions` = '32767',
`ecexcludecatlist` = '',
`ecdownloadsmaxuploadtotal` = '-1',
`ecdownloadsmaxdailydl` = '-1',
`ecdownloadsmaxdailyfiles` = '-1',
`ecdownloaddelaygrp` = '-1',
`trgpermissions` = '15',
`bfc_download` = '0',
`ugphelpcenter` = '8191'
WHERE usergroupid=11; 

MySQL Error : Unknown column 'bfc_download' in 'field list'
Error Number : 1054
Request Date : Thursday, November 5th 2009 @ 12:36:03 PM
Error Date : Thursday, November 5th 2009 @ 12:36:03 PM
Script : http://www.myforumaddress.com/admincp/usergroup.php?do=update
Referrer : http://www.myforumaddress.com/admincp/usergroup.php?do=edit&usergroupid=11
IP Address : 77.13.299.298
Username : Admin 
Classname : vB_Database
MySQL Version : 5.0.81-community

I think that it maybe because I didn't uninstall the old version (Which didn't work for me) - or didn't over-write it?