| Author |
 Topic  |
|
mikey344
Starting Member
48 Posts |
 Posted - 20 April 2002 : 01:00:19
|
I don't know if anyone else is experiencing this problem. But I implemented the MOD with little trouble. The problem is, when anyone surfs to any topic in the entire forum, the Active Users page shows them as being in an unknown location every time. Has anyone else experienced this?
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
|
mikey344
Starting Member
48 Posts |
Posted - 20 April 2002 : 01:54:50
|
Just tried that and I'm still having the same problem. Everything keeps showing up as unknown location :(
|
 |
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
|
mikey344
Starting Member
48 Posts |
Posted - 20 April 2002 : 02:03:51
|
MS SQL 2000. I'm looking in the database and the string is in there.
|
|
|
|
HarshReality
Junior Member
USA
128 Posts |
Posted - 20 April 2002 : 02:16:14
|
I have noticed a few problems with "whoisinside"
since it is using the ONLINE table removed in AU4
Oh what wonders await we the ****ed in exile, for in a single act of rage I have slain what little humanity I have left and all that remains is the beast.... |
|
|
|
mikey344
Starting Member
48 Posts |
Posted - 20 April 2002 : 02:18:19
|
I wish I could figure this out...the old Active Users always worked just fine. This new one is a lot nicer though. I just need to fix this "Invalid Location" proglem. BTW...I don't have the Whosinside MOD installed...not yet at least ;)
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 20 April 2002 : 03:16:13
|
| It might help if you would post the URL of the forum where you are having the problem. |
|
|
|
mikey344
Starting Member
48 Posts |
Posted - 20 April 2002 : 11:36:10
|
Ok, I'll give you what is in the database and the current URL that the user is at.
Current URL of user:
http://www.mydomain.com/web/asp/forum/topic.asp?TOPIC_ID=222
Database Info:
AU_LASTPAGE = topic.asp
AU_QUERYSTRING=TOPIC_ID=222
When I goto the Active Users Page, it shows Unknown Location for this user. What do you guys think?
Edited by - mikey344 on 20 April 2002 11:38:24 |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
|
mikey344
Starting Member
48 Posts |
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 20 April 2002 : 18:49:23
|
There is somthing weird going on there, it doesn't seem to be handeling the analyzequery function. If you email me your active_users.asp page I will add a few diagnostics to it and send it back. Then I can get a better idea about whats going on/wrong. --> snitz@ls3k.com
 Nathan Bales
Snitz Exchange | Do's and Dont's |
|
|
|
mikey344
Starting Member
48 Posts |
Posted - 20 April 2002 : 21:19:23
|
I'll send you the file first thing tomorrow.
|
|
|
|
mikey344
Starting Member
48 Posts |
Posted - 21 April 2002 : 14:19:28
|
I sent it to you...I'll wait to here back from you to try the diagnostic file.
|
|
|
|
SPulley
Starting Member
USA
46 Posts |
Posted - 24 April 2002 : 02:36:39
|
I've been digging into this one for a few hours now.. I'm having the same problem. I'm using NT4.0 with SQL server 7.. The site traffic is load balanced across 3 servers accessing the same SQL database.
http://stage.mylargescale.com/forum/active_users.asp
From what I can tell, the problem isn't in the analyzequery function, nor does it lie in the Whatpage function, but higher than that. If I add:
response.write "Querystring = " & fQuery
At line 357 in active_users.asp where it is supposed to analyze the forum id comes up with nada.. Just "Querystring ="
Movin on up higher in the file,
If I add the following on line 186:
response.write "arrAM(6,c) = " & arrAM(6,c)
response.write "arrAM(7,c) = " & arrAM(7,c)
It yields this:
arrAM(6,c) = post.asp
arrAM(7,c) =
arrAM(6,c) = topic.asp
arrAM(7,c) =
arrAM(6,c) = forum.asp
arrAM(7,c) =
arrAM(6,c) = topic.asp
arrAM(7,c) =
arrAM(6,c) = active.asp
arrAM(7,c) =
arrAM(6,c) = Default.asp
arrAM(7,c) =
arrAM(6,c) = forum.asp
arrAM(7,c) =
arrAM(6,c) = topic.asp
arrAM(7,c) =
arrAM(6,c) = topic.asp
arrAM(7,c) =
arrAM(6,c) = topic.asp
arrAM(7,c) =
arrAM(6,c) = forum.asp
arrAM(7,c) =
arrAM(6,c) = topic.asp
arrAM(7,c) =
arrAM(6,c) = topic.asp
arrAM(7,c) =
arrAM(6,c) = active.asp
arrAM(7,c) =
arrAM(6,c) = post.asp
arrAM(7,c) =
arrAM(6,c) = forum.asp
arrAM(7,c) =
So, the entry in the array is empty.. Either you're calling the wrong record in the array, or your'e not putting the querystring in the correct space in the array.
Question.. Why are things getting moved into the array instead of coming straight out of the recordset? That slightly baffles me.. I'm no asp expert, but it seems redundant. It looks like you're trying to keep guests and members separate. Why not create 2 recordsets and populate the table out of the recordsets?
P.S. I really like the MOD.. It rocks.. Just a couple bugs to work out.
Have fun and be good!!
Shad Pulley
shadstrains@mylargescale.com
www.mylargescale.com/forum
Edited by - spulley on 24 April 2002 02:48:01 |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 24 April 2002 : 18:48:34
|
quote:
So, the entry in the array is empty.. Either you're calling the wrong record in the array, or your'e not putting the querystring in the correct space in the array.
Its never being pulled from the database. Is the querystring in the database at all??
quote:
Question.. Why are things getting moved into the array instead of coming straight out of the recordset? That slightly baffles me.. I'm no asp expert, but it seems redundant.
I'm using the getRows function, it can speed the script up by dumping the RS into an array and closing the RS quickly. I made a vesion of the file with this function removed, thinking it may be the culprit, and sent it to mikey344 but same result.quote:
It looks like you're trying to keep guests and members separate. Why not create 2 recordsets and populate the table out of the recordsets?
No, thats not the point. In fact, I couldn't combine those if I wanted to without some super fancy SQL.
I just dunno why this is affecting you guys an no one else. . . and what the heck is causing it. Are the querystrings actually in the database?? Are they not being extracted with the recordset?
Nathan Bales
Snitz Exchange | Do's and Dont's |
|
|
|
Topic |
|
Topic Locked
