XF 2.3 Edit "likes" username

[nodle]

So awhile back when I did an import I had to create a user (nodle1) and then in the meantime I edited my username to get it back to normal (nodle). What I noticed is alot of the old likes still have the username (nodle1) that I see when I am logged out while everything I liked since the username change (nodle) is using the correct name.

My question is, is there anyways to edit and change these old likes (nodle1) to what it should be (nodle). Is there a Msql command that I can run to change these names? I want to change all likes with the username (nodle1) to (nodle). Is that possible?

 

[nodle]

I found this in another post, would something like this work?

UPDATE xf_post SET message = REPLACE(message, 'nodle1', 'nodle');

Or would it need to be set to the table where the reactions are such as:

UPDATE xf_reaction_content SET message = REPLACE(message, 'nodle1', 'nodle');

Do you think a database query like this would work?

 

[Paul B]

I suspect the list of reaction names is a blob, so that won't work.

I don't have a schema to hand at the moment to confirm.

 

[nodle]

There are unique reaction user IDs, but since my user number is the same as the old user number, I don't know how it would distinguish?

 

[AndyB]

You might like this add-on:

https://xenforo.com/community/resources/rebuild-media-reactions-cache.8297/

 

[nodle]

You might like this add-on:

https://xenforo.com/community/resources/rebuild-media-reactions-cache.8297/

Will that change the name though @AndyB ? I am not looking to delete the reactions, but associate the correct username with it. I technically have the same user ID and the changed name, therefore your addon wouldn't delete it since I am not a deleted user (as far as I can tell)?