Migrate deleted user's posts to another account

#1 · February 27, 2018, 9:02 am

Hello,

Thanks for having us this amazing and intuitive plugin.

I want to know if there’s a way migrate all posts of one user to another user. In WordPress when you delete an account you have this option to “Attribute all content to:” another user. I selected this option but asgaros posts were not attributed to the new user. Instead posts from the deleted user appears as “Deleted user”. Is there an in-built way to attribute all posts to a different user?

#2 · February 27, 2018, 5:19 pm

Hello @emonney

There is no built-in way for this yet. If you have a tool like phpMyAdmin installed on your web-server you could run the following sql-query to assign new user-ids to posts of an deleted user:

UPDATE wp_forum_posts SET author_id = ID_OF_AN_ADMIN_USER WHERE author_id = ID_OF_DELETED_USER;

If you want to support the development of Asgaros Forum, you can leave a good review or donate. Thank you very much!

#3 · March 1, 2018, 1:01 am

@asgaros This works fine. Thank you.

Asgaros has reacted to this post.