XF 2.2 Username change unchanged in quoted content

[zappaDPJ]

Is it expected behavior that after a username change, quoted content posted by that member retains the original username?

 

[Ozzy47]

Yes, that is normal behavior.

 

[Mr Lucky]

If it is unique enough you can change in database.

 

[zappaDPJ]

Thanks for the replies.

This is something that is starting to occur on a regular basis. It's especially problematical if you are trying to properly anonymize an account. In my view it's a problem that needs a solution.

 

[creativeforge]

Is it expected behavior that after a username change, quoted content posted by that member retains the original username?

A member is facing this and found 12 posts still bearing his former name.

Is there a solution, yes, an addon or something that could change usernames not only for the member's ID, but every single instance, including names that are found in replies or quoted by other users?

As well, the old username still shows in reactions (Likes, etc).

Is this something that can be fixed at the AP or does it require diving into the server's database?

Thanks for any help,

Andre

EDIT! I noticed all posts in questions are 7 years and older.
Is there a setting somewhere to make username changes to cover all time?

 

[Alpha1]

In my experience people mostly will not contact site staff about the issue but will just report the offending urls to Google. Which is not good.

 

[creativeforge]

In my experience people mostly will not contact site staff about the issue but will just report the offending urls to Google. Which is not good.

In this case, the member did contact us.

 

[James]

I believe the only way to change it is with an addon or a database query. It's not possible to change quote usernames as its just text in the bbcode.

 

[creativeforge]

I believe the only way to change it is with an addon or a database query. It's not possible to change quote usernames as its just text in the bbcode.

I guess the question is: when a username is changed, Xenforo's software seems to go back 7 years to modify all instances.

What happens beyond that? Can we modify the setting to reach up to 20 years? Some forums have converted from older forum software and have existed for much longer than Xenforo has existed.
▼
But can this limitation be modified?

EDIT: I was wrong, it is not limited by time (7 years). It's about location: Usernames are changed, but placed in a post, they are not changed.

 

[creativeforge]

@Claudio Follow this?

 

[James]

I'm not sure if there is logic in the software to change quote usernames going back 7 years. I don't believe quote usernames are changed at all, hence this suggestion:

Thread 'Apply Name Change to quotes & user mentions (GDPR)'

May 6, 2018

The EU GDPR forces a right to be forgotten which means that we need to be able to remove the name of person from our site. Currently this is not fully possible, except manually. Because user mentions and quotes still include the name. For big boards its not feasible to manually edit all posts. I have 2 million posts on my site and just 2 admins.

For example: at the current time I have 5600 posts here on XF.com If I would request a name change, then there's probably around 1k quotes and tags with my name in it. Its not feasible to manually edit that.

So please add a function that scans...

• Alpha1
• Replies: 34
• Forum: XenForo suggestions

• 
• 

Of course I could be wrong. Something could have changed since. Perhaps @Paul B could shed light.

 

[Chromaniac]

Xenforo's software seems to go back 7 years to modify all instances.

i am confused about this. if you do a find and replace using an addon or directly in database, it should work on all instances as specified in the command. there is no automatic replacement of old ids either in quotes or in mentions. the few times i faced this, i just ran a mysql query in phpmyadmin to replace the unique userid with a generic name. and it should work everywhere unless specifically restricted.

 

[creativeforge]

i am confused about this. if you do a find and replace using an addon or directly in database, it should work on all instances as specified in the command. there is no automatic replacement of old ids either in quotes or in mentions. the few times i faced this, i just ran a mysql query in phpmyadmin to replace the unique userid with a generic name. and it should work everywhere unless specifically restricted.

Thanks, I will look into this.

 

[Chromaniac]

The command I use to do basic find and replace in post commands is this:

UPDATE xf_post SET message = REPLACE(message, 'Original', 'Replacement');

Of course, do tests, take backups and make sure it does not end up doing an unexpected text change coz it would be irreversible. If the userid is something unique like @creativeforge, it should be fairly safe to do.

 

[Sal Collaziano]

The command I use to do basic find and replace in post commands is this:

UPDATE xf_post SET message = REPLACE(message, 'Original', 'Replacement');

Of course, do tests, take backups and make sure it does not end up doing an unexpected text change coz it would be irreversible. If the userid is something unique like @creativeforge, it should be fairly safe to do.

Is this the most sensible way to address the issue? If I have a member who wants to disassociate his content with his username, quoted messages can certainly be a problem if there are a lot of them...