[resolved] Problem After Transferring Posts to Another User (4 posts)

  1. DebNCgal
    Posted 6 years ago #

    For security purposes, I deleted a user and transferred that user's posts to a new user. (I'm the owner of both users.)

    However, after the deletion of the original user and the transfer of the posts to the new user, even though my gravatar shows up for the new user in the "Users" section of the dashboard, my gravatar no longer shows up in my comments for the transferred posts. Instead, it's replaced by an Identicon (which is the setting I've selected for commenters who don't have a gravatar). The gravatars for other commenters still correctly show up.

    I've used the same email address (that's linked to the gravatar) for the new user that was used for the original user.

    Is there some way to get the gravatar to show up now for my comments in the transferred posts? Again, the gravatar shows up for the new user in the User panel — just not for my post comments.

    Has a glitch of some kind occurred in the database? I'm hoping there's a simple fix for this issue. Can someone offer feedback?

    I appreciate any help.

    Deb Phillips

  2. MichaelH
    Posted 6 years ago #

    Backup your database before doing anything.

    Could be the user_id column in your wp_comments table. Use phpMyAdmin and change to the new user ID (you will find that in the wp_users table).

  3. MichaelH
    Posted 6 years ago #

    If you know the old user id and the new user id you can use phpMyAdmin with this SQL

    UPDATE wp_comments SET user_id='56' WHERE user_id = '1';

    Change user_id from 1 to 56

  4. DebNCgal
    Posted 6 years ago #

    MichaelH, thank you so much! Your first comment helped me determine the old and new IDs, and your second comment helped me actually implement the SQL fix. They were both helpful comments, because I don't typically delve too deeply within phpMyAdmin.

    Thanks so much for responding. Bless you!

Topic Closed

This topic has been closed to new replies.

About this Topic