I have high Google Page Rank, and as a result of that, lots of spammers make trackbacks. Every day I have to delete them.

Will those trackbacks negatively affect my site's SEO? How can I disable all trackbacks on my site?

I have run the following code in my MySQL admin and using the WordPress Manage DB plugin, but it shows me an error.

UPDATE wp_posts SET ping_status='closed' WHERE post_status = 'publish' AND post_type = 'post';

UPDATE wp_posts SET ping_status='closed' WHERE post_status = 'publish' AND post_type = 'page';
  • I think you can solve this problem by reading the answer to this question. If it still doesn't work for you, then let us know.
    – Bart Karp
    Commented Feb 5, 2013 at 18:45
  • You never said which error. That's pretty important when asking a Question.
    – brasofilo
    Commented May 26, 2013 at 2:59

2 Answers 2


This can be solved using the Bulk Edit WordPress functionality.

bulk edit


editing bulk edit

Change the number of items to be shown in Screen Options, so you can select all posts/pages at once.

Two things worth noting in the Q&A pointed by @BartKarp:

  • There is the option to turn off trackbacks/pingbacks under Settings > Discussion.

  • it has a link to a plugin by @chrisguitarguy. If you want to implement total blockage of trackbacks, use chris'.

  • Thank you so much brasofilo. But I have more than 500 posts. Are there any quick method?
    – MaxBro57
    Commented May 26, 2013 at 2:49
  • Well, writing a custom routine to get all posts, iterate through them and update the info. But the time involved in writing, testing and finally doing it, would be greater than going through the interface. Change the Screen Options to show 50 or 100 posts at a time, and it will be a breeze. I don't recommend setting a greater value as it'd be too much overload to the server. Surely, you can find the correct SQL query and go through PHPMyAdmin.
    – brasofilo
    Commented May 26, 2013 at 2:57
  • I don't see Pings in Bulk Edit now, only Comments :(
    – sam
    Commented Aug 26, 2014 at 13:56

SQL Query

DELETE FROM `wp_comments` WHERE `comment_type`="trackback"

Run Query from this plugin: wp-dbmanager

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.