AI Search

Classic Search

Search Phrase:

Search Type:

Advanced search options

Search in Forums:

Search in date period:

Sort Search Results by:

Filter by custom fields

Topic prefix

AI Assistant

Notifications

Clear all

Change the user of a comment

✦ Summarize Topic

How-to and Troubleshooting

Last Post by psi 3 years ago

4 Posts

2 Users

0 Reactions

1,559 Views

RSS

psi

(@psi)

Posts: 8

Active Member

Topic starter

Translate ▼

[#5299]

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.

Posted : 07/10/2022 3:06 pm

Topic Tags

comment customization

Asti

(@asti)

Posts: 8257

Illustrious Member Support

Translate ▼

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.

In case you want to say thank you! 🙂
We'd really appreciate if you leave a good review on the plugin page.
This is the best way to say thank you to this project and the support team.

Posted : 07/10/2022 3:51 pm

Asti

(@asti)

Posts: 8257

Illustrious Member Support

Translate ▼

@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.

In case you want to say thank you! 🙂
We'd really appreciate if you leave a good review on the plugin page.
This is the best way to say thank you to this project and the support team.

Posted : 08/10/2022 2:09 pm

psi

(@psi)

Posts: 8

Active Member

Topic starter

Translate ▼

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.

Posted : 08/10/2022 8:13 pm