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

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 unclosed recordsets?
 New Topic  Topic Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

Helena
Starting Member

Spain
21 Posts

Posted - 22 December 2002 :  13:24:31  Show Profile
Now is even worse:

"internal server error"
"/foro/inc_header.asp, line 117"

In my inc_header.asp in line 117 there are ....

set my_Conn = Server.CreateObject("ADODB.Connection")
my_Conn.Open strConnString
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 22 December 2002 :  13:26:27  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Yes, I've seen it:
quote:
Provider error '80004005'

Error no especificado

/foro/inc_header.asp, line 117



I thought you were trying something... didn't you modify the code?

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

Helena
Starting Member

Spain
21 Posts

Posted - 22 December 2002 :  13:30:20  Show Profile
Nop, I did not changes.

I was testing forums, the fact is i was tryin' to load forums since another machine to test it using another user (normal user).

Go to Top of Page

Helena
Starting Member

Spain
21 Posts

Posted - 22 December 2002 :  17:37:42  Show Profile
OK, what i've observed is:

If i access de forums without login everything works ok
If I access the forums loged as normal user everything's ok too

but when I access as moderator or administrator pages are created in no less than 27 secconds. It happens in any page, specially in default.asp and active.asp. The rest of pages sometimes load fastly and sometimes very slow.

If there's more than a moderator seems the server finally do not accept more connections and finally give an internal server error in inc_header.asp in line 117 which try to open my_Conn again.
After a few minutes without activity can work again but if i contiue as moderator the problem comes again.

If i access de forums as normal user again everything turns ok

I've the private messages mod turned off
I've have active users turned on

Any ideas?

thanks a lot

p.d. lot of thanks for your help, OneWayMule
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 22 December 2002 :  17:48:43  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Helena, I just got this error message at your forums:

quote:
Microsoft VBScript runtime error '800a01a8'

Object required

/foro/active_users.asp, line 692


You may want to take a look at that.

And to sum things up:
You have
Active Users
Private Messages
Additional Smilies
(tweaked by you to work with v3.4)
installed.
If that's all, you could manually check all files of those MODs in order to find unclosed recordsets... it sounds horrible, I know

BTW - you're welcome

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz

Edited by - OneWayMule on 22 December 2002 17:49:12
Go to Top of Page

Helena
Starting Member

Spain
21 Posts

Posted - 22 December 2002 :  18:29:59  Show Profile
Hi again, OneWayMule

ops, yes searching in those files to see if i find an unclosed recordset finally at the last of the page I added :

my_Conn.close
set my_Conn= nothing

thinkin' maybe was this what was unclosed. But I obtain this error you comment

quote:
Microsoft VBScript runtime error '800a01a8'

Object required

/foro/active_users.asp, line 692

so, it doesn't work
i must change this again.

I've been looking for unclosed recordsets in all these files (inc_header.asp, default.asp, inc_func_common.asp, active.asp, active_users.asp) and found all well closed.

The strange thing is that it seems it only happens to me

Ah, the more smilies MOD does not work with the data base.
Specially seems that the problem is when there's an access to data base.
The more smilies MOD work basically with javascript and only use asp to upgrade the files when I add new smilies to its folder rewritting and running more smilies set up.
The changes i made to this MOD was only make it work with reponse.write, like the rest of the forum code. I do not think this MOD can be the problem. It must be araund active users or private messages. Anyway the strange is that only occurs in my forum.

I'll keep you informed about my progress!

Thanks again (and sorry for my horrible english )
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 22 December 2002 :  18:34:47  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
removing the
my_Conn.close
set my_Conn= nothing

should fix the error you get.

My opinion is that the slow loading times have something to do with the Active Users MOD, though it's been ages since I used this MOD, so we'd better hope someone who's familiar with AU can tell more about this issue.

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07