last_accessed is not updating

[TroyWolf]

I currently have 8 members in my system as we are setting things up and testing. Most have logged in and looked around. Some have come to the site multiple times over several days. I personally have 3 accounts I’m playing with. One is my real account and 2 test accounts to test membership levels and emails and such.

If I query my wp_swpm_members_tbl with this query:
mysql> select user_name, last_accessed from wp_swpm_members_tbl;

It returns the 8 members and only 1 shows a last_accessed date. All the others are 0000-00-00 00:00:00 as if never accessed.

I’d like to rely on this column to know if members have at least logged in once.

[mbrsolution]

Hi, I am not sure why that is happening. I have never tested this myself. Also in the Members tab you don’t have the login time period added to the tables. Maybe the following add-on might provide some help in regards to what is currently monitored by the plugin. Let me know if this does help you or not.

I will also submit a message to the developers to investigate further your request.

Regards

[TroyWolf]

Thanks for the fast reply!

I already have the “Show Member Info” plugin installed. I don’t know what you mean exactly by this:

Also in the Members tab you don’t have the login time period added to the tables.

[mbrsolution]

If you log into your website, navigate to WP Members -> Members. This displays your current list of members in your site. There is no field displaying the last time a members logged in. Perhaps in the future the plugin developers might add a field to monitor the last time a member logged in to the site. That is what I meant 🙂

Regards

[TroyWolf]

Thanks. I understand now. As I look closer at the “Show Member Info” plugin, I now notice that it does not include last_accessed as one of the available fields. (last_accessed_from_ip, but not last_accessed time)

So perhaps it’s known by the developers that this columns is not to be trusted.

HOWEVER, last_accessed time was stored for one of my members! I’d think it either works or is doesn’t!

ALSO NOTE — I now see a similar problem pattern with last_accessed_from_ip. Only 3 of my 8 members have a last_accessed_from_ip set. At least 2 of these that are missing the value I KNOW have logged in to the system.

I hope some others are willing to check their table to see if they see similar issue.

mysql> select user_name, last_accessed, last_accessed_from_ip from wp_swpm_members_tbl;

[admin]

I have applied a fix for this. The last accessed date will get updated correctly when the member logs into the site. Also, this value gets displayed in the edit member profile view (when you view the member’s profile from the admin dashboard).

This will go out in the next release of the plugin

[TroyWolf]

Excellent. I assume you addressed last_accessed_from_ip at the same time. I found this value was not always stored–same issue as last_accessed.

Thanks!

[Author]

Posts