Who's Online Broken After moving server

[designgroop]

Greetings all!

 

 

I was recently forced to move server because of poor service. Having moved, I had to make a few changes to OSC as Mysql went from 4.x to 5.x. Once a few edits were complete, everything ran pretty much fine. I had a few issues with DNS on the server which impacted SSL - but these are all resolved.

 

The only thing that remains is a broken 'Who's Online' (whos_online.php) in the admin section. The problem is that:

 

1. Clicking on one visitor typically shows a correct page location but the shopping cart of another visitor.

2. When bots are online and no session is set in the db, they are somehow selected with other real visitors on the who's online page. By clicking on a visitor shown above the bot in the list, the bot is deselected. Clicking on the bot and then any visitor below will select them both.

 

However, once you have selected a visitor, a manual (browser) refresh of the page will give the correct information and selections.

 

Things that may affect this:

 

Globals Off - I have recently installed the register_globals off mod and it seemed to be working. I am currently trying to iron out issues with local php.ini configs. It looks like the new server won't allow local php.ini files and having just removed these, it's possible that this is actually the first time the site has tried to run completely without globals (ie. the globals off mod might not be working).

 

MySQL 5 - the new server has mysql 5, which wasn't compatible with my installation of OSCommerce. After the recommended changes, things seem fine - and I would expect to see an error if there was a problem.

 

I'm confident this issue isn't browser based; the css/js for whos_online.php hasn't changed in any way. I have tried on multiple platforms/browsers.

 

Both config files are set to use mysql for sessions. Sessions seem to be created and managed correctly in the db.

In the who's online page, the correct sessions are always selected in the URL, but the information returned is only correct upon refresh/first view of whos_online.php

 

 

I believe that some part of the 'onClick' query is causing the error - either because the query doesn't work due to different server spec or because it relies on Globals. Unfortunately, I have come to the end of my knowledge on this one and after trawling the forums for two days, I'm stuck.

 

Could someone who knows more about this file, please help me understand where it may be broken.

 

Looking forward to any assistance I can get.

 

Thanks all.

 

R.

[designgroop]

Can anyone offer any assistance on this?

 

I have been working with a friend to try to fix this, and he believes that the page gets the information for the previous user selected, not the current one. So the act of refreshing the page simply means the last query relates to the user currently selected.

 

He also thinks that the problem may lie in one of the classes.

 

It's looking more and more like a Globals issue, but at this stage, having made the changes listed in the Globals Off contrib, I don't know exactly where I should be looking.

 

This is a real pain.

 

Can anyone help?

 

Thanks.

 

R.