The reason why I have quite a few people in my ban list that never activated is because I have found that by monitoring the registrations made on certain sites the same usernames tend to do the rounds. The banning is a pre-emptive strike against a spam post that I know is going to come. Additionally, you can often tell just by the username and what was used in the registration fields if a person is a spammer or not. So it is not weird at all.harknell wrote:Ok, let me see here. This mod is designed and limited to deleting people who have an unactivated account and NEVER activated it. This is on purpose to prevent users who may have temporarily been deactivated from being deleted by the mod.
While I can imagine that you might decide to ban a user who never activated their account, this seems a bit weird to me since how would you know they were a spammer if they never posted anything (since presumably you don't allow non-activated user to post to the forum). So anyone on a banned list is almost certainly normally going to be an activated user at some point, so the mod doesn't apply to them and wouldn't delete them by design. The mod is mostly designed to blow away in one shot the large numbers of spammer registrations that get done all the time by bots but never get activated.
I'll probably post the 2.0 version for publication now that things have returned to normal here.
Are you saying this mod does not complete delete them from the database? If i delete someone who has zero posts then i want them deleted completely. Normally if someone has made posts that arent spam and I am keeping the posts, then i wont delete the user because i dont want to the post to become attributed to 'guest'. So in that case i ban them. I've been using this mod for a while now to delete the unactivated users. I hope there's not bunch of junk left over in the db due to this.Nothing is easy wrote:The point I raised in my question about what you delete is entirely valid.....you should be doing a complete clean up of the userid from all relevant database tables and not just a part database deletion job of their userid based on your incorrect assumption - as it will indeed delete them partly from the database and not entirely.
Code: Select all
Failed to Expire Accounts, could not get user data of unactivated accounts
DEBUG MODE
SQL Error : S0022 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name '1213797931'.
SELECT user_id FROM bb_users WHERE (user_active = 0) and (user_id <>-1) and (user_lastvisit = 0) and (user_regdate < "1213797931")
Line : 61
File : admin_expire_unactivated.php
I'm still having this problem. I thought this was the forum where we go to get help with this mod?MIGhunter wrote:I just installed this last night and when I tried to run it, I get this error:Any idea what might be wrong and what I need to do to fix it?Code: Select all
Failed to Expire Accounts, could not get user data of unactivated accounts DEBUG MODE SQL Error : S0022 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name '1213797931'. SELECT user_id FROM bb_users WHERE (user_active = 0) and (user_id <>-1) and (user_lastvisit = 0) and (user_regdate < "1213797931") Line : 61 File : admin_expire_unactivated.php