• 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?

CTXMedia

Formerly CyclingTribe
#1
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
 

CTXMedia

Formerly CyclingTribe
#3
You could just try truncating the moderation_queue table.

Take a backup first though!
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
 

Brogan

XenForo moderator
Staff member
#4
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?
 

Brogan

XenForo moderator
Staff member
#6
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.
 

CTXMedia

Formerly CyclingTribe
#7
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