Saturday July 13th 2013
at 8:56 AM
WordPress is a very database centric Content Management System, and like most systems the SQL database can be the best way to achieve a quick solution to an otherwise long and boring repetitive task. Here’s one of those tasks. I needed remove all the old thumbnails, due to bad sizing and thumbnail improvements. However I have over 100 posts, so I’ll be damned if I’m going to manually go through the WP dashboard and do it. Here’s a quick and easy way to kill all the thumbnails quickly via SQL
DELETE FROM wp_postmeta WHERE meta_key = '_thumbnail_id'
This will remove all thumbnail references on all posts and has_post_thumbnail() will return false.
If you needed to run this on a specific set of rows, you’d need to use an AND clause at the end of the above SQL
Note: Always run SQL commands like this on a testing server/localhost installation and have backups ready!
Friday July 12th 2013
at 10:50 PM
So recently I’ve relaunched my blog, with that came A LOT of offline time (busy with irl etc etc). I develop various projects on localhost environments but one thing that doesn’t play nice with localhost is Disqus comments. This is because it requires a live top level domain with the correct permalinks to each post (or discussion in this case), so of course while my blog was under development this got quite badly out of sync and started to slowly break. Putting my blog back online and chaos ensued on the comments front, its getting back to normal now, but I had quite an adventure solving some interesting quirks.
Read more →
Friday November 20th 2009
at 8:38 PM
Ubuntu 9.10 since it’s release has caused quite a storm in the linux community both good and bad. While Ubuntu 9.10 is the latest and greatest release of the Linux distro there have been a few slight issues with Ubuntu 9.10. One of the problems I’ve had with the Ubuntu 9.10 is with a package called mscorefonts. This package contains Windows fonts such as Arial and Impact that are used in such programs such as Wine, the Windows compatibility layer that allows you to install and run windows applications in Ubuntu.
Read more →
Wednesday November 4th 2009
at 7:40 PM
If your someone who doesn’t always use Windows then chances are your a Linux user too. Linux with it’s many distrubutions and open source lovelyness has recently seen the popular distribution Ubuntu hit the 9.10 mark with it’s latest release called Karmic Koala! I’ve only been using Ubuntu since 9.04 and only for a few months but Im finding it really fun and a great alternative to Windows, especically when Windows is in one of those ‘doze’ moods and decides to do everything but the command you give it. Here’s my upgrade experience and my overall opinion on the new release
Read more →
Saturday September 19th 2009
at 12:45 AM
Well I haven’t blogged in a while and thats because I’ve been busy with personal things, but because this blogs about everything but myself here’s my latest happening in a blog post. Im sure you’ve all heard about Windows 7, Microsoft’s brand new operating system which has been through it’s BETA and Release Candidate stages and is due to be released to the public on 22nd October, but because of my college and it’s partnership with Microsoft Software Development Network and the MSDN Academic Alliance. I was able to get my hands on a genuine copy of Windows 7 Professional and had some time to install it onto my Compaq Presario Laptop.
Read more →