Announcement

Collapse
No announcement yet.

newly converted - getting \" instead of "

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

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

  • #2
    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 '%\\\\"%'
    Lats...

    Comment


    • #3
      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.

      Comment


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

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X