Thread

Hello,

We were looking at the last_visit and last_activity columns in exp_members and can’t quite figure out how and when they get updated. Logging in/out multiple times and visiting various pages didn’t seem to consistently affect them in a pattern we can understand. Can you let me know the conditions under which these two columns get updated?

Thanks so much,
Matt

Hi Matt,

last_activity is written in the db at the start of a session. It is then updated every 5 minutes by default which may explain the inconsistency in your testing

If the user has been inactive for longer than the session length EE will update their last_visit item so that it contains the last_activity date.  That way, EE can show the exact time they were last visiting the site.

Take a look in system/codeigniter/system/libraries/Session.php for more on this

Does that help?

Thanks for your help, John Henry.

Session length defaults to 2 hours, right?

Hi Matt,

Correct. The default user session length is 2 hours and the default control panel session length is 1 hour.

Cheers

Greg