All in One SEO to Thesis Migration

Wordpress

by Kenny Hyder

I just recently switched my blog design from a cus­tom theme that I desig­ned over to the the­sis archi­tec­ture. After the­sis was up and run­ning, I wan­ted to disa­ble and stop using the All in One SEO pack, since this func­tio­na­lity is built into the the­sis theme.

I was poin­ted to this post by @godhammer which in theory should work. Howe­ver, after run­ning the sql query seve­ral times, I had no luck.

I dis­co­ve­red that on my blog, the title, desc­rip­tion and key­words fields were labe­led as “aioseop_title” etc. Rather than the sim­ple “title” struc­ture sug­ges­ted in the ori­gio­nal code.

What ended up wor­king for me was 3 sepa­rate sql que­ries to port over the title, desc­rip­tion and key­words 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 spe­ci­fic name your data­base is assig­ning to the indi­vi­dual fields, and replace the “_aioseop_title” type names res­pec­ti­vely. Hope­fully, if the other code men­tio­ned in the link above doesn’t work for you, this will!

{ 1 comment }

Justin McHood August 24, 2009 at 5:55 pm

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

Previous post:

Next post: