[wp-trac] [WordPress Trac] #15644: When deleting a user, corresponding comment user IDs aren't reset

[WordPress Trac]

#15644: When deleting a user, corresponding comment user IDs aren't reset
-----------------------------------+-----------------------------
 Reporter:  nacin                  |       Owner:
     Type:  defect (bug)           |      Status:  new
 Priority:  lowest                 |   Milestone:  Future Release
Component:  Comments               |     Version:
 Severity:  minor                  |  Resolution:
 Keywords:  2nd-opinion has-patch  |
-----------------------------------+-----------------------------
Changes (by kovshenin):

 * cc: kovshenin@… (added)


Comment:

 Hey there!

 I was getting rid of the admin user on an existing website who had
 existing blog posts and comments. I created a new admin user and when I
 went to remove the admin user it asked me whether I want to move all posts
 and links to a different one where I can pick from the list. I think the
 same approach should go with comments. I had to manually run an update
 statement on the comments table to replace all comments with user_id = 1
 to user_id = 9 (the ID of the newly created user) for my old gravatars to
 show up again. Thoughts?

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/15644#comment:8>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software