1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.1 IPB 3.1.x import - soft deleted posts are in moderation queue - query to delete (soft-delete) them?

Discussion in 'Installation, Upgrade, and Import Support' started by CyclingTribe, Oct 25, 2011.

  1. CyclingTribe

    CyclingTribe Well-Known Member

    I'll have near-on 50,000 items in the moderation queue by the time my import fully completed.

    I cannot click "Delete" on each item in the queue (especially as there's no pagination!!!! :eek: ), so could I please have a query to soft-delete all items in the moderation queue please?

    Thanks,
    Shaun :D
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    You could just try truncating the moderation_queue table.

    Take a backup first though!
     
  3. CyclingTribe

    CyclingTribe Well-Known Member

    That would get rid of the queue, but unfortunately the posts from banned members are not soft-deleted and are still visible to members after import.

    The soft-delete query will hopefully remove them from view.

    Cheers,
    Shaun :D
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    So they were deleted in your old forum but after importing they are moderated but not deleted?

    Which means the xf_post.message_state field has visible for them all?
     
  5. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

  6. Brogan

    Brogan XenForo Moderator Staff Member

    FYI, I've flagged this to Kier and Mike as the posts shouldn't have been imported in this state assuming they had the correct state/flag in the IPB database.
     
    GeeksChat likes this.
  7. CyclingTribe

    CyclingTribe Well-Known Member

    Thanks.

    Definitely don't want them approved ... :ROFLMAO: ... but not bothered about the deletions being logged in the moderation log if that part can be excluded.

    There isn't a simple switch to move the post into "soft deleted" state then?

    I could do that to them all and then truncate the mod queue.

    Cheers,
    Shaun :D
     
  8. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

  9. CyclingTribe

    CyclingTribe Well-Known Member

    Spot on Jake - thanks.

    All that was left were a few profile posts - but they were easily removed. (y)
     

Share This Page