You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » UBB.threads 7 Discussion » Importer Assistance » LoginName with special characters cannot login .
Register User    Portal Page     Forum List        Calendar     Active Topics     Search     FAQ
Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (Kelvin, Peter), 33 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 05/13/08
Posts: 596
Top Posters (30 Days)
Ruben 49
DennyP 24
Gizmo 23
Dunny 17
SteveS 14
AllenAyres 12
dbremer 10
SD 9
drkknght00 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 3 1 2 3 >
Topic Options
#171168 - 12/26/06 02:39 AM LoginName with special characters cannot login .
smallufo Offline
enthusiast 		Registered: 06/05/06
Posts: 265
Loc: Taiwan
My forum is in Taiwan , many users use Chinese characters as their login name (column : USER_LOGIN_NAME) in UBB5 (It allowed special characters in login name long time ago . After UBB6 , it is disabled) , after migrating to UBB7 , these users cannot login.

How to solve it ?
_________________________

English is not my native language.
I try my best to express my thought precisely.
I hope you understand what I mean.
If any misunderstanding results from culture gaps , I apologize first.
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#171171 - 12/26/06 02:49 AM Re: LoginName with special characters cannot login . [Re: smallufo]
jgeoff Offline
Pooh-Bah 		Registered: 08/08/06
Posts: 1922
Loc: NJ
Is the box unchecked in Control Panel » Registration Settings » Basic Options » Allow Special Characters in Display Names?

Although, that does say "Display Names" and not login names, but perhaps verify that setting anyway and see if it helps...

_________________________
GangsterBB.NET (Ver. 7.5.6)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Chrome, Firefox, & Safari (Win7 and iPhone); No IE, ever!
Top
#171175 - 12/26/06 03:18 AM Re: LoginName with special characters cannot login . [Re: jgeoff]
smallufo Offline
enthusiast 		Registered: 06/05/06
Posts: 265
Loc: Taiwan
Thank you . I solved it.
It's related to generic.php:$ubbt_lang['CHARSET'] .
After I change it to big5 , it works OK now.
_________________________

English is not my native language.
I try my best to express my thought precisely.
I hope you understand what I mean.
If any misunderstanding results from culture gaps , I apologize first.
Top
#171190 - 12/26/06 06:28 AM Re: LoginName with special characters cannot login . [Re: smallufo]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Isn't the defualt UTF8? I thought it allowed for chinese/japanese special characters...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#171195 - 12/26/06 12:04 PM Re: LoginName with special characters cannot login . [Re: Gizmo]
smallufo Offline
enthusiast 		Registered: 06/05/06
Posts: 265
Loc: Taiwan
No , because of historical issues.

I used UBBT since WWWThreads (perl version) with mysql 3.23 , mysql didn't support i18n at that time , all Chinese characters were encoded in latin1 (8859_1).

After upgrading to UBBT 6 and MySQL 4 , the DB/table/column still encode in default latin1_swedish_ci.

I just need to set $ubbt_lang['CHARSET'] to BIG5 and it works fine.

I know UTF8 encoding maybe the ultimate solution. But I don't know how to change the whole DB/TABLE/column encoded to UTF8 ... Can somebody give me some hints ?
_________________________

English is not my native language.
I try my best to express my thought precisely.
I hope you understand what I mean.
If any misunderstanding results from culture gaps , I apologize first.
Top
#171196 - 12/26/06 12:44 PM Re: LoginName with special characters cannot login . [Re: smallufo]
jgeoff Offline
Pooh-Bah 		Registered: 08/08/06
Posts: 1922
Loc: NJ
 Originally Posted By: smallufo
I don't know how to change the whole DB/TABLE/column encoded to UTF8 ... Can somebody give me some hints ?


Can't this be done in phpMyAdmin?
_________________________
GangsterBB.NET (Ver. 7.5.6)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Chrome, Firefox, & Safari (Win7 and iPhone); No IE, ever!
Top
#171197 - 12/26/06 01:06 PM Re: LoginName with special characters cannot login . [Re: jgeoff]
smallufo Offline
enthusiast 		Registered: 06/05/06
Posts: 265
Loc: Taiwan
Yes , it can be done .
ex :
 Code:
mysql> ALTER DATABASE xxx DEFAULT CHARACTER SET UTF8 COLLATE UTF8;

There are also commands to change TABLE/COLUMN's collation . But it only affects the newly inserted data , not the existing data.
_________________________

English is not my native language.
I try my best to express my thought precisely.
I hope you understand what I mean.
If any misunderstanding results from culture gaps , I apologize first.
Top
#171361 - 12/28/06 11:05 AM Re: LoginName with special characters cannot login . [Re: smallufo]
smallufo Offline
enthusiast 		Registered: 06/05/06
Posts: 265
Loc: Taiwan
After trying another accounts , I found MOST users with special characters in their Login_Name cannot login !

I don't know why , can somebody tell me what to do ?
UBB6 is OK , But after upgrading , this is frustrating...

My DB encoding is UTF-8 , so , these special characters are saved in UTF8 format.

Does it related to start_page.inc.php or do_login() in ubbthreads.inc.php ? Is there any encoding trick inside ?
_________________________

English is not my native language.
I try my best to express my thought precisely.
I hope you understand what I mean.
If any misunderstanding results from culture gaps , I apologize first.
Top
#171367 - 12/28/06 11:34 AM Re: LoginName with special characters cannot login . [Re: smallufo]
smallufo Offline
enthusiast 		Registered: 06/05/06
Posts: 265
Loc: Taiwan
After tracing some old (UBBT6) and new (UBBT7) code , I found some difference...

In UBBT6 , authentication is through
 Quote:

$query = "
SELECT U_Username, U_Laston, U_Password,U_Number,U_Language,...
FROM {$config['tbprefix']}Users
WHERE U_LoginName = '$Username_q'

It seems it is direct String comparing ...

But in UBBT7 , it's done by this :
 Quote:

where t1.USER_LOGIN_NAME = ?
and t1.USER_ID = t2.USER_ID
and t1.USER_ID = t3.USER_ID

$sth = $dbh -> do_placeholder_query($query,array($Username),__LINE__,__FILE__);



It seems the $Username is processed by array() , is this the problem that cause mose users (with special chars in LoginName) cannot login ? How to solve it ?
_________________________

English is not my native language.
I try my best to express my thought precisely.
I hope you understand what I mean.
If any misunderstanding results from culture gaps , I apologize first.
Top
#171373 - 12/28/06 01:05 PM Re: LoginName with special characters cannot login . [Re: smallufo]
Rick Offline
Post-a-holic 		Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
What's the error message they get when they try and login? That will at least let us know if it's not recognizing the username, or if it's a password issue.
Top
Page 1 of 3 1 2 3 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33841 Topics
181696 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image
Board Rules · Mark all read
Contact Us · UBBCentral · Top