All in One SEO to Thesis Migration

I just recently switched my blog design from a custom theme that I designed over to the thesis architecture. After thesis was up and running, I wanted to disable and stop using the All in One SEO pack, since this functionality is built into the thesis theme.

I was pointed to this post by @godhammer which in theory should work. However, after running the sql query several times, I had no luck.

I discovered that on my blog, the title, description and keywords fields were labeled as “aioseop_title” etc. Rather than the simple “title” structure suggested in the origional code.

What ended up working for me was 3 separate sql queries to port over the title, description and keywords fields individually.

Here are the queries:

INSERT INTO wp_postmeta (post_id,meta_key,meta_value) SELECT post_id, ‘thesis_title’,meta_value FROM wp_postmeta WHERE meta_key = ‘_aioseop_title’;

INSERT INTO wp_postmeta (post_id,meta_key,meta_value) SELECT post_id, ‘thesis_description’,meta_value FROM wp_postmeta WHERE meta_key = ‘_aioseop_description’;

INSERT INTO wp_postmeta (post_id,meta_key,meta_value) SELECT post_id, ‘thesis_keywords’,meta_value FROM wp_postmeta WHERE meta_key = ‘_aioseop_keywords’;

If these don’t work for you, you may need to check to see what specific name your database is assigning to the individual fields, and replace the “_aioseop_title” type names respectively. Hopefully, if the other code mentioned in the link above doesn’t work for you, this will!

3 Replies to “All in One SEO to Thesis Migration”

  1. Thanks for this — I am just smart enough to know that I need to do this after upgrading to Thesis — and yet just dumb enough to not know exactly how to do it.

    Hopefully, this will help put me over the top on this little project…

    Justin

Comments are closed.