On 05/05/06, J.D. <spamsammler(a)pixelfeuer.de> wrote:
Hi,
we dont give up with the new wiki. Just a question.
We have usernames like "ab_cde".If one of us willlogin we see a failure
"bla ...the username "ab cde" dont exists".
Will wiki delete the "_" ? We need the "_" and in Wiki 1.4.7.ist
works.
MediaWiki converts underscores in usernames into spaces in the same
manner as it does titles. Existing usernames which contain underscores
won't work in release versions of the product.
When logging in, the underscore is converted to a space, while I
suspect the usernames in the databases contain the underscores intact.
If this is the case, then it is possible to convert existing usernames
using the following SQL:
UPDATE user SET user_name = REPLACE( user_name, "_", " " );
This will convert the names in the user table. You should back up the
wiki database as a precaution when doing this, since I'm not 100% this
won't break other things; it's possible that other conversions will be
needed in the revision, archive, recentchanges, image and oldimage
tables.
Rob Church