Howto:Turn off trackbacks and pingbacks on existing WordPress Posts to prevent spam

Howto:Turn off trackbacks and pingbacks on existing WordPress Posts to prevent spam

WordPress has built-in capacity to send and receive pingbacks and trackbacks. Most of the blogger are annoyed because of this. Now day’s people use the automated tool to promote their blogs, these automated tools send irrelevant trackback to the websites. At itinfoz i receive about hundreds of trackbacks spam weekly so to stop these kind of black hat technique  First thing I did was Disabled trackbacks and pingbacks from the Settings » Discussions page. Now the setting will work for the new post only and there are 100’s of post on my blog, making the new setting does not change the status on existing posts.

Turn off trackbacks pingbacks 300x161 Howto:Turn off trackbacks and pingbacks on existing WordPress Posts to prevent spam

How to disable trackbacks and Pingbacks on existing WordPress posts?

Many spams can get through in the form of trackbacks or pingbacks .below is the simple feature which can be used to entirely turn off trackback and pingback from your WordPress blog.

Disabling Trackbacks and Pingbacks:

  1. Login to your Cpanel and then go to phpMyAdmin control applet then make a backup of database so we can restore the backup anytime, in case if you have to revert back. Now locate and select your WordPress database on the left from the database dropdown list.
  2. Now time to select the SQL tab from the navigation tabs at the top, Within the Run SQL Query box add the following code and click go: Update wp_posts set ping_status=”closed”
  3. Or execute the following query for old post:
 

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’;

 

That’s it, you are done.  Now onward all of the existing published WordPress posts will have trackbacks disabled.

Note: If you get an error just check your Database prefix on wp_posts from the database list and change the code accordingly.

 

2 comments


Leave a comment

CommentLuv badge
What is 3 + 2 ?
Please leave these two fields as-is:
IMPORTANT! To be able to proceed, you need to solve the following simple math ( Sorry! this effort has been applied to stop spamming) :-)
Read previous post:
Adobe: Vulnerability having to pay for “Critical Update” in CS5

 Adobe Photoshop CS5.5 has Critical Security Vulnerability Opposing to reports that Adobe had suggested, users should pay for an upgrade to CS6 to patch a...

Close