1 rossputin Aug 14, 2009 06:07
3 rossputin Aug 14, 2009 15:32
The dormant cats are subs of the cat that I want to move the posts to. I tried moving them to another parent category and then back, but when I try to delete, it says that there are some posts assigned to the dormant category as the main category and some as the extra category so the category cannot be deleted.
It' starting to look like all I can do is go through each article in the category and reassign them.
4 yabba Aug 14, 2009 17:06
Hmmm, that must be a behaviour change, was pretty sure that deleting a cat auto-moved/assigned posts to the parent .... ahhh well, you live an learn
... you could cheat and just use mysql
UPDATE T_items__item SET post_main_cat_ID=#new_parent# WHERE post_main_cat_ID IN( #dormant child#, #next_dormant_child#, #etc# )
UPDATE T_postcats SET postcat_cat_ID = #new_parent# WHERE postcat_cat_ID IN( #dormant child#, #next_dormant_child#, #etc# )
Totally free-typed, not even checked the field names ... sooooo
1) take a backup
2) if/when it barfs, lookup the proper table/field names
3) re-run and hope I was close enough ;)
¥
If you move your dormant cats so that they become a sub-cat of the category that you want to move the posts into, and then delete the sub-cats, the posts get assigned to the parent cat ;)
¥