WordPress.org

Ready to get started?Download WordPress

Forums

Changing post attribution (4 posts)

  1. laurie
    Member
    Posted 9 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
    Member
    Posted 9 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
    Member
    Posted 9 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
    Member
    Posted 9 years ago #

    Doing just that SQL line should work without any problems.

    Regards

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.