Skip to:
Content
Pages
Categories
Search
Top
Bottom

Unassigned Topics


  • Scordisian
    Participant

    @scordisian

    7 years, 11 months ago

    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!

Viewing 2 replies - 1 through 2 (of 2 total)

  • Scordisian
    Participant

    @scordisian

    7 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

    @scordisian

    7 years, 10 months ago

    I fixed it, here is for future reference:

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.

Topic Info

Topic Tags

Skip to toolbar