Wo1f wrote: At minimum, even when a user has NOT been activated, there are 3 tables to clean properly. They are the "user_group" and "groups" tables, aside the "users" table.
Even when an activated member has no topics or posts, he might of created "pm" or "topic watch" activites and so on and so forth.
It's been said many times that deleting any users in any state through the "users" table only is just not a good idea, with potential "permissions" problems that may not necessarily manifest themselves now, but may cause headaches down the line.
Hope this is helpful,
OK, Roger that. Glad I asked.
So now I got to figure out how to fix it. I am guessing I need to check the list of user_ids in "users" and look for the gaps, some of which are due to my correct deletion, some due to my ham-handed phpMyAdmin deletion. Then I would have to go to the "groups" table, where there are both "group_id" and "user_id" fields. Since the group_id field has bigger numbers, so I am thinking that I would manually delete fields based on the "user-id"s that are present in user_group but not in users.
But I should also make a note of the "group-id"s I am deleting in user_group since the groups table uses the group_id field as the primary key, and the numbers there go up to higher numbers than my "user_id" numbers. So in user_group table I should delete the same "group_id"s that I deleted in the groups table.
Is this correct, or I am I just risking creating a bigger mess? We have about 1000 registered users, and I only deleted about 20 or so through phpMyAdmin, and those were only within the last week.
I am a little concerned because in the user_group table, I have a bunch of "user_id"s that have more than one "group_id"s