1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.4 Remove "Edited by moderator" from all posts?

Discussion in 'XenForo Questions and Support' started by Lile, Oct 9, 2014.

  1. Lile

    Lile New Member

    I ran Post Content Find / Replace on some smilies, and after that all the posts that were edited using that addon now include the bit about being last edited by a moderator.

    Is there a simple (or slightly complex, whatever) way to clear out all the last edited by a moderator texts from the forum posts?

    Some kind of a MySQL query?
  2. Brogan

    Brogan XenForo Moderator Staff Member

    It is stored in the post table: xf_post.last_edit_date, xf_post.last_edit_user_id, xf_post.edit_count

    Setting last_edit_date to 0 will remove the text.

    UPDATE xf_post
    SET last_edit_date = 0
    Always take a backup before doing any alterations to the database.
  3. AndyB

    AndyB Well-Known Member

  4. PASS

    PASS Active Member

    So I run the query on all three tables? Will it remove just the one that say last edited by a moderator or all of them?
  5. PASS

    PASS Active Member

    I tired running that query on the database and it didn't do anything.
  6. PASS

    PASS Active Member

    I got it working. I only wanted to remove messages that were last edited by myself after I ran the post replace.

    This worked!
    UPDATE xf_post SET last_edit_date = '0' WHERE last_edit_user_id = '1';
    Then I ran this to clear the edit history.

    UPDATE xf_post SET edit_count = '0' WHERE last_edit_date = '0';
    Then this to clear the last id with no edit history

    UPDATE xf_post SET last_edit_user_id =  '0' WHERE edit_count =  '0';
    Last edited: Nov 18, 2015

Share This Page