Previous Thread
Next Thread
Print Thread
Hop To
#265168 02/24/2022 4:29 AM
Joined: Jun 2006
Posts: 998
Likes: 25
Old Hand
Old Hand
Joined: Jun 2006
Posts: 998
Likes: 25
Hi,

I use 7.7.5 and I have been wondering a couple years why the Most online statistic is wrong on our forum.
Who is online setting is set for 10 min in CP and most likely we did not have 14,755 visitors in 10 min time. If we did it must have been a hell of an attack.

Dunno if this is an bug but I have to ask how to re-set the Most online to get rid of this high number?
Thanks for your advise.
https://www.britbike.com/forums/

Forum Statistics
Forums35
Topics75,508
Posts761,469
Members12,023
Most Online14,755 May 5th, 2019
[Linked Image]

Last edited by Morgan; 02/24/2022 4:38 AM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Apr 2004
Posts: 1,973
Likes: 154
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,973
Likes: 154
Originally Posted by Morgan
I use 7.7.5 and I have been annoyed since a couple years back that the Most online statistic is wrong.
Who is online setting is for 10 min and most likely we did not have 14,755 visitors in 10 min time. If we did it must have been a hell of an attack.

ON April 3, 2020, MORGAN WROTE:
Originally Posted by Morgan
First my WOL was set to 240min
I have now set it to 10 min
source:
https://www.ubbcentral.com/forums/u...online-is-full-sql-error-1114#Post263724

That thread by you also says that you were under DDoS attack. Looking at these numbers says that it probably was not the first time. This is why your numbers were high.


"max_online" is located in the CACHE table.
you can reset it to 0 by running this SQL from the SQL Command tool
Control Panel > Database Tools > SQL Command

edit -
corrected SQL is here:
https://www.ubbcentral.com/forums/u...-forum-statistics-most-online#Post265171

Last edited by isaac; 02/24/2022 5:30 AM.

current developer of UBB.threads php forum software
current release: UBB.threads 8.0.0 // wip: UBB.threads 8.0.1
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Jun 2006
Posts: 998
Likes: 25
Old Hand
Old Hand
Joined: Jun 2006
Posts: 998
Likes: 25
Issac, I knew I used 240min in the past for WOL, thanks for enlighten me that it was during this time period.

I tried
update ubbt_CACHE
set max_online = 0

and got this in return ( replaced the path with XXX

Script: /XXX/XXX/XXX/XXX/XXX/dodbcommand.php
Line: 83
SQL Error: Unknown column 'max_online' in 'field list'
SQL Error: 1054

Query:
update ubbt_CACHE
set max_online = 0

also tried
update ubbt_CACHE set max_online = 0
with same result

Last edited by Morgan; 02/24/2022 5:19 AM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Apr 2004
Posts: 1,973
Likes: 154
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,973
Likes: 154
Corrected SQL,

Reset WhosOnline stats
Code
update ubbt_CACHE
set CACHE_VALUE = 0
where CACHE_FIELD = "max_online"


current developer of UBB.threads php forum software
current release: UBB.threads 8.0.0 // wip: UBB.threads 8.0.1
isaac @ id242.com // my forum @ CelicaHobby.com
1 member likes this: Morgan
Joined: Jun 2006
Posts: 998
Likes: 25
Old Hand
Old Hand
Joined: Jun 2006
Posts: 998
Likes: 25
Isaac
that took care of it thank you very much! 👍 🙏


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
New Admin Here
by SenecaFlyer - 12/02/2024 4:14 PM
Post Counts zeroed out
by Baldeagle - 11/03/2024 3:05 PM
Who's Online Now
1 members (Ruben), 1,918 guests, and 54 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.1
(Snapshot build 20240918)