Announcement

Collapse
No announcement yet.

Delete the Quote Name (User X) in a Quote

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Bonee
    replied
    Originally posted by Wayne Luke View Post
    ...

    Updating the username to something random before deleting them should change this information in the future.
    That is the lesson I've learned here. Thanks for your support, appreciated!

    Leave a comment:


  • Wayne Luke
    replied
    You would need another query...

    Code:
    UPDATE postedithistory SET username='Gast' WHERE username='Bonee';
    Updating the username to something random before deleting them should change this information in the future.

    Leave a comment:


  • Bonee
    replied
    One last thing though ...

    I still see some "last edited by UserX at ...." in posts that the UserX has edited (the poststarter is shown as "guest", but the edit information is still the old users name "UserX"). I wanted to block this information or change the name UserX here as well. I have tried to only show this edit information for admins / moderators within the usergroups-settings, but it is still shown for everyone.

    Is there an "easy" way to do this (get rid of the UserX in the "last edited by ..." information), or do I have to use another query here?

    Leave a comment:


  • Bonee
    replied
    Okay, after clearing the system cache the name "UserX" isn't shown in the quotes anymore.

    Rows: Betroffene Zeilen: 187 (0,4339s)

    Thanks!

    Leave a comment:


  • Mark.B
    replied
    Make sure you clear the cache in the admincp.

    How many rows did it report it had changed when you ran the query?

    Note that, as Wayne stated, this isn't a supported method so we can only can only go so far to assist with it.

    Leave a comment:


  • Bonee
    replied
    Hi again, the query

    UPDATE text SET rawtext=REPLACE(rawtext,'UserX','Gast');
    did not solve the problem. The quote "User X wrote ..." is still there.

    Any idea what I can do to get the rid of the Name: UserX in a quote?

    Thanks!

    Leave a comment:


  • Wayne Luke
    replied
    The "old" database should contain unmodified data.

    Leave a comment:


  • Bonee
    replied
    Thanks, when I save the "old" database with mysqlDumper I am able to reset the query when uploading the "old" databse again, right?

    Leave a comment:


  • Wayne Luke
    replied
    Did you follow the link I provided? It tells you how to write a query to try and change this.

    UPDATE text SET rawtext=REPLACE(rawtext,'Bonee','Gast');

    However, this is not a supported action so if it destroys your database and content then we can't fix it.

    Leave a comment:


  • Bonee
    replied
    Please, I need help here!

    Is there a way to search for quotes that others users made "User X wrote ..." so that I can change/delete the nickname manually?

    Leave a comment:


  • Bonee
    replied
    That is no good news as I need to delete / replace all inserts named "UserX" with "Gast" (I have to by european laws)

    So, how does such a query look like?

    Let's say, I want to replace all text named "Bonee" (ijncluding the quote link) with "Gast".

    Thanks

    Leave a comment:


  • Wayne Luke
    replied
    There is currently no reliable way to do this.

    Quotes aren't actually tied to a user. The only reference is the Text in the field. You can try scrubbing the previewtext and rawtext fields text table and remove all references to the user name but this isn't guaranteed to work. You may be able to use the REPLACE function in MySQL to do this but we do not support this style of query.

    https://dev.mysql.com/doc/refman/8.0...nction_replace

    If the username was a common word, then it can cause disruptions in your other posts as well.

    Leave a comment:


  • Bonee
    replied
    Yes, when I click on the user name "x" in the quote, the forum directs me to the start page. However, this is not enough for european laws to delte personal data.

    SInce the user "x" is now listed as "guest" I would have to check all forum-posts for possible quotes by others useres that have quoted the user "X" (as this information is still in the quote). This is impossible when you have >160.000 posts.

    I need a way to delete the name "X" in the quote information. The best would be to delete the quote completly (so not only the user X information but the whole quote).

    Since I want his nickname "X" completly deleted from all posts (including all mentioning of "X") I need help here.

    Is there a way to change the name "x" to "deleted guest" for the whole forum (all posts in all threads in all forums)?

    Thanks!

    Leave a comment:


  • Wayne Luke
    replied
    Edit the topic so that the quote tag doesn't include the parameters when it was opened.

    You would change something that looks like:


    [quote==Bonee;n4414773]

    to

    [quote]


    However, if you've deleted the User, then it is just text. It links to the post that was quoted. If someone tries to access the user profile, nothing will exist.

    Leave a comment:


  • Bonee
    started a topic Delete the Quote Name (User X) in a Quote

    Delete the Quote Name (User X) in a Quote

    Hi there,

    I had a user "X" that wanted his forum account to be deleted. After deleting his account his name is still shown in the "quote information" of others useres that have quoted the deleted user "X".

    How can I get rid of the User "X" information in quotes that others useres have used?

    Thanks!
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X