| Author |
 Topic  |
|
VodkaFish
Average Member
USA
654 Posts |
 Posted - 23 June 2002 : 17:51:49
|
I recently installed the latest Active Users mod. It's the best time as my site gets 1/4 the traffic over the summer. So, I had the stats showing, and the record was 17. The server is reset, and now it's 14? I didn't lose any messages or anything else from my Snitz db. I thought this was stored in the config table. Does anyone know how or why this happened?
v ø d k â f ï § h |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 23 June 2002 : 17:57:10
|
Have you checked the value in the Forum_config_new table? Was it changed there also?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
 |
|
|
VodkaFish
Average Member
USA
654 Posts |
Posted - 23 June 2002 : 20:41:38
|
Yup, the value matches in there. I never touched the database when it changed (any table at any time).
I mean, this isn't a bug or a big deal. It was just weird 
v ø d k â f ï § h |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 23 June 2002 : 20:54:19
|
Weird indeed. I admit I had a couple unexplained resets in the Active Users config, but I can't remember whether the record was affected. And they happened mostly on my localhost, which means the record rarely goes above one, and never above two.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Edited by - ruirib on 23 June 2002 20:54:47 |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 30 June 2002 : 16:33:53
|
I think you may have found a bug. . .
When the active users number is higher than the active users record (app variable) it resets the app variable and the database info. It doesn't check the database info to see if it is even higher. (DOH!)
 Nathan Bales
Snitz Exchange | Do's and Dont's |
|
|
|
VodkaFish
Average Member
USA
654 Posts |
Posted - 01 July 2002 : 19:06:09
|
No big deal now, my record just hovers in the teens since my traffic is low in the summer. If it hops around from 20-50 in September, I think someone might start to notice  At least it always works, so I'd consider this a pretty minor bug.
v ø d k â f ï § h |
|
|
|
Justine
Starting Member
18 Posts |
Posted - 01 July 2002 : 19:37:42
|
Where would you go to change this record ?
I want to make it look like I have had 1000's of people on my forum at the same time !
|
|
|
|
VodkaFish
Average Member
USA
654 Posts |
Posted - 09 July 2002 : 10:39:24
|
Can anyone point me to the code to change (where it is)? My server seems to be having problems and keeps getting reset.
Thanx.
v ø d k â f ï § h |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 July 2002 : 12:33:48
|
You need to check the chkAURecord function in inc_functions.asp.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 July 2002 : 12:48:16
|
Ok, try replacing the function for this one to see if it helps:
function chkAURecord(intTotalActiveUsers)
Dim rsRec, strRecSql, tempRec
if intTotalActiveUsers > intAURecord then 'We have a new record!!! :)
'test this against the database:
strRecSql = "SELECT C_VALUE FROM " & strTablePrefix & "CONFIG_NEW WHERE C_VARIABLE='intAURecord'"
Set rsRec = Server.CreateObject("ADODB.Recordset")
rsRec.Open strRecSql, my_conn
if rsRec.EOF or rsRec.BOF then 'Exit if you cannot read the current value
rsRec.Close
Set rsRec = nothing
Exit Function
End if
'now test the value from the DB:
tempRec = Cint(rsRec("C_VALUE"))
if intTotalActiveUsers > tempRec Then
strDummy = SetConfigValue(1, "intAURecord", cstr(intTotalActiveUsers))
strDummy = SetConfigValue(1, "strAURecordDate", DateToStr(strForumTimeAdjust))
intAURecord = intTotalActiveUsers
strAURecordDate = DateToStr(strForumTimeAdjust)
Application(strCookieURL & "INTAURECORD") = intTotalActiveUsers
Application(strCookieURL & "STRAURECORDDATE") = DateToStr(strForumTimeAdjust)
end if
rsRec.Close
set rsRec = nothing
end if
end function
With this I'm just following Nathan's own hint. I don't know whether this will fix the reset, cause it's hard to cause a reset on my forum, but check it out.
Let me know how it goes.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
QuickSilva
Junior Member
136 Posts |
Posted - 16 July 2002 : 19:50:22
|
Since my forum reset how can i change the Active Users rcord to what it was before. It was 14 and now it's 6. I want to change it back to 14. How?
I used that code aswell, i'll tell u how it goes.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 July 2002 : 20:07:06
|
quote:
Since my forum reset how can i change the Active Users rcord to what it was before. It was 14 and now it's 6. I want to change it back to 14. How?
Either you write a small script to write to the database, or change the value in the database manually, or through something like Table Editor.
quote:
I used that code aswell, i'll tell u how it goes.
Ok, since I took the trouble to write it at least I'd like to know if it works.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
QuickSilva
Junior Member
136 Posts |
Posted - 16 July 2002 : 20:27:11
|
Thankyou, back to normal again. So far works but it did take a week or 2 till it reset. I'll reply to this topic if it fails.
Thanks Anyway
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
VodkaFish
Average Member
USA
654 Posts |
Posted - 17 July 2002 : 16:46:47
|
ruirib - I haven't had a chance to change any of my code yet. I'll let you know if it works. My server seems to be resetting quite often recently, so mine is always changing. I hope to test this within the week. Thanx.
v ø d k â f ï § h |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 17 July 2002 : 17:10:25
|
quote:
ruirib - I haven't had a chance to change any of my code yet. I'll let you know if it works. My server seems to be resetting quite often recently, so mine is always changing. I hope to test this within the week. Thanx.
v ø d k â f ï § h
Okie dokie.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Topic |
|
Topic Locked
