Changing post attribution

  • laurie

    (@laurie)


    21 years, 4 months 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?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter laurie

    (@laurie)

    21 years, 4 months 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?

    Thread Starter laurie

    (@laurie)

    21 years, 2 months 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…

    Cypher

    (@cypher)

    21 years, 2 months ago

    Doing just that SQL line should work without any problems.

    Regards

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Changing post attribution’ is closed to new replies.