Disable WordPress Trackbacks to avoid spam

I’ve intended to disable all comment or trackback functionality to avoid having spam and dealing with it in form of anti-spam plugins like Akismet. While I already had comments disabled, Trackbacks were still active.

Even when you disable Trackbacks in the WordPress settings via „Settings / Discussion“ under „Allow link notifications from other Weblogs (Pingbacks and Trackbacks)“, your existing pages needs manual update to take effect.

Connect to your MySQL database of your blog (e.g. with PHPMyAdmin) and execute these two queries:

 

I’ve found this information on Andreas blog, thank you!

WP-Sweep plugin helps you to clean up your WordPress data

Inspired by this tweet, I’ve decided to give WP-Sweep a try:

https://twitter.com/chemik3r/status/572127624346148864

WP-Sweep is a new WordPress plugin which only uses the official WordPress API to delete and clean up orphaned and unused data.

I’ve given it a try on my personal blog and it worked flawlessly. Unfortunately I’ve forgot to write down the exact percentages on what could be sweeped and saved but I have now a good feeling that at least my > 3000 blocked spam comments are finally gone 🙂

Don’t forget to backup your data, before you try this!