Main/alt relations error

by **Dopedmonkey** » Fri Dec 07, 2007 8:59 pm

Hey all,

when updating the relations I get this message:

Ultra - Main: K� - Alt of K� - Invalid main - Mainless alt

The mains name is "Kánnix" - same to "Askraél" and his twinks.

Is this a known bug?

Regards, Ben

by **Dopedmonkey** » Fri Dec 07, 2007 9:04 pm

Well,

I did THIS:

"oster2 takes into consideration the trend of us still supporting php 4.3 and 5.0, which don't support \pL in regexes.
If you have php 4.4+ or 5.1+, feel free to use \pL instead of \w. That'll fix the problem."

and now it's working for Kánnix....

But still:

Askraél - Main: Askrael - Alt of Askrael - Alt of Alt - Mainless alt
Azasel - Main: Askrael - Alt of Askrael - Alt of Alt - Mainless alt

Why alt of alt? The é is not recognized correctly I guess.
But I'll check that again for now.

by **PleegWat** » Fri Dec 07, 2007 10:22 pm

You're hit by mysql's accented-characters-are-equal feature. There is no fix. The workaround is not having multiple characters with the same name bar accents in your system.