HOWTO: Regenerate Gravatars in WordPress

by @edent | # # | 1 comment
The Logo for WordPress

A troublesome plugin recently corrupted some of the avatars on my blog's comments. This is a quick HOWTO for regenerating them. Gravatars are based on the MD5 hash of a user's email. For some reason, the plugin had overwritten the avatar field with the text http://identicon This MySQL query finds all the comment IDs which…

Continue reading →

Open Source Shakespeare (in MySQL)

by @edent | # # # # # | 11 comments | Read ~1,466 times.

My good friend Richard Brent has often complained that my blog has very little Shakespeare content. Despite the domain name, I don't think I've ever blogged about The Big S. For shame! Fear not, my Brentish-Boy, this post is all about Shakespeare. And MySQL.... Ahem... When I first started shkspr.mobi it was intended to be…

Continue reading →