Friday, July 02, 2010

Multilingual Wordpress SEO plugin for WPML

It appears that All-in-one-SEO plugin for WordPressdoes can not work with WPML multilingual CMS plugin.
Too bad, since we obviously have to manage our titles, descriptions and keywords in different languages if the pages appear in different languages.
So I had to switched from All-in-one-SEO to something else that supports WPML and can add multilingual titles for multilingual pages, like English title for English pages and Russian titles for Russian pages.

I was told that HeadSpace plugin works fine with WPML. The quick test showed that it is correct.

The bad thing was that I already had added English titles to more than 100 posts and pages using All-in-one-SEO, and this titles did not show up if I use HeadSpace.
What I do now? Should I retype all the titles again for teh new plugin.
I took a quick look on my WordPress database and reviewed the content of "wp_postmeta" DB table. All I needed was just replacing the field's name for title and description!

These 2 lines of SQL convert titles and descriptions from All-in-one-SEO to HeadSpace:


update wp_postmeta set meta_key = replace(meta_key, '_aioseop_title', '_headspace_page_title')
update wp_postmeta set meta_key = replace(meta_key, '_aioseop_description', '_headspace_description')