Lack of interest [Suggestion] User name changes Applied to older Posts

This suggestion has been closed automatically because it did not receive enough votes over an extended period of time. If you wish to see this, please search for an open suggestion and, if you don't find any, post a new one.

Andy.N

Well-known member
I noticed that the new mod Dean used to have username Abomination and now reading his past post where someone quote him, it would show as old username instead of new username. In my experience, it would confuse new members.
Shouldn't there a cron job to run daily to update the database with new username?
Here is the post I link to that show that I meant
http://xenforo.com/community/threads/xf-installation-support.2606/#post-37960

Of course, new users would think that post belong to Abomination but it should be changed to Dean.
 
Upvote 1
This suggestion has been closed. Votes are no longer accepted.
when i got my user name changed, mike specifically told me that it was technically very tough to get all instances changed.

of course a cron job can be run to rename instances of a user name in posts/quotes to the new name. but that also risks the possibility of messing up with totally unrelated content.

unless quotes are specifically linked to the quoted posts (like when you reply to a tweet on twitter) i guess, it would be a bad idea to just do a find and replace!
 
I do remember in VB where we can run some run Maintenance->Update Counters->Update Usernames to fix this problem. I don't remember if it would update the quotes as well.
 
i do not think it has worked on my forum. :) i run that command on a regular basis.

trying again anyways. description of the feature:

Update User Names:
This will update user names everywhere they occur on your forums. This may need to be done after changing a user's name in the Admin CP.
 
The Quote feature isn't actually linked to a username but just rather a word:
lalalalalalalala fweee!
The only way to actually get it to change in the same instance, is to use the userID instead of userName. ID's are what your account is attached to, not the name.
However, it get's a bit harder for the member to distinguish user 335 and user 267. So names are generally used in these manners.
 
I thought Mike said he had fixed this when Peggy had hers changed.

It shouldn't be too difficult to do a replace on usernames inside quote tags.
If not, I can't imagine the word "Abomination" has been used too many times in posts...;)

I'll flag it up to him so he's aware.
 
After discussion with Mike, although it would be desirable to reflect username changes in historic data (quotes, likes, etc.), it is fairly low priority at the moment (for obvious reasons).

A simple find and replace on a text string isn't desirable or feasible as it would catch all instances of it in posted content, whether it is a username or not.
Additionally, one of the problems is that on large boards (e.g. several million posts) it would have a severe impact on DB performance whilst the query is running.

So the idea isn't off the table but it's not something that's at the top of the list.
 
Good to hear that M&K is aware of the problem.
I don't imagine this is a big problem for most boards since username change is on a case-by-case basis and we can set up a cron that run at 3AM on a weekend or something. As long as the option is there, the owner can decide how best to use it.
 
The case you are quoting above has been resolved.
If you go back to an old post by Dean now and quote him, it will be his new username.

The issue being discussed here is with regards to historical post content.
 
Older posts could be updated using a query like this. I assume there is a table called post in xenForo.

UPDATE post SET pagetext = REPLACE(pagetext, 'quote="Abomination', 'quote="Dean')
 
Older posts could be updated using a query like this. I assume there is a table called post in xenForo.

UPDATE post SET pagetext = REPLACE(pagetext, 'quote="Abomination', 'quote="Dean')
I made the same suggestion to Mike this morning ;)
Although it's not quite that simple as the post_id is in the quote tags too.
Still easily done though.
 
Try do that on a large forum, with other 100K posts. It's not a nice thing to experience, especially with table-locking.
 
take the forum offline. let the load settle. run the query. should be possible. but then i am not very good with databases. :( almost killed one earlier this week.
 
Top Bottom