The Cheltenham Festival for 2012 is but 4 weeks away now, so those of us who, like me, enjoy watching occasional horse racing – not the committed armchair punters, though – will be thinking about betting on horse racing when we don’t really watch it that often otherwise.
I was wondering who was going to win this year’s Champion Hurdle.
Turns out, there’s a long odds-on favourite, and a lot of long priced alternatives, in the antepost market.
I’ve said it a few times, and I’ll say it again: it is rare, if not impossible, to get something of value for free.
If you get it for “free” chances are either a) you will be paying for it, just not directly; or b) you got given it by something or somebody genuinely benevolent.
So, can you get a UK Roaming Number for Free?
No.
You can’t.
Somebody set the press releases free! Please!
They are tied up, held, locked in, trapped.
Somebody needs to set them free.
The press releases should be flowing, like water, down the channel into the journalists’ eyes.
The press releases should be pouring into the minds of consumers and investors.
Click the following link -> Submit free press releases.
A lot of people want to know how to remove the little bit of information that says “Posted By:…” on WordPress.
Well, in this “How To” post for today, I will tell you just how to remove that irksome bit of text.
Now, the first thing to remember about WordPress is that it very much depends what theme you are using, how things are laid out, but, assuming you are using something standard like the WordPress Twenty Eleven theme, then the code you need to remove is in the file content-single.php.
To edit that file, add the following to the end of your blog’s root URL:
wp-admin/theme-editor.php?file=%2Fthemes%2Ftwentyeleven%2Fcontent-single.php&theme=Twenty+Eleven&dir=theme
You should find any instance of
by <a href=”%6$s”>%5$s</a>
and remove it.
That will remove the “posted by” part in WordPress for this theme.
Please note that, if you upgrade your theme, your edit will be overwritten by the new theme file – and you’ll have to do it again. Ideally, you should use “child themes” to overcome this, but I’m assuming you might not be able to achieve that if you are google searching the topic we’re talking about right here.
If you have any problems, leave a note in the comments section, below.
If your WordPress database is looking on the large side, and you’ve noticed that the “wp_posts” table is bigger than the amount of actual posts you have, then maybe you might like to run a quick query that deletes all of your post revisions from the WordPress database.
The following SQL query did just that for me on my WordPress installation, when I ran it in PHPMyAdmin:
DELETE a,b,c FROM wp_posts a LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id) WHERE a.post_type = ‘revision’
Remember to backup your WordPress database before running any SQL query on it. Also, while this worked for me on my setup, it might not work for you on yours. Leave a comment below if it works for you.
Now, if you’re a blogger like me, and, like me, you use WordPress to run that blog, you might have come to a time when you needed to remove a lot of posts, or a lot of categories or tags.
If you did so using SQL, you might have ended up with a lot of no longer relevant “Term Relationships” in your WordPress database. I did, and when that happened, I needed to run a little SQL Query to delete all non-needed bits of data from the “wp_term_relationships” table.
Running the following query in PHPMyAdmin worked for me:
DELETE tr FROM wp_term_relationships tr
INNER JOIN wp_term_taxonomy tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id)
WHERE tt.taxonomy != ‘link_category’
AND tr.object_id NOT IN (SELECT ID FROM wp_posts);
Remember to backup your WordPress database before you run anything like this. Also, please remember, while this worked for me, on my setup, it might not work for you on yours. Leave a comment below if this helped or didn’t help you this time.
On a blog that runs on WordPress, sometimes you can end up with a lot of tags which are no longer used – for example if you just deleted a whole heap of posts.
You might want to free up a little space in your database.
You might want to sort the wheat from the chaff, tag wise, on your blog.
Maybe you’ve been running a popular blog, with many authors, for many years, and you have thousands of tags that aren’t used, floating around in a bloated database.
Whatever your reason for deleting unused tags from your WordPress database, the following SQL query will help you to get rid of them super fast from within PHPMyAdmin:
DELETE a,c
FROM
wp_terms AS a
LEFT JOIN wp_term_taxonomy AS c ON a.term_id = c.term_id
LEFT JOIN wp_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
WHERE (
c.taxonomy = ‘post_tag’ AND
c.count = 0
)
Please remember to backup before running any queries on an active database, and note that, while this works for me, it might not work for you – if it breaks stuff, don’t blame me! Leave a comment below if it works/doesn’t work for you.
For some reason, Akismet, and other WordPress plugins leave comment meta lying about from comments which have been deleted.
This can lead to a whopping wp_commentmeta table on blogs which are on the larger or more popular side (like this one 
)
So, what you can do, is jump into a program like phpMyAdmin and run a simple SQL query to remove all the data from wp_commentmeta which relates to no longer present comments, using the following SQL query:
DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments);
Don’t forget to backup your database first, in case you break something. This works on my setup, but might not work on yours. Leave a comment below if it works / doesn’t work.
Sometime on WordPress, you have to delete a lot of posts, or post revisions, or something else, on the fly, using SQL.
If you have done this recently, and have left a heap of now orphaned – or useless – data in the postmeta table, the following SQL query may well help you to remove that data for all the posts which no longer exist:
DELETE pm
FROM wp_postmeta pm
LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
WHERE wp.ID IS NULL
Remember always backup before running SQL queries on a live blog – or you might find you are left with unintended consequences! The above might not work on your setup.
Leave a comment if it works / doesn’t work, below.
The internet, sometimes, seems like a crazy place, full of crazy people.
At least that’s what it seems like when you read my blog (this website), isn’t it?
Not really, but it is confusing, and alarming, and a little distressing that websites like this one exist at all. It is also more than a little frustrating that this website is more popular than most of the other important things I have ever done.
However, having said all that, this popularity does allow me to point people towards short stories, which I am very proud of.
Sometimes, people will even read those short stories, and be delighted by them.
Which is kind of the point.
You have to turn over a lot of stones to find the golden woodlouse.