Discrepencies between results and statistics views

[PTPlayer64]

I can’t for the life of me work out why these two views don’t show the same C net won.
I can see the results view is using data from 6 additional tourneys (127 vs 121 for the statistics view), but I can’t see which filters are causing it to happen. As far as I’m aware all filters are off in both tabs.
Thanks for any help you can give me.

(The results view is the correct one by the way)

results.jpg

results view

(318.48 KiB) Downloaded 1713 times

results.jpg

results view

(318.48 KiB) Downloaded 1713 times

[Barlin63]

Same here and I was able to narrow it down to one tourney:

Statistics
[ img ]

Results
[ img ]

I remember it was a tournament which I purged. The hands disappeared but the Tourney stayed. If I try to purge it again it is invisible and it only shows in "Results". I guess you also purged some tourneys. It is the Tourney with the funny number 2012xxxxxxx.

[kraada]

Do you have the original hand history for the purged tournament still?

[PTPlayer64]

Yeah I've also been doing some digging and I've found one toureny that dosen't have any hand history associated with it. I didn't purge anything but somehow the data is missing. I guess I'll just have to get the hand history from stars. Thanks for your input though.

[Barlin63]

Sorry,
I do not have the hand history anymore. It was already a broken Tourney from Pokerstars in HM2 so I was glad to get rid of it. Question now is how to delete an empty handed tourney.

[WhiteRider]

I guess you don't see that tournament in the list when you purge?
You could try purging that day, and then re-importing the real tournaments from that day, although I'm not absolutely sure that would get rid of it. Something else which may work is to create a fake hand history for that tournament number and import it, and then that should let you purge it.
Alternatively, it may be possible to remove the summary information directly using PGAdmin or database queries, but that sort of thing is risky as it could affect the integrity of the data.
How big is this database overall?

[Barlin63]

M Db is rather small (298 tourneys) and just for testing. Before deleting with PG Admin I prefer to see the complete Db Schema to make sure that I don't do anything stupid. I will try to add some hands but I am afraid that it will result in a similar situation once I purge the Tourney.

[Barlin63]

Solved for me. I gave the tournament a bit of a strange Buy in and via the Menu Option Purge I went to the Advanced section to make a selection on the date and the strange Buy in and pressed purge. The tourney is now gone. I could however not see the Tourney in the list of tourneys in the purge dialog with the tournaments view. So I guess there is still a bug out there.

[WhiteRider]

That's good thinking!
We shouldn't end up with orphaned tournaments, of course, and we avoid that as much as possible but sometimes bad data can creep into a database given odd complications in the imported files. It's a pity you don't have the files anymore, but we'll keep an eye out for this.

[Barlin63]

Will there be something in the future to check the integrity of the database. Not only on a Db level but also to check if all the needed relations are in place. i should think that a Tourney without hands would violate the integrity.