Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Beta 7.2 bug - Delete Group
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Beta 7.2 bug - Delete Group
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
bierli View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 15 February 2003
Location: Germany
Status: Offline
Points: 15 		Post Options Post Options   Thanks (0) Thanks(0)   Quote bierli Quote  Post ReplyReply Direct Link To This Post Topic: Beta 7.2 bug - Delete Group
    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!



Edited by bierli
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 17 February 2003 at 7:40am
Must be some glitch on your system as I can not replicate this error.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
bierli View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 15 February 2003
Location: Germany
Status: Offline
Points: 15 		Post Options Post Options   Thanks (0) Thanks(0)   Quote bierli Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 17 February 2003 at 8:47am
Try reuploading the file as there shouldn't be anything on line 78 to course an error.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
bierli View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 15 February 2003
Location: Germany
Status: Offline
Points: 15 		Post Options Post Options   Thanks (0) Thanks(0)   Quote bierli Quote  Post ReplyReply Direct Link To This Post 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?

 
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
bierli View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 15 February 2003
Location: Germany
Status: Offline
Points: 15 		Post Options Post Options   Thanks (0) Thanks(0)   Quote bierli Quote  Post ReplyReply Direct Link To This Post 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



Edited by -boRg-
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.