Skippy.org.uk is quite an old blog, and while my 365 Blog is not as old; one of the things that is getting old is TrackBack Spam, Both Blogs are hosted on the same WordPress MultiUser / WordPress Networks install at JustVigilantes.co.uk.

WordPress makes it easy to turn off TrackBacks on all new articles in the Discussions settings page:

DiscussionSettings

however its not as easy to turn it off on all historic articles; and spam can get more than a little annoying:

Spam and comments

Yes I emptied it about half an hour ago. (may delete the URL from the Water Boat Man’s comment).

The only way I can think of turning the TrackBacks off is to change the settings in the database, this will be easer and quicker than going through all posts and changing the settings on them one by one,

  1. Find the username and password for your database:
    DealingWithTrackbackSpamThe username and password are stored in plain text in the ‘wp-config.php’ file in your WordPress install (This is mine (Yes I have NO idea why its a DOS formatted file)).
  2. with these settings hope that you have PHPMyAdmin installed on your server, if you don’t you have two options:
    • Type the commands at the MySQL terminal prompt
    • Install PHPMyAdmin on your server (copy and paste the files up via FTP / wget and unzip)
  3. Luckily I have PHPMyAdmin installed at //skippy.org.uk/phpmyadmin
  4. The commands that I want to use are:
    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';
  5. Opening phpmyadmin, I click on the SQL Screen Shot

And now hope that I have a lot less Comment Spam 😀