Import bug with SMF Private Messages

[Adavb]

Hello Jerry,

We've found another minor problem with the impex when converting from SMF 1.1.4.

It seems that private messages are not being converted thoroughly. Some of the BBCode is not being converted and double quotes are not either. The only way to get the double quotes to display properly in the private message is to turn on HTML formatting on in the vbulletin options. Not sure if thats safe.

Anyway here's a pic a fresh conversion of the Private messages using 1.90 impex:

[Jerry]

Parser must of missed the html chars, try this SQL :

UPDATE pmtext SET message = REPLACE(pagetext, '"', '"') WHERE pagetext LIKE '%&quot%';

[Adavb]

Parser must of missed the html chars, try this SQL :

UPDATE pmtext SET message = REPLACE(pagetext, '"', '"') WHERE pagetext LIKE '%&quot%';

That code gave me an error, but I modified it some and it worked:

UPDATE vb_pmtext SET message = REPLACE(message, '"', '"') WHERE message LIKE '%&quot%';

Now is there another magical sql to fix the bbcode quote?

[Jerry]

You'll have to use cleaner.php for that, the SMF specific HTML parsing was missing from the PM's for some reason, though was on the post texts.

I've added that now.

You'll have to use this line in cleaner to get it :

$text = preg_replace('#\[quote author=(.*)\]#siU', '[quote=$1]', $text); 

Replacing line 142 :

#$text = preg_replace('##siU', '', $text);