Who's Online

[CorbinH]

We have just completed the upgrade from 5.2.1 to 5.4.3. without any major drama.
But we do have some questions, one at a time.
For the first time we are now getting an accurate account of who's online when activating the tab, however the first page does not show 10 visitors. Can anyone think of a reason why this is happening?

[Mark.B]

Go to AdminCP > Maintenance > Clear System Cache
Then reload the online page.
Does it show all ten now?

[CorbinH]

No, still showing only 2 visitors.

[CorbinH]

Even shut down and restarted forum, still only showing 2 visitors on the first page.

[CorbinH]

This is really weird for the first 16 pages it cycles through the same members on showing different members each time. It doesn't start showing 10 visitors until page 17 when it starts showing guests.

[CorbinH]

[Wayne Luke]

Edit the module and what is the number of users per page set to? Maybe increase this value to be higher than 2.

[CorbinH]

Where do I edit this module. I tried to edit via edit the navigation bar, but there was nowhere to set number of users per page

[glennrocksvb]

It's not in Navigation Bar. Go to the Online page and then click Edit Page, then click the Pencil icon in the Online module.

[CorbinH]

Thanks, will do.

[CorbinH]

Number of users is set to 10.

[Wayne Luke]

Are these people marked as invisible? Do you have yourself set to see invisible users (the default setting for administrators)?

You can adjust whether someone can set themselves as invisible in the Usergroup Permissions. Usergroups -> Usergroup Manager. Being able to see invisible users is set in the same location.

[CorbinH]

Yes, being an Admin I have set myself to see invisible members. That doesn't account for the strange results shown in post #3.

[Mark.B]

Been a while since I saw this issue on a site, but whenever I did, emptying the session table seemed to fix it.

You can run this query:

DELETE FROM session

This will remove EVERYONE from the Who's Online list, and then as people start to browse the site they will gradually reappear.
What I found was that at this point it started showing ten per page again.

NOTE: Never run this query on any other table unless instructed to by us. You will permanently break your site if you do.

[CorbinH]

How and where do I run this code?

[Mark.B]

You can run queries within the vBulletin Admin Control Panel by going to Maintenance -> Execute SQL Queries.

To run Queries in the Admin Control Panel you need to edit your /core/includes/config.php file and add your user ID to the Can Run Queries section. It looks like:

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '';

Place your user id between the single quotes.

[CorbinH]

I ran DELETE FROM session and it ran perfectly.
Thank you very much Mark.

[CorbinH]

We have just done a massive upgrade from 5.2.1 to 5.4.3. I suspect that we will have to run some of the maintenance programs to clean everything up.

Could you suggest what maintenance programs we should run and in what order, including the recommended ones at the top of the AdminCP page.

[Mark.B]

None of these will have any effect on Who's Online.
You may need to rebuild the search index but again that doesn't affect Who's Online and I'd get that sorted first...one issue at a time.

[CorbinH]

Exactly baby steps, and backup, backup, backup.

[Carrfixr]

All these issues are a common occurrence on my site. I have made support tickets for the members shown, but nothing was confirmable even with my screen shots. The page number error shown above also happens in thread view.

[CorbinH]

"You can run queries within the vBulletin Admin Control Panel by going to Maintenance -> Execute SQL Queries.

To run Queries in the Admin Control Panel you need to edit your /core/includes/config.php file and add your user ID to the Can Run Queries section. It looks like:

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '';

Place your user id between the single quotes."

I suspected as much, unfortunately even though I have Admin privileges they do not extend that far. I will have to contact the site owner and ask him to do it, or get a higher clearance.

[Carrfixr]

I’m on the cloud with a support ticket. They could have easily have ran that on their own back when I was addressing it. Right now I have so many other more important pressing issues I gave up. I hope you can get further with it at some point

good luck

[Mark.B]

"You can run queries within the vBulletin Admin Control Panel by going to Maintenance -> Execute SQL Queries.

To run Queries in the Admin Control Panel you need to edit your /core/includes/config.php file and add your user ID to the Can Run Queries section. It looks like:

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '';

Place your user id between the single quotes."

I suspected as much, unfortunately even though I have Admin privileges they do not extend that far. I will have to contact the site owner nad ask him to do it, get a higher clearance.

FTP access is what's needed to effect the change.

Or if you have access to the host's control panel, they generally have a tool for running database queries in there. Usually phpMyAdmin.

[CorbinH]

What are the consequences of entering the wrong user ID? The ID I need to enter is either 1 or 2.

[Mark.B]

I’m on the cloud with a support ticket. They could have easily have ran that on their own back when I was addressing it. Right now I have so many other more important pressing issues so I dropped it

They probably did, and it probably didn't fix it. I'm not suggesting it's a magic fix, but I know of at least three sites that ran into this and it did fix it. At least for a time. I would hazard a guess that even if it fixes it, it could recur later.