Web Wiz Support and Community Forums : permissions https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 13:41:34 +0000 Sun, 30 Sep 2007 13:47:28 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24411 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[permissions : I finally managed to blunder my...]]> https://forums.webwiz.net/permissions_topic24411_post128168.html#128168 Author: bobrobert
Subject: 24411
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]]> Sun, 30 Sep 2007 13:47:28 +0000 https://forums.webwiz.net/permissions_topic24411_post128168.html#128168 <![CDATA[permissions : I have managed to re create...]]> https://forums.webwiz.net/permissions_topic24411_post128167.html#128167 Author: bobrobert
Subject: 24411
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'; columndoes not allow nulls. INSERT fails.

/forum/forum/admin_group_permissions.asp, line 123


Please help Two weeks of frustration's TIA 


Edited by bobrobert - 30 September 2007 at 1:07pm]]> Sun, 30 Sep 2007 12:43:18 +0000 https://forums.webwiz.net/permissions_topic24411_post128167.html#128167 <![CDATA[permissions : Thanks again for your help 1&amp;1...]]> https://forums.webwiz.net/permissions_topic24411_post127749.html#127749 Author: bobrobert
Subject: 24411
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


Edited by bobrobert - 18 September 2007 at 4:13pm]]> Tue, 18 Sep 2007 13:22:33 +0000 https://forums.webwiz.net/permissions_topic24411_post127749.html#127749 <![CDATA[permissions : If 1&amp;1 give you a database...]]> https://forums.webwiz.net/permissions_topic24411_post127734.html#127734 Author: WebWiz-Bruce
Subject: 24411
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.


Edited by -boRg- - 18 September 2007 at 9:14am]]> Tue, 18 Sep 2007 09:13:58 +0000 https://forums.webwiz.net/permissions_topic24411_post127734.html#127734 <![CDATA[permissions : I understand the first two parts...]]> https://forums.webwiz.net/permissions_topic24411_post127708.html#127708 Author: bobrobert
Subject: 24411
Posted: 17 September 2007 at 7:13pm

I understand the first two parts but where do I enter "not null" and similar commands TIA]]> Mon, 17 Sep 2007 19:13:05 +0000 https://forums.webwiz.net/permissions_topic24411_post127708.html#127708 <![CDATA[permissions : Thanks Would you be so kind as...]]> https://forums.webwiz.net/permissions_topic24411_post127707.html#127707 Author: bobrobert
Subject: 24411
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]]> Mon, 17 Sep 2007 18:56:38 +0000 https://forums.webwiz.net/permissions_topic24411_post127707.html#127707 <![CDATA[permissions : The other option is run this...]]> https://forums.webwiz.net/permissions_topic24411_post127705.html#127705 Author: WebWiz-Bruce
Subject: 24411
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]
]]> Mon, 17 Sep 2007 18:42:41 +0000 https://forums.webwiz.net/permissions_topic24411_post127705.html#127705 <![CDATA[permissions : I am afraid so I take it I need...]]> https://forums.webwiz.net/permissions_topic24411_post127704.html#127704 Author: bobrobert
Subject: 24411
Posted: 17 September 2007 at 6:31pm

I am afraid so I take it I need a database backup? TIA]]> Mon, 17 Sep 2007 18:31:34 +0000 https://forums.webwiz.net/permissions_topic24411_post127704.html#127704 <![CDATA[permissions : You deleted the whole table??!!You...]]> https://forums.webwiz.net/permissions_topic24411_post127701.html#127701 Author: WebWiz-Bruce
Subject: 24411
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.
]]> Mon, 17 Sep 2007 17:43:37 +0000 https://forums.webwiz.net/permissions_topic24411_post127701.html#127701 <![CDATA[permissions : Because I deleted the permissions...]]> https://forums.webwiz.net/permissions_topic24411_post127695.html#127695 Author: bobrobert
Subject: 24411
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

Edited by bobrobert - 17 September 2007 at 4:18pm]]> Mon, 17 Sep 2007 15:39:21 +0000 https://forums.webwiz.net/permissions_topic24411_post127695.html#127695