Change the user of ...
 
Share:
Notifications
Clear all

Question Change the user of a comment

4 Posts
2 Users
0 Likes
464 Views
Posts: 8
 psi
Topic starter
(@psi)
Active Member
Joined: 2 years ago

Hi. I have created a number of comments (Q & A) for another internal user and now I want to replace the author of the reply with the stakeholder of this post. 

Q: How can I (bulk-) change the user of a comment ? In this case the reply.

Note: I changed it by using Quick Edit in Comments section to change Name and email, but the WPDiscusz name (@usercompany-com) in brackets behind the name still retains the old one.

 

3 Replies
Asti
Posts: 7056
 Asti
Support
(@asti)
Illustrious Member
Joined: 6 years ago

Hi psi,

As far as I know, you should change it in the Database. Anyway, I'll ask the developers if there is a solution we can post here. I'll update this topic once I get some news for you.

Reply
1 Reply
Asti
 Asti
Support
(@asti)
Joined: 6 years ago

Illustrious Member
Posts: 7056

@psi,

You can use the SQL code like this one: 

UPDATE `wp_comments` SET `user_id` = 1 WHERE `comment_ID` = 86;

The wp_ is just a prefix in your case it can differ. 

You'll need to change the red marked values. 

Reply
Posts: 8
 psi
Topic starter
(@psi)
Active Member
Joined: 2 years ago

Why do you want to change the user ID based on the comment ID ?

OK, change in the database. I don't want to replace all of the comments from user A to user B. Just the ones of a particular post (CPT), so I have to take the post id into the account as well.

Reply
Share: