Title: FIXED! Update user's old comments email address!
Last modified: August 30, 2016

---

# FIXED! Update user's old comments email address!

 *  [SVTX](https://wordpress.org/support/users/12ax7/)
 * (@12ax7)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/development-bump/)
 * Hello there,
 * in this [thread](https://wordpress.org/support/topic/update-old-comments-with-new-registered-user-email-address),
   the amazing **Ravi Patel** pointed me towards a solution for my issue that old
   comments wouldn’t be updated with a new (registered) user’s email address. He
   fixed it with a simple function that I thought might as well be included in the
   plugin. Mention him please though as it’s his work, not mine.
 * I’ve tested it and it works beautifully!
 *     ```
       function user_profile_update($user_id) {
            $commentarr = array();
            global $wpdb;
   
            if( !current_user_can( 'edit_user', $user_id ) ){
               return false;
            }
   
            if(isset($_POST['email'])):
                   echo $email = esc_attr($_POST['email']);
                   $wpdb->query("UPDATE $wpdb->comments SET comment_author_email='$email' WHERE user_id=$user_id");
            endif;
       }
       add_action('personal_options_update','my_profile_update', 10,2);
       add_action('profile_update', 'user_profile_update', 10,2);
       ```
   
 * [https://wordpress.org/plugins/comment-email-reply/](https://wordpress.org/plugins/comment-email-reply/)

Viewing 1 replies (of 1 total)

 *  [OviLiz](https://wordpress.org/support/users/ovib/)
 * (@ovib)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/development-bump/#post-6271633)
 * Another dead project? 🙁

Viewing 1 replies (of 1 total)

The topic ‘FIXED! Update user's old comments email address!’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/comment-email-reply.svg)
 * [Comment Email Reply](https://wordpress.org/plugins/comment-email-reply/)
 * [Support Threads](https://wordpress.org/support/plugin/comment-email-reply/)
 * [Active Topics](https://wordpress.org/support/plugin/comment-email-reply/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/comment-email-reply/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/comment-email-reply/reviews/)

## Tags

 * [comment](https://wordpress.org/support/topic-tag/comment/)

 * 1 reply
 * 2 participants
 * Last reply from: [OviLiz](https://wordpress.org/support/users/ovib/)
 * Last activity: [10 years, 8 months ago](https://wordpress.org/support/topic/development-bump/#post-6271633)
 * Status: not a support question