Changing post attribution (4 posts)

  1. laurie
    Posted 11 years ago #

    Is there any way in WP to change a post's attribution? I've been accidentally posting as 'admin' instead of using my regular user account. I'd like to reset the attribution of each article posted by 'admin' to show as posted by my regular user, and any drafts the admin user has too.

    If that's not something I can do through WP directly, is there a safe SQL query I can use to accomplish the same thing?

  2. laurie
    Posted 11 years ago #

    After a quick bit of digging in the DB I came up with the following SQL:

    update wp_posts set poster=2 where poster=1;

    The question is, is that safe or does it potentially result in an inconsistent database?

  3. laurie
    Posted 11 years ago #

    Well, I never did get any response on this one, so I'm going to go ahead and take the plunge, having just backed everything up and upgraded anyway. Fingers crossed this doesn't blow up in my face...

  4. Cypher
    Posted 11 years ago #

    Doing just that SQL line should work without any problems.


Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.