Archive for February, 2009

Funny Characters Showing Up In Wordpress Posts!

no comments

This week as I was migrating my Wordpress installs to a new host, I noticed that all of my posts contained funny ‘Â’ characters where newlines should be.   Why was this happening?  How did I fix it?

Read the rest of this entry »

February 27th, 2009 at 5:05 pm  

Posted in Databases, PHP, Webmastering

Advanced Foreign Key Usage in MySQL

no comments

A few days ago I made a post explaining the basics of foreign keys in MySQL. Today I’d like to flesh out the subject by going a bit deeper into their usage.

Read the rest of this entry »

February 25th, 2009 at 10:00 am  

Posted in Databases

Using Foreign Keys In MySQL

no comments

Foreign keys in MySQL can be a little scary if you’ve never used them before.  They do provide some great benefits however and should be a tool in any DBA’s arsenal.  In this article I go through the basics of Foreign Keys in MySQL with examples!

Read the rest of this entry »

February 23rd, 2009 at 11:14 am  

Posted in Databases

Joomla Content Suddenly Stops Showing Up

no comments

This afternoon at work I got a call from the boss letting me know that our website was down.

Down? I think one of my nagios alerts would have let me know about that!

Ok he says, not really down, it’s just not showing content.

Having a look, the template was showing up fine but the spots where articles should appear were coming up blank.

What was the problem?

Read the rest of this entry »

February 3rd, 2009 at 5:15 pm  

Posted in Webmastering