I deleted Members - How do I delete their posts ?

[Dav999]

Sorry, I wasn't really clear about the query part.

It's a database query, which you can run with phpMyAdmin, in the "SQL" tab after selecting your database (unless your host uses some other database manager which is unlikely). You also need to replace {prefix} with your database prefix (which is normally smf_)

After running it, all posts by deleted members and guests should have the username "Deleted", so you should be able to re-attribute all of the spam posts to one account to delete.

[Dave-user]

Hi again.

If possible, I'd like to save the board structure and upgrade to latest ... SMF 2.0.14.

ALL posts, members, pms etc can be gone. Just Board structure passed on to upgrade.

Is that possible ?

Does SMF 2.0.14 have anti spam tactics included ?

[Illori]

have you looked at https://wiki.simplemachines.org/smf/Spam_-_my_forum_is_flooded_with_spam,_what_can_I_do ?

there is no way to upgrade and not keep the posts members pm etc and keep the structure of the forum.

[Dave-user]

OK

So I have saved the text of the board structure and will
remove the forum from the server and re install SMF 2.0.14.

[Dave-user]

Un-installed the forum and

Installed SMF 2.0.14

But when I go to forum/index, I get and error:

Fatal error: Function name must be a string in /home/focus7/public_html/forum/Sources/Load.php on line 142

I have read the "readme.html" but doesn't give any clues.

Have others had this error ?

Thanks

[Steve]

Do it this way:

http://wiki.simplemachines.org/smf/How_to_upload_a_fresh_set_of_files

that will not remove the posts/messages/members, i dont think that is what the op wants.

I was talking about his post of uninstalling the whole thing and starting over. I knew it wouldn't do what he originally wanted. I should have quoted the post I was answering I guess.

[Sir Osis of Liver]

On second thought, you could retain members, pms, settings, anything not directly involving posts, by deleting or archiving all spammed topics in Forum Maintenance -> Topics.  You'd still have your boards, and once you have some anti-spam measures in place, you can finish cleaning up members.

Should have tried this.

Which php version are you running?

[Dave-user]

Hi,

Maybe I misunderstood - but when I saw "there is no way to upgrade and not keep the posts members pm etc and keep the structure of the forum."

It seemed that there was no solution and therefore the best thing to do was to install a new forum.

This is what my dedicated server is running:

Operating system   CentOS Linux 6.9   Perl version   5.010001
Path to Perl   /usr/bin/perl   BIND version   9.8
Postfix version   2.6.6   Mail injection command   /usr/lib/sendmail -t
Apache version   2.2.15   PHP versions   5.3.3
Webalizer version   2.21-02   Logrotate version   3.7.8
MySQL version   5.1.73

Thanks

[Illori]

you need to upgrade to php 5.4 or higher.

[Kindred]

You are running some seriously outdated server software

[Dave-user]

May be I will just give email support instead of offering a forum.