Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Bug Reports (Closed)
 BUG+FIX (3.1sr2): Error when Deleting
 Forum Locked  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

Eye4Design
Starting Member

20 Posts

Posted - 23 August 2000 :  10:26:12  Show Profile
When you are deleting all the forms and categorys then you get an error message:

Error Type:
(0x80020009)
Exception occurred.
/sitezine/forum/inc_functions.asp, line 508


This message go away when you make one forum,catogry and one message!!!

Really strange i think

Is there an solution for this

Peter

Moved here by Gor...
Can this be confirmed as a bug ??

Kat
Advanced Member

United Kingdom
3065 Posts

Posted - 26 October 2000 :  07:19:56  Show Profile  Visit Kat's Homepage
I have had a similar problem:

When I tried to delete a forum i get the message:

All Forums
error '80020009'
Exception occurred.

/forum.asp, line 209

Any help would be appreciated.


KatsKorner

Edited by - Kat on 26 October 2000 07:20:16
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 26 October 2000 :  07:27:21  Show Profile  Visit HuwR's Homepage
You must have at least one category and topic.

'Resistance is futile'
Go to Top of Page

Reinsnitz
Snitz Forums Admin

USA
3545 Posts

Posted - 26 October 2000 :  14:08:44  Show Profile  Visit Reinsnitz's Homepage  Send Reinsnitz an AOL message  Send Reinsnitz an ICQ Message  Send Reinsnitz a Yahoo! Message
Category and Topic FORUM

Reinsnitz (Mike)
><)))'>

"I no longer call you servants, because a servant does not know his master's business. Instead I have called you friends..."
-- John 15:15
Go to Top of Page

Reinsnitz
Snitz Forums Admin

USA
3545 Posts

Posted - 26 October 2000 :  14:09:31  Show Profile  Visit Reinsnitz's Homepage  Send Reinsnitz an AOL message  Send Reinsnitz an ICQ Message  Send Reinsnitz a Yahoo! Message
it would probably be a good idea to get the code working without this bug... it would be a more proffessional touch :)

Reinsnitz (Mike)
><)))'>

"I no longer call you servants, because a servant does not know his master's business. Instead I have called you friends..."
-- John 15:15
Go to Top of Page

Kat
Advanced Member

United Kingdom
3065 Posts

Posted - 14 November 2000 :  09:17:29  Show Profile  Visit Kat's Homepage
Any progress on sorting this?

KatsKorner
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 14 November 2000 :  09:30:36  Show Profile  Visit HuwR's Homepage
Actually, you only need to keep one category, it is perfectly safe to delete all the forums.

'Resistance is futile'
Go to Top of Page

Kat
Advanced Member

United Kingdom
3065 Posts

Posted - 14 November 2000 :  09:39:03  Show Profile  Visit Kat's Homepage
Ok so I have a category with a forum in it with no topics. I then delete the forum and refresh the page. It then throws the following error:

 error '80020009' 
Exception occurred.

/forums/forum.asp, line 212


I know why it throws the error:

rsFStatus.EOF is TRUE so the exception occurs. I am in the process of trying to fix it.

KatsKorner
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 14 November 2000 :  09:41:59  Show Profile  Visit HuwR's Homepage
I just deleted all the categories and forums in my test site, no problems at all, it just says No Categories/Forums found. No errors.

'Resistance is futile'
Go to Top of Page

Kat
Advanced Member

United Kingdom
3065 Posts

Posted - 14 November 2000 :  09:44:31  Show Profile  Visit Kat's Homepage
Try this then:

create a new forum under a category.
go into the forum and delete it from there.
then hit refresh and see whether you get the same error in forum.asp.

if not can I have your forum.asp code?

cheers..

KatsKorner
Go to Top of Page

Kat
Advanced Member

United Kingdom
3065 Posts

Posted - 14 November 2000 :  09:55:29  Show Profile  Visit Kat's Homepage
I have fixed mine by adding the following code to forum.asp after the </script> tag.

<%if rsCStatus.EOF = true OR rsFStatus.EOF = true then
Response.Redirect("default.asp")
end if
%>


I don't know if this is the best way but it seems to work...

KatsKorner

Edited by - kat on 14 November 2000 09:56:22
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 14 November 2000 :  12:45:57  Show Profile  Visit HuwR's Homepage
You're right, your code looks ok. It depends wether you might want to display a message saying There are no forums and then redirect.

'Resistance is futile'
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts

Posted - 14 November 2000 :  13:53:27  Show Profile  Visit gor's Homepage
I think it is ok the way Kat coded it, it acts the same way as topic.asp: if you don't supply the right data there you are redirected top default.asp without any message also.

Kat, thanks for bumping this post, because you explained a scenario we never would have tested otherwise !

Pierre Gorissen

Even if you're on the right track,
you'll get run over if you just sit there.

Will Rogers
Go to Top of Page

davemaxwell
Access 2000 Support Moderator

USA
3020 Posts

Posted - 15 November 2000 :  08:37:34  Show Profile  Visit davemaxwell's Homepage  Send davemaxwell an AOL message  Send davemaxwell an ICQ Message  Send davemaxwell a Yahoo! Message
Seems to me either a)we shouldn't have the delete forum option in forum.asp or b)we should include Kat's code to handle that situation.

Good eye, Kat!! That's not something I would have thought to try...

Dave Maxwell
--------------
When's the next meeting of Snitzaholics Anonymous
Go to Top of Page

Kat
Advanced Member

United Kingdom
3065 Posts

Posted - 15 November 2000 :  08:40:40  Show Profile  Visit Kat's Homepage
My pleasure! Glad I spotted it first because my boss would have got there anyway!

KatsKorner

Edited by - kat on 15 November 2000 08:41:26
Go to Top of Page

Reinsnitz
Snitz Forums Admin

USA
3545 Posts

Posted - 05 January 2001 :  15:29:32  Show Profile  Visit Reinsnitz's Homepage  Send Reinsnitz an AOL message  Send Reinsnitz an ICQ Message  Send Reinsnitz a Yahoo! Message
<- bump -> was this done?

Reinsnitz (Mike)
><)))'>
"The glory of young men is their strength, and the honor of old men is their gray hair." - Proverbs 20:29
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.21 seconds. Powered By: Snitz Forums 2000 Version 3.4.07