Support » Plugins and Hacks » [Resolved] main co-author dissapeared after deleting user

[Resolved] 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

    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?



Viewing 1 replies (of 1 total)
  • Hi,

    Problem resolved! I update directly on database tables for updating post without co-author asignated after deleting user.

    table: wp00_term_taxonomy
    taxonomy: author
    term_taxonomy_id: id used for relationship

    table: wp00_term_relationships
    object_id: is the post id
    term_taxonomy_id: is the co-author id

    First you have to found the id author on “wp00_term_taxonomy” and then search using this id on “wp00_term_relationships” so there you have the posts you want change… then you have only to change term_taxonomy_id pointing to new author.

    Hope this helps others because there is no info on internet about this matter with co-authors plugin.


Viewing 1 replies (of 1 total)
  • The topic ‘[Resolved] main co-author dissapeared after deleting user’ is closed to new replies.