main co-author dissapeared after deleting user

Hi,

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
post_author=’old_author_id’

But after this all post from “old-author” doesnt show any co-authors user on the box… both post list or post edit…

SCREENSHOTS

https://docs.google.com/file/d/0B92OgSEGXPrrbkE0T2dfaHZxbE0/edit?usp=drivesdk
https://docs.google.com/file/d/0B92OgSEGXPrrSDRjdm4ybmFmZW8/edit?usp=drivesdk

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?

Regards,

https://wordpress.org/plugins/co-authors-plus/