PDA

View Full Version : Posts show \" and \'


PBChannel
Sun 30th Mar '08, 4:38pm
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?

CHIPIT
Sun 30th Mar '08, 6:08pm
Have you tried the cleaner script?
http://www.vbulletin.com/docs/html/main/impex_cleaner

PBChannel
Sun 30th Mar '08, 6:51pm
Tried that...unfortunately when I add the slash ("\"), it causes the script to crash.

CHIPIT
Sun 30th Mar '08, 7:05pm
Probably because of the quote.

Try:

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

PBChannel
Sun 30th Mar '08, 8:00pm
Still got errors with cleaner.php...

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

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