• Resolved noname1087

    (@noname1087)


    Hello everybody.
    Please help with the following issue.
    I need to add new Administrator and delete the old one in WP. But the problem begins when I try to attribute all content to new user: there are 200000 registered users and tab in browser just freezes while trying to build a select with so many users I suppose. Maybe someone knows how to overcome this.

    TNX.

    • This topic was modified 4 years, 10 months ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Everything else WordPress topic
Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator bcworkz

    (@bcworkz)

    You’re likely getting time out errors due to the sheer volume of users. The WP reassignment routine isn’t very efficient. If a user’s post were already reassigned before deleting them, removal should happen in the allotted time.

    You can reassign the author of a page’s worth of posts to another user through the bulk edit feature on the post lists table. You can increase the number of posts on a page through the screen options tab at upper right. I think you are limited to 99 posts per page.

    If a user has so many posts that even 99 is not enough, you could use the interconnect/it script to update a particular post_author ID to another. AFAIK changing the post_author value is all that is required to reassign a post. I’ve not thoroughly investigated reassignment this way. Backup your DB before making changes like this. Make only a few limited reassignments at first and test thoroughly before making widespread changes.

    Thread Starter noname1087

    (@noname1087)

    @bcworkz Tnx a lot.
    Actually I put all PHP and Apache limits to infinity – so this is definitely
    is not some limit on server side. I think it happens when browser tries to build this huge select with a lot of users inside. Even when I turned off all apps except the browser on my laptop – I succeed to do this task on some of the websites.
    Anyway the solution for me was:
    1)to update “post_author” field of all posts in “wp_posts” table where posts belonged to the users I needed to delete. So I just updated author of these posts to be the new admin I added;
    2)to delete all data of the users needed to be deleted from “wp_usermeta” table; 3)to delete the users I want to delete from “wp_users” table.
    I did all directly via MySQL console. So I hope I did not lose any content ))

    Tnx very much for help.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Attribule all content of users being deleted to the new one when 200000 users’ is closed to new replies.