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

XF 1.3 Question about cleaning up forum posts

Discussion in 'Installation, Upgrade, and Import Support' started by MITK, Apr 11, 2014.

  1. MITK

    MITK Member

    After my import from SMF to PHPBB3 to XF I have a lot of text on the forums like  

    Wondering the best way to remove that on a larger scale? We have 100,000 posts so to go in each one and clear out the command would take forever.
  2. Brogan

    Brogan XenForo Moderator Staff Member

    MITK likes this.
  3. MITK

    MITK Member

    The second option you listed, would it work if the content is different?

    [ IMG ]url to image[ /IMG ]

    So i would like to replace the img tags with what XF uses but keep the content in the middle the same.
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Well you could even use simple queries for that, just replacing the opening and closing tags.
    Assuming there is no optional parameter in the opening tag.

    It'a a matter of choice though - both approaches are valid.
  5. MITK

    MITK Member


    It looks like the tool will not work with my   issue and i tried figure out how I can delete it via myphpadmin but I can't even find the 40,000 records of these. I seen on a few posts you are a mysql guy, do you know how i can correctly find and remove these from the forum?
  6. Bionic Rooster

    Bionic Rooster Well-Known Member

    Is there any update on a simple SQL queries to remove   from posts?
  7. Mike

    Mike XenForo Developer Staff Member

    You can do simply replacements with a query:
    UPDATE xf_post SET message = REPLACE(message, 'old', 'new');
    Change old and new as necessary. Always take a backup before running direct queries.
  8. Bionic Rooster

    Bionic Rooster Well-Known Member

Share This Page