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

XF 1.2 Replacing " With " (or Fixing Quotation Marks)

Discussion in 'XenForo Questions and Support' started by imno007, Jun 29, 2013.

  1. imno007

    imno007 Active Member

    After converting from SMF, I've discovered that every single quotation mark (double quote) on my Xenforo forums has been replaced with "

    Is there a simple database query I could run that would replace every instance of " with quotation marks?

  2. Jeremy

    Jeremy XenForo Moderator Staff Member

    Use Kier's resource to replace post content. If it requires RegEx:

    Replace it with " and you should be good.
  3. Brogan

    Brogan XenForo Moderator Staff Member

    If it's a simple replacement for identical content, you could just use a query.

    UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');
    Take a backup before doing so though.
    imno007 and Jeremy like this.
  4. imno007

    imno007 Active Member

    Thanks, Brogan, will give it a try soon and see how it goes.

Share This Page