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: MOD Implementation
 active users - got error message sometimes
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

round
New Member

Taiwan
67 Posts

Posted - 26 June 2001 :  16:48:31  Show Profile
I just setup active users features, sometimes it works great, but sometimes, it shows up the following error message. What can I do?

Active Users: 4
admin, error '80020009'
Exception occurred.
/forum/active_users3.asp, line 50


Thanks.


round

maggiau
New Member

96 Posts

Posted - 27 June 2001 :  06:21:24  Show Profile  Visit maggiau's Homepage
same for me

Go to Top of Page

nalley
Starting Member

34 Posts

Posted - 29 June 2001 :  01:48:06  Show Profile
me too !!
Is it a bug??

Go to Top of Page

maggiau
New Member

96 Posts

Posted - 10 July 2001 :  08:47:06  Show Profile  Visit maggiau's Homepage
nobody is able to answer this ???

Go to Top of Page

big9erfan
Average Member

540 Posts

Posted - 10 July 2001 :  11:47:31  Show Profile
I don't use active_users3, I use active_users2, but your problem may be b/c of the time.

See if this problem is occuring on the hour ( or very close to it ).



http://www.ugfl.net/forums
Go to Top of Page

maggiau
New Member

96 Posts

Posted - 11 July 2001 :  17:22:55  Show Profile  Visit maggiau's Homepage
and what to do to solve thisproblem `?

Go to Top of Page

big9erfan
Average Member

540 Posts

Posted - 11 July 2001 :  17:29:09  Show Profile
replace the code in inc_top that begins with ' SET WHEN TO TIMEOUT THE USER
to just before set rsWho = my_Conn.Execute (strSql)
with this


' SET WHEN TO TIMEOUT THE USER
' DO THIS IN SECONDS
strOnlineDate = DateToStr(Date)
strOnlineCheckInTime = DateToStr(strForumTimeAdjust)
OnlineResetTime = 1100 'number of minutes and seconds before reset (format: mmss)
if minute(now) < (OnlineResetTime/100) then OnlineResetTime=OnlineResetTime+(40*100) 'adjust time to be a real value, as opposed to a potentially invalid one
strOnlineTimedOut = strOnlineCheckInTime - OnlineResetTime 'time out the user after OnlineResetTime value above

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = strConnString
objConn.Open


'Check the IP if the user is NOT a Guest
if Left(strOnlineUser, 5) <> "Guest" then
strSql = "SELECT " & strTablePrefix & "ONLINE.UserID, " & strTablePrefix & "ONLINE.UserIP, " & strTablePrefix & "ONLINE.LastChecked"
strSql = strSql & " FROM " & strTablePrefix & "ONLINE "
strSql = strSql & " WHERE " & strTablePrefix & "ONLINE.UserID='" & strOnlineUser & "'"

else
strSql = "SELECT " & strTablePrefix & "ONLINE.UserID, " & strTablePrefix & "ONLINE.UserIP, " & strTablePrefix & "ONLINE.LastChecked"
strSql = strSql & " FROM " & strTablePrefix & "ONLINE "
strSql = strSql & " WHERE " & strTablePrefix & "ONLINE.UserIP='" & strOnlineUserIP & "'"

end if


You can always e-mail me your inc_top as well and I will fix it. big9erfan@ugfl.net

http://www.ugfl.net/forums

Edited by - big9erfan on 11 July 2001 17:29:40
Go to Top of Page

maggiau
New Member

96 Posts

Posted - 13 July 2001 :  03:42:15  Show Profile  Visit maggiau's Homepage
I do not know what you have done ... but it is great ... I did not have the problem anymore ... and the access of my forum is faster ... did you correct something special ???
In any cas a big THANK YOU
Alex

Go to Top of Page

maggiau
New Member

96 Posts

Posted - 13 July 2001 :  09:16:13  Show Profile  Visit maggiau's Homepage
ouille,

I got this again :
HTTP 500.100 - Erreur interne au serveur - Erreur ASP
Services Internet (IIS)

--------------------------------------------------------------------------------

Informations techniques (destinées au personnel du Support technique)

Type d'erreur :
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'rsMember'
/active_users.asp, line 222


Type de navigateur :
Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)

Page :
GET /active_users.asp

Heure :
Friday, July 13, 2001, 3:28:02 PM


Informations complémentaires :
Support technique Microsoft

And it was 15:16 approximately



Edited by - Maggiau on 13 July 2001 09:17:18
Go to Top of Page
  Previous Topic Topic Next Topic  
 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.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07