Print Page | Close Window

Beta 7.2 bug - Delete Group

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=238
Printed Date: 29 March 2026 at 2:55am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Beta 7.2 bug - Delete Group
Posted By: bierli
Subject: Beta 7.2 bug - Delete Group
Date Posted: 17 February 2003 at 1:34am

Hi,

I found a possible Bug in Version 7 Beta 2.

I tried to delete the "Full Member" Group and got a internal server error at "forum/admin/delete_group.asp, line 78"

ODCB say's that 1 parameter was expectet but insufficient parameters are delivered.

Kind regards
Thomas

THANKS!

NO MORE PROBLEMS WITH BETA 3!




Replies:
Posted By: WebWiz-Bruce
Date Posted: 17 February 2003 at 7:40am
Must be some glitch on your system as I can not replicate this error.

-------------
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: bierli
Date Posted: 17 February 2003 at 7:55am

Originally posted by -boRg- -boRg- wrote:

Must be some glitch on your system as I can not replicate this error.

Hmmm......tricky

I made no changes in any asp file or in the database.
I just translated the language files.

Anyone else have a soloution or hint for me?

Kind regards
Thomas



Posted By: WebWiz-Bruce
Date Posted: 17 February 2003 at 8:47am
Try reuploading the file as there shouldn't be anything on line 78 to course an error.

-------------
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: bierli
Date Posted: 17 February 2003 at 9:41am

Damn! :-(

Reuploading did not solve the problem.

In MY Line 78 of the file 'admin/delete_group.asp' I find
rsCommon.Open strSQL, adoCon
 

ANOTHER ERROR:

If i click on the same site the 'Update Starting Group' Button, I get the same Error: '1 parameter was expectet but insufficient parameters are delivered'.

In MY Line 81 of the file 'admin/view_groups.asp' I find
adoCon.Execute(strSQL)

I tried the Microsoft Access Driver and the Microsoft.Jet.OLEDB.4.0 Driver. But the problem is still the same.

ANY OTHER HINTS?

 



Posted By: WebWiz-Bruce
Date Posted: 17 February 2003 at 9:49am

The two queries in question have True or False fields in them.

If you have upgraded your database then these fields may not be of the correct datatype anymnore, also if you are using SQL server these fields also need changing. Try changing in the SQL queires True to 1 and False to 0.

Also if you could let me know what database you are using and if you used some upgarde script, as this maybe where the error lies.



-------------
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: bierli
Date Posted: 17 February 2003 at 10:41am

It was a completly new installation with the zip file from your download section.

I use the Access 2000 DB and actually the Microsoft.Jet.OLEDB.4.0 Driver.

Webserver is ISS 5 Windows Advanced Server.

In the database at the table 'tblGroup' i've the following fields:
GroupID = Auto
Name = Text
Minimum_posts = Number
Special_rank = Yes/No
Stars = Number
Starting_group = Yes/No

Below the code of both Files.

I hope it helps.

Kind Regards
Thomas



Posted By: WebWiz-Bruce
Date Posted: 17 February 2003 at 11:44am

You don't need to put in the code, I know what it looks like.

The error line number isn't the line that is in error, the problem is with the SQL statemnet that is set in the lines above, it looks like your server is having problems with true and false in SQL statements change these to the following:-

true = 1
false = 0



-------------
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: bierli
Date Posted: 17 February 2003 at 12:21pm

Thanks!

NO MORE PROBLEMS WITH BETA 3!



Posted By: WebWiz-Bruce
Date Posted: 17 February 2003 at 12:25pm
Starnge as the SQL query has not changed in beta 3.

-------------
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: bierli
Date Posted: 17 February 2003 at 12:38pm

DOSNT MATTER!

IT WORKS! :-)




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net