Adding Parent Category Retroactively

https://climbtothestars.org/archives/2004/07/13/batch-categories-09/

try that one ??

But it doesn’t look like it works on WP 2.0. ??

i’d try it – it doesn’t say on matt’s list that it does or doesn’t… https://codex.www.ads-software.com/User:Matt/2.0_Plugin_Compatibility and i’ve seen other people refer to it fairly recently…

i’d just see if it works – maybe try it on another site or something? i dunno – i doubt any issue you’d have would be severe… i just don’t think the plugin dev has updated it is all.

That didn’t work even with 1.5…

oh… well, i’d seen that podz had recommended it a few times, so i thought it did.

sorry, mallory… ??

any bright light ideas here, moshu?

https://www.ads-software.com/support/topic/25084?replies=49 – here’s a thread i found on fixing it… to make it work. didn’t read through the whole thread, but there are some ideas in there to make it work.

and this guy seems to believe he got it working with help from that thread: https://www.garypaulson.net/archives/batch-categories-hack/

Really there should be a way to write an SQL statement to say something like,

For all in wp_post2cat that match category_id = 29, then insert a row with category_id = 51 and the post_id.

However, SQL is not my forte. I’ve been looking at an old SQL book trying to figure it out.

How about this? Would this do it?

INSERT INTO 'wp_post2cat' (post_id, category_id)
VALUES ((SELECT post_id FROM 'wp_post2cat' WHERE 'category_id' = '29') ,'51')

29 = child id
51 = new parent id

This SQL code should have worked, but it for some reason, I get an old SQL error about trying to insert from the selected table.

I guess I have to give up and do it manually.