User stays permanently on line

[EuroBeat2]

Recently I had glitch on my server (year date was change from 2009 to 2010). At that time one user was on line. After fixing the error now this particular visitor is showing under "Currently Active User". I checked his setting and it says that he was last time on line couple days ago.

How can I reset cache for this user? Is there anything I should do in DB? It might be that somewhere in system this user has date from 2010 and now system register this user as being on line. Any help will be appreciated.

EB

I am using VB 3.8.4.

[Adrian Schneider]

Try running these two queries:

Resets his last online time

UPDATE user
   SET lastvisit    = unix_timestamp() - 86400
     , lastactivity = unix_timestamp() - 86400 
 WHERE userid = X;

Deletes any session he has, probably not required

DELETE FROM session WHERE userid = X;

Change X to his user ID.

[EuroBeat2]

Originally Posted by SirAdrian

Try running these two queries:

Resets his last online time

UPDATE user
   SET lastvisit    = unix_timestamp() - 86400
     , lastactivity = unix_timestamp() - 86400 
 WHERE userid = X;

Deletes any session he has, probably not required

DELETE FROM session WHERE userid = X;

Change X to his user ID.

Thank you. Worked perfectly. I needed to use also the second query, first didn't do the job. Much appreciated!

EB

[Adrian Schneider]

Yes - there or the MySQL shell, or phpMyAdmin (etc.)

If you do it through the Execute SQL Query page, you'lll have to add your own user ID to includes/config.php. One of the settings there will mention being able to run queries.

Run the two queries separately, too.

Cheers