[1234] Similar name in Database overwritten

Posts from previous Beta sessions

[1234] Similar name in Database overwritten

Postby bandicut » Thu Aug 16, 2007 4:20 pm

Hi there,

first of all... sry for my poor english. I'm german.

My Problem is that similar names were overwritten in the Database.
For example: My main char is "Leif". As Alt/Twink i've got a Shaman named "Leíf". If i upload the Guild- and characterprofile only one char is written in the database, the other doesn't exists anyway.

Some ideas?

MFG bandicut
bandicut
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Sat May 12, 2007 12:43 am

Re: [1234] Similar name in Database overwritten

Postby tuigii » Thu Aug 16, 2007 9:16 pm

Better yet :

I have a main char named Nowwhat
And a second one : Nowwhät
Used the second one for testing purposes - because this overwriting happend before : http://www.wowroster.net/Forums/viewtop ... wwhat.html
Back then, I couldn't find any overwriting happening to my char's.
Now, Nowwhat (updated first) is being overwriten by Nowwhät. I had to /deguild the sucker to make my main being updated.
User avatar
tuigii
WR.net Master
WR.net Master
 
Posts: 891
Joined: Wed Dec 27, 2006 12:57 pm
Location: Somewhere in the South Ouest of France

[1234] Similar name in Database overwritten

Postby zanix » Fri Aug 17, 2007 8:57 am

This was never solved in that forum
Anyone able to debug this?
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: [1234] Similar name in Database overwritten

Postby tuigii » Fri Aug 17, 2007 2:22 pm

Will dive into it with the usual echo .... statements this evening (GMT+1 over here, meaning in 12 hours).

The thing is, my Nowwhät is deguilded, and few Officers present these days - and one can't guild an off line character.
Once he's in I'll go down back to SQL row-level if needed.
We'll see if separated ID are attributed.

What I did remember when seeing the upgrade log from before yesterday that a first char (the normal type) was recognised and it's stuff was loaded, the second (the ä type) was recognised - and loading.
In the V2 Roster, Nowwhat was marked yellow, but not ONE detail.
Nowwät is a small char. it had some fields filled up (it's still a lvl one 'no, stuff, no proffesions).

The test roster is over here: http://www.papy-team.fr/roster_20b1/ind ... emberslist
User avatar
tuigii
WR.net Master
WR.net Master
 
Posts: 891
Joined: Wed Dec 27, 2006 12:57 pm
Location: Somewhere in the South Ouest of France

Re: [1234] Similar name in Database overwritten

Postby Paxton » Wed Aug 22, 2007 2:42 am

Got the same problem.

I change the collation in the table 'roster_members' for the field 'name' from 'utf8_general_ci' to 'utf8_bin'

Now similar names are displayed and not overwritten. Have to keep an eye of this if it's working correctly.
Last edited by Paxton on Wed Aug 22, 2007 2:43 am, edited 1 time in total.
Paxton
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Thu Aug 10, 2006 3:53 pm

Re: [1234] Similar name in Database overwritten

Postby tuigii » Sat Aug 25, 2007 11:47 pm

Paxton wrote:I change the collation in the table 'roster_members' for the field 'name' from 'utf8_general_ci' to 'utf8_bin'.

This actually 'solved' it....

But in ther mean time, I upgraded and lost track of the problem.
Be back in this one... because I do accept the solution 'as is' but hate to work on issues that could be web-server dependant.

I'll put it back - fool arround with my two character Nowwhat & Nowwhät - and update again.

I'll be back on this one if I see anything suspected.
User avatar
tuigii
WR.net Master
WR.net Master
 
Posts: 891
Joined: Wed Dec 27, 2006 12:57 pm
Location: Somewhere in the South Ouest of France

[1234] Similar name in Database overwritten

Postby zanix » Sun Sep 09, 2007 2:02 am

Bump, because I want the other devs to look at this as well
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: [1234] Similar name in Database overwritten

Postby poetter » Sat Sep 29, 2007 7:20 am

First of all, please close my other thread, haven't seen this one here.

Turning to utf8-bin is not a good idea. this solves the problem with a and ä, but it is not case sensitive as a key and name is as key in roster_members and roster_players. so POETTER would be the same as poetter.

I tried out different utf8 and latin collations and they have all there stumbling blocks.

What would do the trick is to urlencode the names, with the disadvanges that we wont have mysql side sorting and everyone fetching data from this tables needs to urldecode the names.

Crappy stuff :roll:

BTW: a=ä=â=á=à=A=Ä=Á=À=Â *rofl*
Image
User avatar
poetter
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 462
Joined: Sat Jun 30, 2007 9:41 pm
Location: Germany/Hamburg

[1234] Similar name in Database overwritten

Postby Subxero » Sat Sep 29, 2007 7:28 am

One stupid question .. where is the problem with case insensitive ?

Because Blizzard don't allow the case sensitive to make another char...

Subxero subxero and suBXero are the same character on wow.

But...

Aldor, äldor and áldor are DIFFERENT sure!
Last edited by Subxero on Sat Sep 29, 2007 7:29 am, edited 1 time in total.
Subxero - Priest 70 Holy - Asphelt Knight Officer - Zul'jin Horde.
User avatar
Subxero
WR.net Artisan
WR.net Artisan
 
Posts: 234
Joined: Thu Jul 06, 2006 4:08 pm
Realm: Zul'jin (PvE) - US

[1234] Similar name in Database overwritten

Postby poetter » Sat Sep 29, 2007 7:30 am

Thats right
Image
User avatar
poetter
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 462
Joined: Sat Jun 30, 2007 9:41 pm
Location: Germany/Hamburg

[1234] Similar name in Database overwritten

Postby Subxero » Sat Sep 29, 2007 7:36 am

Subxero - Priest 70 Holy - Asphelt Knight Officer - Zul'jin Horde.
User avatar
Subxero
WR.net Artisan
WR.net Artisan
 
Posts: 234
Joined: Thu Jul 06, 2006 4:08 pm
Realm: Zul'jin (PvE) - US


Return to Archived

Who is online

Users browsing this forum: No registered users and 1 guest

cron