Support » Fixing WordPress » Changing post attribution

  • 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?

Viewing 3 replies - 1 through 3 (of 3 total)
  • 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?

    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…

    Doing just that SQL line should work without any problems.


Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Changing post attribution’ is closed to new replies.