Web Wiz Forums - Forum permission SQL Server error

Print Page | Close Window

Forum permission SQL Server error

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=11090
Printed Date: 08 April 2026 at 4:23pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Forum permission SQL Server error

Posted By: ytrudel
Subject: Forum permission SQL Server error
Date Posted: 05 July 2004 at 2:32pm

Hi, there is an error when submitting change for forum permission, like adding moderators to some forums.

I quickly made a pdf describing this error, you can find it here:

http://www.mangokaki.com/forumerror/forum_error_membership_permissions.pdf - http://www.mangokaki.com/forumerror/forum_error_membership_p ermissions.pdf

Replies:

Posted By: WebWiz-Bruce
Date Posted: 05 July 2004 at 3:04pm

You haven't mentioned what version you are using?

This error did occur with a previous version on some SQL Servers.

Try upgrading to the latest version to fix the problem.

-------------
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: ytrudel
Date Posted: 05 July 2004 at 5:23pm

I first came thought that error with my first installation (7.7) The first thing I did was to upgrade to the latest one ... (7.9) ;)

But that didn't help ...

I know that the name "READ" is a keyword in SQL and when using recordset in the form of rs.addNew and rs.update it generate uncompatible code... (That's where the error come from ...)

There is still the possibility that someone know a work around that error as this is a basic administration functionnality and probably anyone installing the forum will use that one ;)

So, does anybody know of a fix / work-around?

If not, then the error is then reported for the next upgrade and will come back to get the next version when it will be there ;)

Posted By: WebWiz-Bruce
Date Posted: 06 July 2004 at 5:12am

Try reuploading the files in the admin area as this error shouldn't occur.

The page does work with MS SQL Server as this is the primary database that the forum is tested with and that particular function does work on this site as well, I've just tested it, which also uses SQL Server.

To prevent the error the keyword 'Read' is placed in square brackets to prevent the error you mention for happening. i.e. [Read]

-------------
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