Web Wiz Forums - permissions

Print Page | Close Window

permissions

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24411
Printed Date: 06 April 2026 at 1:38pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: permissions

Posted By: bobrobert
Subject: permissions
Date Posted: 14 September 2007 at 2:44pm

When my forum loads before I log in there are 16 forums showing instead of 14 Two of the forums are duplicated Against some of them is the red symbol indicating that guests can't access them I have checked and rechecked the permissions in Admin and all of them are ticked for guests to see the forums but can't post, as normal When I log in everything is normal TIA

Replies:

Posted By: WebWiz-Bruce
Date Posted: 14 September 2007 at 3:43pm

In the admin area trying re-submitting those forums to reset the permissions.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: bobrobert
Date Posted: 14 September 2007 at 4:08pm

Thanks I have tried that and uploading the forum again

Posted By: WebWiz-Bruce
Date Posted: 14 September 2007 at 4:18pm

It sounds like you have some orphaned permissions that won't remove.

The only left I can think to suggest is opening your forums database, and deleting the contents of the table 'tblPermissions'

This will remove all the permissions from the forum (it will also make your forums disappear from the main page, but don't worry, it's simply because they have no permissions set).

Then once you have done this log into the admin area and reset all the permissions for your forums. This should then fix the problem you are having.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: bobrobert
Date Posted: 15 September 2007 at 10:02am

Deleted the permissions How do I recreate them? TIA

Posted By: dj air
Date Posted: 15 September 2007 at 10:36am

you recreate them from within the admin area.

within the group permissions

Posted By: bobrobert
Date Posted: 16 September 2007 at 6:38pm

Thanks Unfortunately I deleted all of the permissions I am waiting for 1&1 to provide a back up and restore them

Posted By: WebWiz-Bruce
Date Posted: 17 September 2007 at 10:09am

That doesn't matter, it's what you need to do.

Now login into the admin area by going to the admin.asp file and then click on each forum set the permission and submit them.

This will then recreate the permissions for all your forum.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: bobrobert
Date Posted: 17 September 2007 at 3:39pm

Because I deleted the permissions table I can't log into the forum Can you help a little more please? TIA

Posted By: WebWiz-Bruce
Date Posted: 17 September 2007 at 5:43pm

You deleted the whole table??!!

You were only meant to delete the contents of the table, not the table itself.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: bobrobert
Date Posted: 17 September 2007 at 6:31pm

I am afraid so I take it I need a database backup? TIA

Posted By: WebWiz-Bruce
Date Posted: 17 September 2007 at 6:42pm

The other option is run this SQL to recreate the permissions table:-

CREATE TABLE [DBO].[tblPermissions] (
[Group_ID] [int] NOT NULL DEFAULT (0),
[Author_ID] [int] NOT NULL DEFAULT (0),
[Forum_ID] [int] NOT NULL DEFAULT (0),
[View_Forum] [bit] NOT NULL ,
[Post] [bit] NOT NULL ,
[Reply_posts] [bit] NOT NULL ,
[Edit_posts] [bit] NOT NULL ,
[Delete_posts] [bit] NOT NULL ,
[Priority_posts] [bit] NOT NULL ,
[Poll_create] [bit] NOT NULL ,
[Vote] [bit] NOT NULL ,
[Attachments] [bit] NOT NULL ,
[Image_upload] [bit] NOT NULL ,
[Moderate] [bit] NOT NULL,
[Display_post] [bit] NOT NULL,
[Calendar_event] [bit] NOT NULL
) ON [PRIMARY]

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: bobrobert
Date Posted: 17 September 2007 at 6:56pm

Thanks Would you be so kind as to tell me how I know zilch about data bases TIA

Posted By: bobrobert
Date Posted: 17 September 2007 at 7:13pm

I understand the first two parts but where do I enter "not null" and similar commands TIA

Posted By: WebWiz-Bruce
Date Posted: 18 September 2007 at 9:13am

If 1&1 give you a database tool you should be able to run this as an SQL command on the database.

However, as you need to ask, I think you maybe better off staying away from the database and request a backup from your web host.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: bobrobert
Date Posted: 18 September 2007 at 1:22pm

Thanks again for your help 1&1 are unable to supply a backup database Am I doomed? Anything else I can do? TIA

Posted By: bobrobert
Date Posted: 30 September 2007 at 12:43pm

I have managed to re create the table and permissions but when the forum appears I cannot access any of the forums It states no forums found When trying to change permissions I get

Microsoft OLE DB Provider for SQL Server error '80040e2f'

Cannot insert the value NULL into column 'Author_ID', table 'db195912349.dbo195912349.tblPermissions'; column does not allow nulls. INSERT fails.

/forum/forum/admin_group_permissions.asp, line 123

Please help Two weeks of frustration's TIA

Posted By: bobrobert
Date Posted: 30 September 2007 at 1:47pm

I finally managed to blunder my way through all the problems and it looks like I am up and running again Thanks to all