1

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 Feb 5 '13 at 18:45
  • You never said which error. That's pretty important when asking a Question. – brasofilo May 26 '13 at 2:59
4

This can be solved using the Bulk Edit WordPress functionality.

bulk edit

and

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? – Chathu May 26 '13 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 May 26 '13 at 2:57
  • I don't see Pings in Bulk Edit now, only Comments :( – sam Aug 26 '14 at 13:56
2

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, privacy policy and cookie policy

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