WordPress.org

Support

Support » How-To and Troubleshooting » [Resolved] How to Re-associate comments with a user after moving wordpress

[Resolved] How to Re-associate comments with a user after moving wordpress

Viewing 2 replies - 1 through 2 (of 2 total)
  • Update: I’ve been working on this and I’ve gotten further, but I need some mySQL help.

    In the wp_users section, my Author account’s user id is 2. In the wp_comments, my author’s user id is 1 (which I believe is actually my admin account’s id.)

    So if this is all making sense, how do I change a user id in the wp_comments table?

    Thanks 🙂

    I hate to keep posting in a row, but for anyone in the future who has this problem, I’ve found the solution.

    If you are using phpmyadmin with your database, go to the SQL section and run this:

    UPDATE wp_comments
    SET user_id = 2
    WHERE name = "Jimmy the Author"

    *where you see 2, change to whatever your author’s user id is.

    Happy blogging 🙂

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Resolved] How to Re-associate comments with a user after moving wordpress’ is closed to new replies.
Skip to toolbar