|
|
Joined: Sep 2006
Posts: 13
stranger
|
|
stranger
Joined: Sep 2006
Posts: 13 |
ok, with 7.0.2, details for who's online would show me everyone, lurkers, users, etc.
with 7.1, it tells me something like "7 registered (Bryce, 2 invisible) and 10 anonymous users online." yet the details will show 1 person at the most...
have tried changing the build time, etc.. seems like something is missing?
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
I've seen this happen on one other install. It appears it's a problem with the query on certain servers since we switched the online table to a heap table. Need to figure out a proper fix.
|
|
|
|
|
Joined: Sep 2006
Posts: 13
stranger
|
|
stranger
Joined: Sep 2006
Posts: 13 |
thank you for the feed back.
|
|
|
|
|
Joined: Sep 2006
Posts: 13
stranger
|
|
stranger
Joined: Sep 2006
Posts: 13 |
just curious, is there any time frame for this?
Drives me nuts when I see it say "XX registered users online" and I click details and it only ever shows me 1 user.
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
I'm trying to figure out a fix for all users. It's something mysql version specific, and so far I haven't found a query that will match under all versions. As soon as I can then I'll get a fix out.
|
|
|
|
|
Joined: Sep 2006
Posts: 13
stranger
|
|
stranger
Joined: Sep 2006
Posts: 13 |
thank you for the update.
for some reason my members seem to be really concerned about this not working.. they don't seem to understand when I tell them it is a known issue and being worked on.. oh well.
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
I think I may have something that will work on all servers with the table change. I'll see if I can get something posted for a short term fix in the next day or two.
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Ok, it appears the only way to fix this is going to a LIKE query. You can edit scripts/online.inc.php:
Line 89 has:
WHERE t1.ONLINE_USER_TYPE = 'r'
Change that, to this:
WHERE t1.ONLINE_USER_TYPE like '%r%'
Next, line 196 has:
WHERE ONLINE_USER_TYPE = 'a'
Change that, to this:
WHERE ONLINE_USER_TYPE like '%a%'
|
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
I always figured it was a caching issue - when I clicked on the 'details' page it updated the cache and showed the correct info in the portal island 
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
This is something different. What you're referring to is caching. This problem on some servers would make it so when you went to the online page it would only list 1 user no matter how many were actually online.
|
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
You know, I actually ran into this issue on a server and shrugged it off as a caching issue... I don't even recall who's server it was on now that I think of it...
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
|
|
|
|
|
1 members (Ruben),
1,248
guests, and
268
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
