time date most members online problem

[paldo]

yesterday was a record day which changed my counter for most members online for a day .. it was showing 97 members for the record which was correct and the correct time and date til last night when the record got broke to 101 users now the display is shown


Most users ever online was 1, 01-01-1970 at 01:00 AM.

everything was fine til the record got broke then the above happens ?


anouther thing bugging me to death is the active users counter it is always 0 and shown nomater what the settings are .


Threads: 28,833, Posts: 33,366, Members: 2,030, Active Members: 0 :

[Jake Bunce]

Try running this query to reset the "most online" field:

UPDATE datastore
SET data = ''
WHERE title = 'maxloggedin'

Regarding the active users... check this setting:

Admin CP -> vBulletin Options -> Forums Home Page Options -> Active Members Time Cut-Off

...then rebuild your stats:

Admin CP -> Maintenance -> Update Counters -> Rebuild Statistics

[Ronin Storm]

Most users ever online was 1, 01-01-1970 at 01:00 AM.

everything was fine til the record got broke then the above happens ?

I've just had the same problem on 3.6.1 with the dataloss patch applied. Everything was working just fine, then that stat reset.

However, I have also noticed that on my host (1and1.co.uk) my database is running exceptionally slowly at the moment so I'm wondering if it's a problem caused by a database timeout?

Finally, I ran the query above, which resolved the issue for now (though I had to add my table prefix, of course).

EDIT:

Actually, the query fixed the problem just for a moment, but now it's back. Must have taken all of 2 minutes to revert... any suggestions?

[Jake Bunce]

I don't have this problem on my test forum. Do you have any hacks or plugins installed that might be interfering? If you don't have any hacks or plugins and you are still having the problem, then submit a trouble ticket with your forum and server info so we can take a look.

[Ronin Storm]

Thanks Jake. I've done some investigation and realised that one of my plugins does access that data, so the situation really isn't very clean. The weird thing is that I've used exactly the same plugin on a different vBulletin instance and haven't seen this issue. Still, as I've muddied the waters with plugins I wouldn't worry. I'll do some more investigation at my end and let you know if I have further issues.

[paldo]

thanks for the ideas its still jacked up but im looking into it done all the above and disabled a few plugins and still doing it ..if i cant get it fixed i will post again was fine til i upgraded.oh well i needed somthing to mess with anyways lol

[rolliet]

I am also having this problem. I will run the query and it will show proper until the next page refresh then goes back to Dec.31 1969. I have diabled the plugins and still have the same problem.

[al-baker]

run this query's

1-

update datastore set unserialize = 1 where title = 'maxloggedin'

2-

update datastore set unserialize = 1,data = ' ' where title = 'maxloggedin'

[The-Ensemble]

It says

#1146 - Table 'MY DATABASE'S NAME.datastore' doesn't exist

was I ment to substitue it or something?

[Steve Machol]

You need to add your table prefix in front of 'datastore' in those queries. This table prefix is listed in your config.php file.

[rolliet]

Nope I get the same thing. It will change the stat with correct date one time. After that you refresh and it goes back to Dec. 31st 1969

[al-baker]

try to do it from

cpanel

not from admincp

---------------
www.ursite.com/cpanel

after go to the mysql

then myphp

then choose ur db and run the query

[rolliet]

Same thing, it reverts back to 1969 after second refresh. I appreciate the help.

[al-baker]

check whith ur server.. maybe the problem with him
let thim to check the time&date

[al-baker]

clear the c o o k ies ... and empty the session table