WordPress.org

Ready to get started?Download WordPress

Forums

Change the author's name (9 posts)

  1. zoblue
    Member
    Posted 9 years ago #

    I just installed WP and transfered entries from MT to WP. The author's name on all the entries is "site admin" as you can see below the entries next to "posted by:"
    zoblue.com/wordpress/index.php
    How can I change that? The Authors listed in WP are me and "site admin." How can I merge them so that the site admin (id=2) and me (id=1) are the same? Would I have to change that in the database? Or change it in MT and re-export, re-import?
    thanks in advance,
    Zulema

  2. lazymonster
    Member
    Posted 9 years ago #

    er.. i think you have to change it in the database

  3. zoblue
    Member
    Posted 9 years ago #

    I was afraid of that... grrrrr...
    thanks,
    Z

  4. zoblue
    Member
    Posted 9 years ago #

    It was easy, friend of mine helped me:
    UPDATE wp_posts
    SET post_author = '1'
    WHERE post_author LIKE '2';
    he said my host is running older version of mySQL ;)

  5. boneless
    Member
    Posted 9 years ago #

    can you please explain step by step how to do this?
    I can enter phpmyadmin, I can edit wp_posts
    but then what?
    I can do a SET and change the value (now 4?) but can I just change the for to a 1 ? And why does it say I have to enter the value like 'a'b'c' ?
    I don't see a WHERE.
    Please explain!
    thanks

  6. boneless
    Member
    Posted 9 years ago #

    forget it, with sweaty hands I found it and just gave it a try.
    And it worked!
    but I didn't need the WHERE to set all posts to the right author.
    Thanks anyway, slowly learning all there is to know :-)

  7. Ruby Sinreich
    Member
    Posted 9 years ago #

    Is there any way to similarly take all posts in category one and also put them in category 2?

  8. carthik
    Member
    Posted 9 years ago #

  9. Ruby Sinreich
    Member
    Posted 9 years ago #

    Perfect. Thanks!

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.