Posts show \" and \'

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • PBChannel
    Senior Member
    • Feb 2001
    • 197
    • 3.6.x

    Posts show \" and \'

    I've imported from Fireboard to vBulletin.

    But, when I view the posts, any post that was imported and that uses a single or double quote has a "\" next to it.

    For example:

    Don't looks like Don\'t
    Can't looks like Can\'t
    "This is in quotations" looks like \"This is in quotations\"

    Any way to fix this?
  • Jerz
    Senior Member
    • Apr 2007
    • 398
    • 3.8.x

    #2
    Have you tried the cleaner script?

    Comment

    • PBChannel
      Senior Member
      • Feb 2001
      • 197
      • 3.6.x

      #3
      Tried that...unfortunately when I add the slash ("\"), it causes the script to crash.

      Comment

      • Jerz
        Senior Member
        • Apr 2007
        • 398
        • 3.8.x

        #4
        Probably because of the quote.

        Try:
        PHP Code:
        $replacer = array( 
                    
        '\"'    => '"'
        ); 
        I'm still not sure if that will work, but its worth a shot.

        Comment

        • PBChannel
          Senior Member
          • Feb 2001
          • 197
          • 3.6.x

          #5
          Still got errors with cleaner.php...

          Solved it, though, by running the following command in mySQL:

          Code:
          update post set pagetext = replace(pagetext, "\\", "");

          Comment

          Related Topics

          Collapse

          • tonmo
            Unread Posts
            by tonmo
            I probably missed this, but I couldn't find it via search. In vb4 my registered users could see all unread posts. How can I provide this feature in vb5? Shouldn't Latest Activity offer a filter for...
            Sat 8 Jun '13, 4:46am
          • BlogTwits
            Today's Posts
            by BlogTwits
            On this forum there's a sublink "Today's Posts". On mine there isn't. I had a look at the sitebuilder but I can't see where to add it. Any ideas?
            Thu 17 Jul '14, 1:59am
          Working...