Question [Merged topic] Can we delete all posts by a user?

Our job here is not to shame anyone. We try to remember, when we write what we do, that there's a helluva lot to learn about website administration and we're really only scratching the surface in this discussion forum. I'm not surprised that some of the less-obvious features of Kunena don't get "marketed" more vigorously. If we were to list every feature available in Kunena we'd be just as likely to deter new users as we would succeed to attracting them. So, as often is the case, some of these lesser-known features lie waiting for you to discover for yourself ... and for us to, helpfully, point them out if you didn't know they exist.

The best reward that we can hope for is to receive the occasional "thank you" like you have done - we do appreciate the thanks - and if you can spare a few extra minutes to write an honest appraisal of how you feel we're going at the Joomla Extensions Directory , so much the better. The honesty in the JED keeps us on our toes.

I'm really pleased for you and I'm glad that we were able to help.

Regards,

sozz

By searching this forum i now know that there is no easy way to delete one user all posts. i had one spammer today who quickly posted hundreds of posts.
Maybe there is any hard way?? database edits etc?? anything?
thanks

Hello,

It's possible to do that in kunena 1.6, but in kunena 1.5 you need to delete the messages manually in database via phpmyadmin.

Thanks!
I dont know alot about databases, but not afraid to experiment
Which table holds user posts?

I found jos_fb_messages_text which contains all the posts but is someone could help by explaining how to delete certain records

Hang on a second: are we talking literally hundreds of posts or even one hundred or maybe only a dozen? Before we go tearing off into the great wilderness of SQL database tampering, let's put this problem into some kind of perspective and, for goodness sake, let's not over-react!

I've merged this topic with one another one that took place only a couple of days ago and, in that case, we were able to reassure the user that there are a few painless remedies that he could use. I think you will find those ideas useful to you.

Spammers, generally, do not post "hundreds of posts" at the one time, nor do they usually create hundreds of new discussion topics ... well, not unless you make it really easy for them to do it, anyway.

But, let me state, in a clear and firm manner, we do not recommend to our users to mess with their SQL database. See How To Destroy your forum data...

yes at that time there were about 600 spam posts. this spam was just a bunch of random letters with no real links to any site. We had to get rid of them fast. splited between few of us and deleted one by one... today again one spammer posted 80posts at night before we noticed. deleting one by one is a nightmare. we have to have sme option to delete all user posts.