We have 8000 posts and we trying co-authors plugin some months ago, is a great plugin!.
But we need to delete a user and asign they post to other so we try this direct sql command (not wordpress delete from backoffice):
SELECT ID FROM wp_users where display_name='old_author_name'
UPDATE wp_posts SET post_author='new_auhtor_id' WHERE
But after this all post from "old-author" doesnt show any co-authors user on the box... both post list or post edit...
After this I tried to delete "old-user" from wordpress interface but still same problem.
If I deactivate "co-authors" plugin I verify all posts from "old-user" are well assigned to "new-user". But after activate co-authors the problem back... the co-authors box is empty, and the only solution is to save post by post asigning new co-author, but I cant do this manually on 1000 post.
Any help please?