Page 1 of 1

KCME User Account Cleanup

Posted: Tue Nov 20, 2012 11:22 pm
by KangaMINI
Hi Everyone,

Just want to get a feeling for your thoughts on this. There are a lot of inactive/never used accounts on this system. What are your thoughts on purging some of these old accounts? There are some that haven't ever logged in after their initial account creation, and some that haven't been used in over five years. I think its probably time to clear out some accounts, but I wanted to run it through y'all first.

Thoughts? Cutoff suggestions?

Re: KCME User Account Cleanup

Posted: Wed Nov 21, 2012 9:01 am
by Hagar46
Is there any way to notify members that their inactive account will be closed? If so, I suggest one year cutoff.

Re: KCME User Account Cleanup

Posted: Wed Nov 21, 2012 6:31 pm
by IowaM1N1
Hagar46 wrote:Is there any way to notify members that their inactive account will be closed? If so, I suggest one year cutoff.
That's a reasonable solution, I think. Depending on how many stale accounts are out there at the 4+ year timeframe, maybe we set the first clean-up threshold out a little further than 1 year. If there are a ton older than 4 years, cull those first.

I'd hate to alienate someone who signed up a year ago and just hasn't gotten into the habit of accessing the board yet. Four years? There's little chance they are coming back.

Re: KCME User Account Cleanup

Posted: Mon Nov 26, 2012 8:50 pm
by S-car-go
I think it's a good idea Gregg. This would give us a better way of keeping track of active members and have a ballpark number of many strong the KC Mini Club is. Plus, anyone who gets purged could always set up a new account. Just my two cents.

Re: KCME User Account Cleanup

Posted: Mon Nov 26, 2012 11:20 pm
by KangaMINI
Fun Facts:

There are 65 people who have created accounts but never logged in with them, 47 are older than 365 days.
103 accounts have not logged in for over 4 years
20 accounts have not logged in between 3 and 4 years
58 accounts have not logged in between 2 and 3 years
20 accounts have not logged in between 1.5 years and 2 years
28 accounts have not logged in between 1 and 1.5 years

136 accounts have logged in within the last 365 days

phpBB has a utility which will allow me to either deactivate, or delete accounts which meet certain criteria. For example, I can delete accounts based on their last active date in mm/dd/yyyy format. So it would be relatively simply to nuke any account that hasn't logged in since 12/1/2010 or whatever.

What I can't figure out is why a dump of the user table directly from the database only yields 365 accounts and the forum reports 586 accounts. :shock: