AI Assistant

Notifications

Clear all

Question [Solved] Comment assignments following account changes

Summarize Topic

General Discussions

Last Post by Asti 3 months ago

6 Posts

2 Users

1 Reactions

404 Views

RSS

Posts: 39

SOSPC

Topic starter

Translate ▼

Feb 07, 2026 5:07 pm

(@sospc)

Eminent Member

Joined: 5 years ago

[#11299]

Hello everyone,

I'm using a translator, so I hope this will be understandable.

One of my subscribers has asked for their account to be deleted so they can create a new one with a different email address and username.

The problem is that all their old comments are still in the database, but I don't know if it's possible to link the old comments to their new account.

I hope I've managed to make myself clear. 😁

Thanks,

Christophe

Topic Tags

5 Replies

Posts: 8284

Asti

Support

Translate ▼

Feb 09, 2026 12:26 pm

(@asti)

Illustrious Member

Joined: 8 years ago

Hi,

Please provide us with the following information:

The ID of the old user account
The ID of the new account
Let us know whether you have any wpDiscuz add-ons installed

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: 39

SOSPC

Topic starter

Translate ▼

Feb 09, 2026 1:34 pm

(@sospc)

Eminent Member

Joined: 5 years ago

Hello,

The old ID was: 862

The new one is: 2125

And yes, I use two extensions:

wpDiscuz - Emoticons

and

wpDiscuz - Online Users

Thanks

Christophe

1 Reply

Asti

Support

(@asti)

Joined: 8 years ago

Illustrious Member

Posts: 8284

Feb 10, 2026 11:31 am

Reply to

SOSPC

Translate ▼

@sospc

Please follow the steps below:

1. Back up your database first, so you can restore the website if anything goes wrong.

2. Execute the SQL queries below:

UPDATE `wp_comments` SET `user_id` = 2125, `comment_author_email` = 'new_user_email' WHERE `comment_author_email` = 'old_user_email' AND `user_id` = 862;
UPDATE `wp_comments` SET `user_id` = 2125, `comment_author_email` = 'new_user_email' WHERE `comment_author_email` = 'old_user_email' AND `user_id` = 0;
UPDATE `wp_comments` SET `comment_author_email` = 'new_user_email' WHERE `comment_author_email` = 'old_user_email';
UPDATE `wp_commentmeta` SET `meta_value` = 'new_user_email' WHERE `meta_key` = 'wpdiscuz_last_edited_by' AND `meta_value` = 'old_user_email';
UPDATE `wp_wc_comments_subscription` SET `email` = 'new_user_email' WHERE `email` = 'old_user_email';
UPDATE `wp_wc_follow_users` SET `follower_id` = 2125, `email` = 'new_user_email' WHERE `user_id` = 862;
UPDATE `wp_wc_follow_users` SET `follower_id` = 2125, `follower_email` = 'new_user_email' WHERE `follower_id` = 862;
DELETE FROM `wp_wc_online_users` WHERE `user_id` = 862;

In the SQL code, please replace new_user_email and old_user_email with the corresponding values.

This video tutorial should also be helpful:

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: 39

SOSPC

Topic starter

Translate ▼

Feb 10, 2026 12:42 pm

(@sospc)

Eminent Member

Joined: 5 years ago

Hello,

Thank you for your assistance.

I'd rather leave it at that. I didn't imagine I'd have to perform such a complex maneuver, and I don't want to crash my site.

For your information, the video is not displaying.

Thank you,

Christophe

Posts: 8284

Asti

Support

Translate ▼

Feb 11, 2026 11:58 am

(@asti)

Illustrious Member

Joined: 8 years ago

Posted by: @sospc

↑

I'd rather leave it at that. I didn't imagine I'd have to perform such a complex maneuver, and I don't want to crash my site.

Please keep us informed if you have any further questions. For now, we'll mark this thread as solved.

For your information, the video is not displaying.

Thank you for letting us know — we’ll definitely check this.

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.