| Author |
 Topic  |
|
|
Devastator
Starting Member
3 Posts |
 Posted - 15 August 2002 : 12:44:59
|
Well, I decided to do some house cleaning and delete a bunch of 1 time posters and very old accounts. Now I have about 80 n/a in my members list. I used the "Delete User's Posts" MOD to delete their posts.
Here is the question. Can I go through the FORUM_MEMBERS table and delete their records with out it causing problems? I am using MSAccess. Or is there a MOD or another way, that will remove these?
I wonder if the "Delete User's Posts" MOD removed their posts from the archives. |
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 15 August 2002 : 13:03:49
|
When a user who has made one post or more is deleted you'll end up with N/A as the username. Deleting their posts should solve that problem, but you'll have to delete those posts before you delete the member.
The problem with the Delete Users Posts MOD is that it also removes posts that were the first of a topic, and thereby the entire topic including the replies.
To be honest I don't know if that MOD removes posts from the archives, but that could very well be the cause of the problem.
Deleting the member's records directly in the database would mean also deleting their posts in the archives. If you leave a post, you'll get an error on the page when someone tries to view it: the member doesn't exist, so its information can't be found.
I always advise to only delete those members that haven't made any posts and have not been active for a certain amount of time. The others should be locked. That'll take care of a lot of problems that you'd get when you delete them. |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 15 August 2002 : 13:08:00
|
| Well if they have no posts and if they are not moderators and do not have subscriptions or are part of an allowed member's list forum, then deleting them should cause no problems, but only if all these conditions are met (and I'm not sure that I'm not forgetting something)... |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Devastator
Starting Member
3 Posts |
Posted - 15 August 2002 : 18:44:59
|
Thanks guys, I figured it was more than just topics and replies. I think I will play it safe and just leave it alone. It's not bad anyways,
Thanks,
-Dev
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 15 August 2002 : 18:51:23
|
| I guess when 3.4 comes out someone can write a mod to leave the user's name on, even when the user is deleted. It should be a simple change, although I haven't looked at that code yet. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
Topic Locked
