• 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)

imno007

Well-known member
#1
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?

Thanks
 

Jeremy

Well-known member
#2
Use Kier's resource to replace post content. If it requires RegEx:
(")

Replace it with " and you should be good.
 

Brogan

XenForo moderator
Staff member
#3
If it's a simple replacement for identical content, you could just use a query.

Code:
UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');
Take a backup before doing so though.