AI Search

Classic Search

Search Phrase:

Search Type:

Advanced search options

Search in Forums:

Search in date period:

Sort Search Results by:

AI Assistant

Notifications

Clear all

Question 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,426 Views

RSS

Posts: 8

psi

Topic starter

Translate ▼

Oct 07, 2022 3:06 pm

(@psi)

Active Member

Joined: 4 years ago

[#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.

3 Replies

Posts: 8210

Asti

Support

Translate ▼

Oct 07, 2022 3:51 pm

(@asti)

Illustrious Member

Joined: 8 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.

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.

1 Reply

Asti

Support

(@asti)

Joined: 8 years ago

Illustrious Member

Posts: 8210

Oct 08, 2022 2:09 pm

Reply to

Asti

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.

Posts: 8

psi

Topic starter

Translate ▼

Oct 08, 2022 8:13 pm

(@psi)

Active Member

Joined: 4 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.