Tuesday, 7 July 2015

Migrating a WordPress site from utf8mb4 to utf8

Starting in version 4.2, WordPress will attempt to upgrade its database tables from utf8 to utf8mb4. You can read more about the change on make.wordpress.org if you’re into that kind of thing, but most of the time it won’t affect you. Most of the time.

It did affect me though. I ran into an issue where I’d built a site on a development environment running on MySQL 5.5 which supports utf8mb4, but had to launch it on Media Temple’s Grid service, which runs MySQL 5.1 and doesn’t support utf8mb4. I saw a few people recommending exporting the 5.5 database in phpMyAdmin using MYSQL40 compatibility and importing that into your 5.1 environment, but when I tried it, it messed up some serialized Beaver Builder data.

Eventually I discovered that WP Migrate DB is the way to go. The free plugin allows you to export your data with URL and file paths automatically replaced, and pre MySQL 5.5 compatibility. I ran it on the development site and got an export that I was able to import directly into the live, 5.1 environment without errors or corrupted serialized data.

I’m not sure how much of an edge case my situation is, but hopefully this is helpful to someone. Any other work arounds you’re aware of?

Monday, 1 June 2015

Edit Quick Switch

tl;dr — I made a plugin available here.

I saw a post on WP Tavern about a new plugin called Fast Page Switch that allowed you to quickly switch between page edit screens in the WordPress admin. It occurred to me that this concept could be easily taken further and allow for switching between posts, pages, and custom post types via a searchable dropdown. I turned the concept into a plugin called Edit Quick Switch and you can download it on WordPress.org now.

If you find it helpful, please share. Or, if you have ideas for improvement, it’s all on GitHub.

Friday, 10 April 2015

Tuesday, 29 July 2014

Observations on Modern Blogging

Lately, I’ve been reading a lot of blog posts.

In fact, most of them are like this one.

One sentence per paragraph.

Or, if you’re feeling adventurous, maybe two. Like this paragraph.

As if every line was earth-shattering news that deserved a paragraph all to itself.

I understand what you guys are trying to do.

I get it.

You understand that short paragraphs are considered helpful.

You understand readers have short attention spans.

And you understand that writing long paragraphs is hard.

But I have a request.

And I’ll keep it brief.

Stop it.

Please.

It’s really annoying.

Thanks.

Sunday, 13 July 2014

Gravity Forms Dashicon Plugin

If you’re someone like me that spends a lot of time in the WordPress admin, you’ll realize that little details in the UI can make a big difference. Combine that with my already slightly OCD bent, and it probably won’t surprise anyone that I find the lack of a Dashicon for Gravity Forms extremely annoying… so much so that I decided to make a plugin to fix it.

You can download it on GitHub. Hopefully they’ll update the core plugin before too long and this can become unnecessary.