Greetings humans!
I used the wonderful import tool to import my forums from a Drupal7 install. After I completed the import and the repair steps one by one I noticed all my forum topics are listed as Unassigned or (No Forum).

After some searching on the net I realized there is no plugin that allows me to select e.g. 30 topics and then bulk move them to the proper forum.

Is there a way to fix this as I have several thousand forum topics dating back to 2003. I was wondering if there is a query I can use in phpmyadmin or if there is a tool out there I have missed.

Looking forward to your replies!

[@scordisian Participant 8 years, 10 months ago]

I’ve been going through the script a bit and the database. In my opinion I could assign all post_type with the post_parent being 3270 in my case that are currently set to 0.

Now before I go do this I would appreciate some feedback,
a. is this possible?
b. what sql command would be the best for this?

[@scordisian Participant 8 years, 10 months ago]

I fixed it, here is for future reference:

UPDATE wpxn_posts SET post_parent=3270 WHERE post_type=’topic’;