Somehow my own player was duplicated, how do I merge the 2?

[Guest]

Hello all,

Does anybody have an idea on how I can merge 2 players in my database?

I have one player name that I use on 2 sites, on both PartyPoker and PokerStars I use the same ID. So within the PT3 database this ID should be id_player=1, right? Now somehow PT has created another player in the database, only this one has id_player 25770, same name as the other one though. And as a consequence my tournement stats are now becoming unpredictable because I never know what player PT places the results with.

Is there any way to merge these 2 players? The solution I can think of is a simple one: Update all tables keeping the id_player in it set id_player to 1 where id_player 25770 and then removing id_player 25770 from the player table.

Or is there a better way?

[Guest]

I think I just found that better way, simply use the "alias" function. Search for that second name and tell PT3 to add it to my first name. Problem solved.

[WhiteRider]

You found it!
That's the correct way to do this - players at different sites are separate even if they have the same ID, but you can merge them using aliases.

[Guest]

So this way it solved the representation issue. But now I'm left with the question: Why does PT sometimes create a duplicate name? I checked the player table and there are names there with sometimes 7 occurrences. Why is that? Doesn't PT check for the existence of a name first before adding it to the player table?

Maybe you don't know the answer to this, but it is now intriguing me, and I want to find the answer :)

[WhiteRider]

That shouldn't happen. Are all the duplicate names on the same site?
What version of PT3 are you using? I think this may have been fixed since Build 2, I vaguely remember someone else reporting this although I'm not sure, so try beta 15.
Download and install PT3.
Please read the Beta 15 release notes first.

[Guest]

Yes, these players are from the same site, otherwise they wouldn't be real doubles, would they? ;)

I'm using PT3 beta 15 for a while now. I'll check what the dates where these players were created. I'll get back to you on that one.

It seems like most players were created between half June and end of July. That was around the time I used either beta 14 or beta 15. Definitively áfter build 2. I don't see a "creation_date" field in the player file, is there a way to find that out using a SQL statement?

[WhiteRider]

Yes, these players are from the same site, otherwise they wouldn't be real doubles, would they? ;)

True, but you understand I have to check..

I'm using PT3 beta 15 for a while now. I'll check what the dates where these players were created. I'll get back to you on that one.

It seems like most players were created between half June and end of July. That was around the time I used either beta 14 or beta 15. Definitively áfter build 2. I don't see a "creation_date" field in the player file, is there a way to find that out using a SQL statement?

I don't think there is anything in the DB that tells you when the player was created, but you could look at the sessions tab and sort by date.

[Guest]

Indeed I did just that, and it seems that all the duplicates I find are between 13 Juny and 23 July. Maybe that's the period I had Beta14 installed? I think I installed Beta15 almost as soon as it was available, which was around July 21 or 22 if I remember correctly.

Anyway, if I find any duplicate created later than July 23 I'll let you know. In the meantime I'll go look for a way to de-duplicate my database, probably going to try the scripts used by the alias commands :)

[WhiteRider]

OK - good luck! But be careful in there - lots of bits of the database structure are tied together, so make sure you don't break anything!

You could always re-import into a new database, that would probably be quicker..

[Guest]

Except that I have just updated ALL my tourney results, until I can get those results out it is not a real option to re-import it all.

But to come to back to your question: It also happens with Beta 15! I just found one name in my cash games that has hands from early June on one player and early August on the other. Those are definitively both created via auto-import and by 2 different builds of PokerTracker.

Sorry, but it seems the duplication still exists in Beta 15.