MySQL 4.0 the Cripple

I started FreeRingtoneHeaven.com a couple years ago back when GoDaddy was still running MySQL 4.0. Until now it hasn’t been a problem because I never needed to deal with DATE fields. But, now that I’m going to be developing and managing a link system I need to be able to show stats based on the date that a click/impression/etc happened on.

Now that I think about it, my guess is that instead of using the DATE() function you’d have to cast the DATETIME field as a DATE field to group by the date.

So, today I finally moved the old FRH database from 4.0 to 5.0. GoDaddy recently upgraded. They don’t even offer 4.0 anymore. That’s how long FRH has been around. I’ve been running 5.0 on my dev boxes for at least a couple years now. This move will make it easier to add new features to FRH.

I don’t think I’ve made any serious changes to FRH for at least a year now. The last update was to add voting. Now with my handy dandy local copy I can pretty up the link program site and maybe touch up some pages that are a little homely looking like the Top Searches page.

Leave a comment

You must be logged in to post a comment.

ss_blog_claim=70b9168863fc97c91e6d88b40542a327 ss_blog_claim=70b9168863fc97c91e6d88b40542a327