I IPF Active member Jan 20, 2017 #1 I used the Post find and replace addon and now my forum has a few of these. How do I remove the line via phpmyadmin? Last edited: Jan 20, 2017
I used the Post find and replace addon and now my forum has a few of these. How do I remove the line via phpmyadmin?
I IPF Active member Jan 20, 2017 #2 Mike said: You can remove the rows from the xf_edit_history table, but the last edited by note is actually based on the last_edit_date / last_edit_user_id in the xf_post table. You'd need to reset those values to hide that. Click to expand... Brogan said: It is stored in the post table: xf_post.last_edit_date, xf_post.last_edit_user_id, xf_post.edit_count Click to expand... Found these two. So far, I have emptied the xf_edit_history table. What sql command should I use to remove that line? Will these work? UPDATE xf_post SET last_edit_date = '0' UPDATE xf_post SET last_edit_user_id = '0' UPDATE xf_post SET edit_count ='0' Update: The 3 commands worked. Problem solved. Thanks. Last edited: Jan 20, 2017 Upvote 0 Downvote
Mike said: You can remove the rows from the xf_edit_history table, but the last edited by note is actually based on the last_edit_date / last_edit_user_id in the xf_post table. You'd need to reset those values to hide that. Click to expand... Brogan said: It is stored in the post table: xf_post.last_edit_date, xf_post.last_edit_user_id, xf_post.edit_count Click to expand... Found these two. So far, I have emptied the xf_edit_history table. What sql command should I use to remove that line? Will these work? UPDATE xf_post SET last_edit_date = '0' UPDATE xf_post SET last_edit_user_id = '0' UPDATE xf_post SET edit_count ='0' Update: The 3 commands worked. Problem solved. Thanks.