Archive for the ‘Site Related’ Category.

How to mass delete unapproved comments in Wordpress

wordpress.png

opinion.tuxtraining.com is(was) a separate wordpress instance as it really does have little to do with this site and I wanted a degree of separation.  I did not want user accounts at that site, nor did I wish to run ads.  It’s more for my own amusement than anything and definitely has nothing to do with Linux tutorials and howtos.

Well I neglected it for far too long, it did not have akismet installed , and so when I logged in I had 2000+ spam comments waiting for me.   Now I wasn’t about to delete 100 pages of comments manually one page at a t ime through the wordpress interface.

So this is what you do:

Log into your webhost and open up mysql, do a use <databasename> to switch to the appropriate database and issue the following command:

mysql> DELETE FROM wp_comments WHERE comment_approved = ‘0′;

Any comment that has not been approved will now be deleted.

Site Related: Updates for TuxTraining.com

tux.png

TuxTraining has gone through a few changes this past week.

  • OpenID now accepted when registering and posting on the site.  So if you have an OpenID from wordpress, AOL, livejournal, or many other providers feel free to use that to register and/or post.
  • By default all accounts will have the ability to contribute tutorials to the site.  Once you are registered and confirmed you can login and post your article by selecting appropriate categories. Once you post your article moderator need to review your article before publish.
  • Chat #tuxtraining on irc.freenode.net is now open.  It’s a bit of a ghost town but it will come with time.
  • Caching and compression features have been integrated to make your browsing experience faster.
  • Community forums now added.  While they’ve been a part of the site for a short while, the finishing touches have been done.
  • TuxTraining has also taken on it’s first official author other than myself who will be posting tutorials shortly.

Any problems, please let us know.