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 Well-Known 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 Well-Known 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 Well-Known Member

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

Share This Page