Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
themes-topic
User names all in lower case
Avatar
Dave
Member
sp_UserOfflineSmall Offline
Jan 5, 2012 - 11:45 am

Yellow Swordfish said

How was the 'username' column held in the phpBB database?

Can you be more specific? I still have the original DB, if that helps.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 5, 2012 - 2:14 pm

Well as I said above, the display name in SP is mapped during the import from the 'username' column in the phpBB users database table. So the question was how does the data look in that column? Is is all lower case for example?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Dave
Member
sp_UserOfflineSmall Offline
Jan 5, 2012 - 7:51 pm

OK, Username in the PHPBB DB is fine - however, the username_clean column is all lowercase. Is it possible that the import tool is using the username_clean column?

As an example...
Username, username_clean
'Kineth', 'kineth'
'Robin', 'robin'

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jan 5, 2012 - 9:24 pm

no, not exactly...

the wp display_name is mapped from username

the wp user_login is mapped from username

the wp user_nicename is mapped from the username_clean

now I do see an error check that looks if the display_name is empty, then the user_nicename is mapped into the display_name... something in that empty check looks a bit fishy... so I will need to confer with Andy on that since he wrote the importer...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625