ImpEx username import issue with special characters (phpbb2 -> vb 3.7) Issue Tools
issueid=26622 Tue 14th Oct '08 8:20pm
Member
ImpEx username import issue with special characters (phpbb2 -> vb 3.7)
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:
Code:
1. & #40 & #31;& (without the spaces)
2. <<*_mango_*>&
Username in phpbb2 database (viewed via phpmyadmin):
Code:
1. &amp;#40;&amp;#31;&
2. &lt;&lt;*_mango_*&gt;&
Username in vbulletin database:
Code:
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.
Issue Details
Issue Type Bug
Project ImpEx
Category Unknown
Status Working as Designed
Priority 3
Affected Version Unknown
Fixed Version (none)
Users able to reproduce bug 0
Users unable to reproduce bug 0
Attachments 0
Assigned Users (none)
Tags (none)

Fri 24th Oct '08 6:53pm
ImpEx Developer
  
The username of the user accounts aren't altered, only the post contents are parsed and they can be cleaned up.
Reply
Sat 14th Mar '09 3:28pm
Member
  
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)
Reply
Tue 24th Mar '09 12:13am
vBulletin Team
  
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.
Reply
Reply