User List and Registration Date/Time Stamp Issue

[codeshed]

We are running,

s2Member Pro
* Version: 1.5.8
* Stable tag: 1.5.8
* Framework: WS-P-3.5
s2Member
* Version: 3.5.8
* Stable tag: 3.5.8
* Framework: WS-P-3.5

It appears the timestamp for user registration is not showing up correctly as per my Time Zone setting within General Settings of WordPress. Is this a bug?

[Cristián Lávaque]

What timezone does it seem to be using? The server's? What's the offset you see between your setting and the time logged?

[codeshed]

7hours

[Jason Caldwell]

Thanks for reporting this important issue.

Yes, this is a bug. s2Member should be displaying that with date_i18n() for localized time. The time you're seeing is in UTC. I'm having this corrected in the next release. Thanks for reporting this.

@TODO :: Convert time displays to date_i18n().
http://codex.wordpress.org/Function_Reference/date_i18n

[IM Queen]

is this fixed yet? what can we do as a workaround till this is fixed?

[Cristián Lávaque]

http://www.primothemes.com/readme/3679/#rm-changelog

(s2Member/s2Member Pro). Time Zone. s2Member now displays Registration Dates in your list of Users with date_i18n() for localized time, as opposed to UTC time. UTC time is still the default time zone ( internally ), this is built into the WordPress® core. However, certain dates displayed on-site are easier to understand in localized time, based on your WordPress® General Settings.

[IM Queen]

oh Thanks! but I am not getting it.. My wordpress general setting is set to my localized time. However, the user registration times are getting stored in the db tables in UTC and are getting displayed in UTC when I click on the user list in wordpress dashboard. Am I missing something here?

[Cristián Lávaque]

What s2Member version are you using?

[IM Queen]

I am using Version: 110606 of S2Member free version....

[IM Queen]

any update on this?

[Jason Caldwell]

Thanks for reporting this.
Investigating now.

[Jason Caldwell]

Thanks for your patience.
Yes, this is a bug. I'm having this corrected for the next release.
Hopefully later this evening or tomorrow.

[IM Queen]

Thank you so much for looking into this Jason!! I am currently updating the timestamp in my db tables every night.. ha ha. I can wait for the fix though!
Thanks again!
You guys are doing an awesome job with this plugin

[Cristián Lávaque]

And thank you for helping improve it spotting that bug.

[Jason Caldwell]

Yes, thank you!
This was corrected in the release of s2Member v110620, now available:
http://wordpress.org/extend/plugins/s2member/changelog/

[Jason Caldwell]

* Note, please don't update the timestamp in your DB tables. All dates in your database should remain in UTC/GMT format, without any offset applied. This is how all of WordPress is intended to function. Only the display of the dates should be affected, not the way the dates are actually stored in the database. The latest version corrects the display, to account for a configured GMT offset properly.

[IM Queen]

Thanks! Just updated the plugin. Also, thank you so much for letting me know that the DB tables should be in UTC. I updated the tables back to the UTC one last time(hopefully) The dashborad now shows the user registration in my selected timezone Issue fixed!!

[IM Queen]

and one more, not sue if this thread is the right place to ask..
Can the user list be not sorted based on registration time? It looks like it is not sortable, but won't it make sense to have the sorted desc on registration time in order to see the latest users??

[Jason Caldwell]

Excellent. Thanks for reporting back.

and one more, not sue if this thread is the right place to ask..
Can the user list be not sorted based on registration time? It looks like it is not sortable, but won't it make sense to have the sorted desc on registration time in order to see the latest users??

Sorry, that's not possible yet, but I suspect it will become possible in a future release, as WordPress is being improved in this regard, so will s2Member.