WordPress has the ability to receive and send pings/trackbacks from and to other sites. At WPBeginner we receive hundreds of spam trackbacks daily. In the past due to our theme structure, we had the trackbacks hidden however now when using livefyre we ran into the problem of having trackbacks and pings showing below our posts. First thing we did was disabled trackbacks and pings from the Settings » Discussions page. However that does not change the status on existing posts. In this article, we will show you how to disable trackbacks on existing WordPress posts.
This tutorial requires you to run a MySQL query, so we highly recommend that you backup your database before executing the query.
First, you need to login to phpMyAdmin and locate your WordPress database. (Below is a screenshot of a HostGator cPanel)
You need to click on the SQL tab:
And execute the following query:
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’;
And you are done 🙂 Now all of your existing published WordPress posts will have trackbacks disabled as well.