Some one spammed my guestbook. how to remove all spam entries at once?

www.nellore.tv/guestbook

Comments

Ashford’s picture

I don't use GuestBook, but this has worked for me on other content.

Use the menu to select: administer > content management > content

All the content nodes will be listed. Then, you can use the filter at the top of the list [Show only items where] to find just the nodes based on content-type or category, whichever will narrow your results to just the GuestBook nodes.

You check mark the items you want to delete. Scroll back up to the [update options] list and set it to 'delete'. Submit. And, they are gone.

I recommend you look up the spam.module and the captcha.module for spam prevention.

saitanay’s picture

they donot appear anywhere in content. i use guestbook.module

www.nellore.co.nr - My tribute to my hometown

_dynamic’s picture

Same problem here. Anybody knows?

_dynamic’s picture

I found a way. Don't know if it's the correct one, but it worked for me. I went into the guestbook database table and deleted all the rows that had an id over a certain value. Used SQL
DELETE FROM `guestbook` WHERE `guestbook`.`id` > 12

...because I saw in the table that all the id:s over 12 were spam.

Then I had to empty the cache tables to see the result.

Blueeeeie’s picture

Did a short writeup on spam prevention modules for Drupal. Maybe this could help too.

http://drupaldiy.com/tutorial/preventing-spam-bots-your-drupal-site

---
www.drupaldiy.com - Showcase your Drupal site

beautifulmind’s picture

Use CAPTCHA to prevent spam.

:)
Beautifulmind

Regards.
🪷 Beautifulmind