Jump to content


How can I change a "Join date" by a user?

Recommended Posts

You don’t? Not without manual DB modification. Which has inherent risks, not just in making the change, but in data integrity also. You have now, potentially, altered a static value that is always consistently relative with the SQL auto-increment value, member_id between members.

Out of curiosity, why are you looking to do this?

Link to post
Share on other sites
  • 1 month later...

I wouldn't mind doing this also, that is changing a member's join date. I initially set up my new IPS board and created a new admin. When I migrated my VB board over I then merged the wrong old account to the new admin account rather than vice versa. The oldest account, mine, now appears to be the youngest with the most posts etc.

Just chiming in to suggest that if such a simple database edit is safe I'm for doing this. Will wait until more feedback.

Edited by Christforums
Link to post
Share on other sites
  • 2 weeks later...

My community migrated from forumotion, which to no surprise to their notorious poor customer experience does not allow data transfers, so we let our members make new accounts on the IPB system.  Over the course of the first year and a half, we individually went in and manually edited member's join dates via the database to reflect their true stats.  We stopped doing it at the turn of this year because we wanted to focus on the growth of our current site and leave the old one behind.  We had about 4k active members at that time and we've not run into a single issue stemming from this growing up to 8k forward.  However, experiences are unique and I don't encourage anyone to do this unless you know what you're doing and you're willing to take the risk of malfunction regardless of what changes you're making to a database table, not just members.

I'm a little bumed out that Adriano now has a plugin for this, because that was not a fun time for me or my partner.  Having that much data on the table meant each page load it got slower and slower, and splitting the work just made it drag out even longer.  I'm glad you guys have an alternative now, a seemingly quicker and easier option, thanks to him.  I would have gladly paid $10 or more to avoid that headache.  😅

Edited by Alismora
Link to post
Share on other sites
  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...

Important Information

We use technologies, such as cookies, to customise content and advertising, to provide social media features and to analyse traffic to the site. We also share information about your use of our site with our trusted social media, advertising and analytics partners. See more about cookies and our Privacy Policy