Greg’s Blog »

Archive for the 'Coding' Category

I’m doin’ a Postie test.

November 14th, 2007 | Category: Coding, From the Field, Test

So, here¹s the deal: I¹ve got apostrophes in the title, and this is an html format email.
BOLD BIG COLOR FONT What did all that do? How about a link: http://www.yahoo.com
So, that¹s all!

Close Bookmark and Share This Page

Save to Browser Favorites / Bookmarks

Email This to a Friend

Copy HTML:

If you like this then please subscribe to the RSS Feed.

1 comment

Postie is a WordPress plugin developed by Dirk Elmendorf which provides extended blog-by-email capabilities to WordPress, such as allow lists, image scaling and rotation, 3gp videos, and the ability to specify categories. When I stumbled across it, I thought “That would be great for writing posts from my phone!” Unfortunately, having just set up my blog, I was running WordPress 2.3, which changes SQL tables around and broke Postie’s ability to recognize categories. I checked the original site and saw no update, so I decided to fix it myself.

I did some poking around, and managed to find the problem. It turns out that categories used to exist in their own table, so Postie just needed to look one place. In 2.3 however, categories, tags and link categories have all been rearranged and lumped into three new tables. Names are in one (wp_terms), Type (tag, category, etc…) and description in another (wp_term_taxonomy), and the third one (wp_term_relationships) that… uhh… does something. The problem then wasn’t just pointing Postie at a different table; it had to query two tables to make sure the term it found was the right kind of term. Read more