PDA

View Full Version : ImpEx username import issue with special characters (phpbb2 -> vb 3.7)


jigger
Tue 14th Oct '08, 8:20pm
special characters &, < and/or > are imported incorrectly
I have imported users from phpbb2 to vbulletin 3.73 pl1. It looks like the special characters &, < and > are not imported correctly:

Displayed username in phpbb2:

1. & #40 & #31;& (without the spaces)
2. <<*_mango_*>&

Username in phpbb2 database (viewed via phpmyadmin):

1. &amp;#40;&amp;#31;&
2. &lt;&lt;*_mango_*&gt;&

Username in vbulletin database:

1. &amp;amp;#40;&amp;amp;#31;&amp;
2. &amp;lt;&amp;lt;*_mango_*&amp;gt;&amp;

& is converted to &amp;amp; or &amp; (so if the & is at the end it will be converted correctly).
< is converted to &amp;lt;
> is converted to &amp;gt;

There might be other characters which are not imported correctly.

Jerry
Fri 24th Oct '08, 6:53pm
The username of the user accounts aren't altered, only the post contents are parsed and they can be cleaned up.

woostar
Sat 14th Mar '09, 3:28pm
Sorry for bumping (I couldnt find another more up-to-date thread relating to this).

I have the exact same problem.
Usernames ARE altered.

Username: heather&amp;bump
Converts to
Username: heather&amp;amp;bump
(copy and paste directly from the database before and after)

Andy Huang
Tue 24th Mar '09, 12:13am
User accounts shouldn't be altered. I've checked and confirmed that phpBB2 does not alter it, but just to be on the safe side, please tell me what source are you importing from, and I can verify that for you.