Bug found WOL problem caused by activity.php

[dchan]

Hi all,

In the process of troubleshooting a problem with our vbulletin installation, we found a problem with an external file that was causing our problem.

I have checked with our web designer who installed a modification that included a file called activity.php

I'm not sure he can remember exactly which mod included it and if it was supported after we began doing upgrades I suspect it was installed while we were still on VB 3.5.x We are currently on 3.6.2

The symptom was that every time the "most users online" record was broken the system would reset our counters to "1" and the date would be set to 1969 or 1970 depending on version of software.

We could reset the counter by running a query to reset the counter but the symptom kept coming back.

After working with the VB Dev group we found this line in the activity.php

build_datastore('maxloggedin', serialize($vbulletin->maxloggedin));

that was causing the problem. Correcting the syntax to

build_datastore('maxloggedin', serialize($vbulletin->maxloggedin), 1);

This did resolve the issue.

I also found the same info in "error" in try.php and am not sure where this file was used.

Hope that helps either the developers or users that might have noticed this symptom.

Thanks goes to the VB Dev team for helping me find and fix the problem on our forum and

Thanks to all you developers that keep coming up with these great mods..

Me, I'm just a hack trying to keep my forum running smooth..

DC

[Paul M]

Yes, this is a little known change between vb 3.5 and 3.6 - it's well known to me because it affected a couple of my released modifications.

[newbe_haselina]

Hi to all,
I'm working on this issue for hours ... and I can't get it fixed :cross-eyed:

I have a lot of non-vb files and files that seems to belong to 3.6.1 and not to 3.6.2 ... I'm totaly confused and I really don't know what to do further.

I deactiveted all my plugins, but the issue still stays on.

I ran the sql query several times ... but the counter keeps on showing 1 max user since 1.1.1970 after a refresh ...

can anybody help me? I think I'm slightly going mad ... :alien:

[Paul M]

What sql query did you run ?

[newbe_haselina]

Hi Paul,

thanks for the answer

For my unexperience the owner of the webspace and database told me, that we use 4.0.23. But I don't know where I can look it up?!

I looked up the table in the database and its kind of funny what is writte in there.

s:965:"1:956:"1:947:"1:938:"1:929:"1:920:"1:911:"1 :902:"1:893:"1:884:"1:875:"1:866:"1:857:"1:848:"1: 839:"< very long line removed>

It another post I found something totaly different to be written in there.

I'm appreciate your help.
Kind regards,
sabine

[newbe_haselina]

Another thing, that might has something to do with the issue ... When I look at the stats, it seems that the numbers of the online user per day are gone. (please see screenshot). I don't know if this is because of the same problem, but it might be?

Kind regards,
sabine

[Paul M]

Originally Posted by newbe_haselina

For my unexperience the owner of the webspace and database told me, that we use 4.0.23.

I don't think you understood the question - in your previous post you said ;

Originally Posted by newbe_haselina

I ran the sql query several times ...

I asked what query you ran, not what version of mysql you have.

Originally Posted by newbe_haselina

I looked up the table in the database and its kind of funny what is writte in there.

That looks messed up anyway, all those numbers should not be at the start.

Run this sql query to reset it all ;

UPDATE datastore SET unserialize = 1, data = ' ' WHERE title = 'maxloggedin'

[newbe_haselina]

Hi Paul,

sorry for getting you wrong ... *embarrassed* ... it's hard for me to talk about things in a foreign language I don't even understand in my native language :alien:

I run the following sql queries:

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

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

Excatly the same you told me to try.

The following happend.

1) Run your quere and the database table was empty. The online counter on my board was correct.

2.) Did a refresh, the counter changed to 1, and thats what is in the DB-table

s:61:"1:2:{s:9:"maxonline";i:22;s:13:"maxonlinedat e";i:1162731274;}";

3.) refresh again

s:69:"1:61:"1:2:{s:9:"maxonline";i:22;s:13:"maxonl inedate";i:1162731274;}";";

4.) refresh again

s:85:"1:77:"1:69:"1:61:"1:2:{s:9:"maxonline";i:22; s:13:"maxonlinedate";i:1162731274;}";";";";

It keeps up being messy again ... I guess even without refreshing the browser.

Any further ideas?

[Kidswap]

I'm having the same problem, and I'd love to hear a solution.

[Paul M]

Originally Posted by newbe_haselina

It keeps up being messy again ... I guess even without refreshing the browser.

Any further ideas?

You have a modification somewhere on your site that is screwing it up. You need to find it - and disable or fix it.