• Registered: 2010-09-18
  • Posts: 8

Topic: Delete all guest posts

My board got spammed with "guests" posting. None of the usernames of the "guest"s come up in user searches. I would ultimately like to delete all guest post from the forum (350 or so of them) but there does not a seem to be a way to do this in admin other than delete all the posts one by one. Any suggestions?

Maybe a mysql script to automatically delete all posts by "guests"? But i cannot seem to find the table to correllate  the posts with the "guests".  Can anyone direct me here?

Thanks.

  • KeyDog
  • KeyDog
  • Global Moderator
  • Offline
  • Registered: 2008-12-12
  • Posts: 1,693

Re: Delete all guest posts

hello

if you go to phpmyadmin
go to _posts
sort by id (1 is guest I believe)
then choose 100 or so at a time... you'll have them deleted in 2min....

  • Registered: 2010-09-18
  • Posts: 8

Re: Delete all guest posts

Thanks for the quick reply. I'll give it a shot.

  • Registered: 2010-09-18
  • Posts: 8

Re: Delete all guest posts

This is what I get:

mysql> select * from _posts where id = 1;
ERROR 1146 (42S02): Table 'punbb._posts' doesn't exist
mysql> select * from posts where id = 1;
Empty set (0.00 sec)

Any idea?

  • KeyDog
  • KeyDog
  • Global Moderator
  • Offline
  • Registered: 2008-12-12
  • Posts: 1,693

Re: Delete all guest posts

don't your tables have a prefix?

  • KeyDog
  • KeyDog
  • Global Moderator
  • Offline
  • Registered: 2008-12-12
  • Posts: 1,693

Re: Delete all guest posts

or check with group_id 2

edit: or poster_id 1 ....

  • Registered: 2010-09-18
  • Posts: 8

Re: Delete all guest posts

No, I didn't use prefixs....

The table "posts" seems to be the one i'm looking for, but it seems every guest has a different id.

  • From: Ukraine
  • Registered: 2008-10-31
  • Posts: 762

Re: Delete all guest posts

Or poster_id.

  • KeyDog
  • KeyDog
  • Global Moderator
  • Offline
  • Registered: 2008-12-12
  • Posts: 1,693

Re: Delete all guest posts

yes needs to be poster_id 1 .... sorry...

  • Registered: 2010-09-18
  • Posts: 8

Re: Delete all guest posts

Thanks for the help, I got itcleaned out. I've checked all the correct boxes in the Guest account, but it is still allowing guests to post. What am i missing?

11 Reply by KeyDog

  • KeyDog
  • KeyDog
  • Global Moderator
  • Offline
  • Registered: 2008-12-12
  • Posts: 1,693

Re: Delete all guest posts

→ Administration → Start → Forums

edit the forum they're posting too, to see if you have guest posting enabled....

  • Registered: 2010-09-18
  • Posts: 8

Re: Delete all guest posts

That was it, thank a million for your help.