Announcement

Collapse
No announcement yet.

newly converted - getting \" instead of "

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Lats
    replied
    I can't imagine a problem doing it live.

    Leave a comment:


  • siteworthy
    replied
    Great! Thanks...one more thingq

    Okay to do this while the board is up and running? I do stuff similar to this in a SQL Server database that I work on at work so... just curious.

    Leave a comment:


  • Lats
    replied
    Originally posted by siteworthy
    ...this will probably require running a SQL script...
    I think you're right

    For posts...
    Code:
    UPDATE
    post
    SET 
    pagetext = replace(pagetext,'\\"', '"') 
    WHERE 
    pagetext
    LIKE '%\\\\"%'
    For titles...
    Code:
    UPDATE
    thread
    SET
    title = replace(title,'\\&quot','&quot')
    WHERE
    title
    LIKE '%\\\\"%'
    For signatures...
    Code:
    UPDATE
    usertextfield
    SET
    signature = replace(signature,'\\"','"')
    WHERE
    signature
    LIKE '%\\\\"%'

    Leave a comment:


  • siteworthy
    started a topic newly converted - getting \" instead of "

    newly converted - getting \" instead of "

    We converted over from phpBB about a week ago and it appears that anywhere we had a " we now have a \". What's the best way to get this resolved? I see it in text of posts and here and there in subjects and signatures as well. Was thinking this will probably require running a SQL script but not sure what that would be.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X