O.K update. I have found dbo.module

Now when I go in there these are the containers I can see:

Colmns
Keys
Constraints
Triggers
Indexes
Statistics

Now my problem, is I have no idea what I am supposed to go into to edit what? Please can someone tell me in plain English?

Thanks

Ok, I've been checking out this problem for an hour (using the source code for the gallery) and I've found the same conclusion as posted earlier:

The popup that fills the Download roles will return an integer (a number like 1,2, 3, etc) and insert that integer into the ModuleSettings table in the DNN database. The record we're looking for is called "DownloadRoles".

Looks OK, storing ID's instead of names is generally a good idea and is implemented thru out DNN.

Problem comes when the Gallery module gets this value from the database and then tries to verify if the user is a member of any of the roles specified in the DownloadRoles setting in the ModuleSettings table.

The function that checks this is called IsInRole (In UserInfo). The function checks for the names of the roles in the database, but the function input parameter is an integers

Question is what is correct: should UserInfo.Roles contain names or ints? From the rest of the code, it is not clear. For example: the constants like glbRoleAllUsersName uses a string, but in PortalController, this value is lookup up to an int on several occasions (like in ParseFolderPermissions).

A fix could be to add a Select Case to UserInfo.IsInRole that looks up the id's and then checks.

Anyway:

The quick fix is as follows:

Fill in the downloadroles in the Gallery as you would do normally.

Now in SQL Server Management Studio, log in to your database, and open a New Query and select your DNN database

SELECT * FROM ModuleSettings WHERE SettingName = 'DownloadRoles'

You will see the entry that contains something like ";1" or maybe ";1;3". These are the integers that need replacement.

SELECT * FROM Roles

This will give you all roles.

Find the role you need and copy that to the clipboard

UPDATE ModuleSettings
SET SettingValue = '';WHERE ModuleId = AND SettingName = 'DownloadRoles'

This should fix it.