Different stats in Player Summary and Player Sttistics

[maxp1981]

I have several players in my database where the amount of hands shown in the player summary window doesnt match the amount of hands shown in the player statistics window.

This logically leads to different numbers in most other columns.

I reduced both reports to the following 2 columns: Hands and Amounts Won, leading to the following queries:

(sum(holdem_table_session_summary.cnt_hands)), (sum( holdem_table_session_summary.amt_won )) FROM holdem_table_session_summary WHERE (holdem_table_session_summary.id_player = 1162) for the summary window

and

SELECT (count(holdem_hand_player_statistics.id_hand)), (sum(holdem_hand_player_statistics.amt_won)) FROM holdem_hand_player_statistics WHERE (holdem_hand_player_statistics.id_player = 1162) for the statistics window.


So far in all cases (not for all players) this occurs the number of hands in the summary tab is lower than the no. of hands in the statistics tab.

[Josh]

Did you have a crash during an import?

[maxp1981]

Ah yeah, that makes sense, hand already added but session summary not yet calculated.

I had to kill the PT process because when trying to autoimport a folder with subfolders it allocates more and more memory until nothing works anymore

[Josh]

How many directories/files were there?

[GoldnEagl]

Don't mean to hijack but this is kind of along the same lines, only with dollar amounts and not number of hands..

Regarding tournament statistics, PT3 seems to double the rake for every tournament and subtract that from the actual net amount won in some fields but not in others. i.e. in the 'Player Summary' window of the 'General' tab and the 'Winnings By Month' window of the 'Winnings' tab the 'Net Won' field is under by exactly double the actual total rake paid and consequently the ROI field is incorrect (but correct based on the incorrect 'Net Won' field, so your calculations seem to be correct). Eg. I imported four PokerStars $55+$5 SNGs to test, three of which I won and the fourth I didn't cash, so the actual 'Net Won' field should display +$502.50 but it displays +$482.50. These are the only two fields that are incorrect, and they are incorrect for every player in the database.

The Total line of the 'Winnings' tab displays all the correct statistics, however, and the 'Money Won' graph displays the correct series.

I just installed PT3 and PostgreSQL tonight on Vista Ultimate x86(versions are current) and I didn't have any problems setting up PostgreSQL or importing the HHs or summaries so it looks like a minor bug to me.

Not sure if you know about this already but..

[APerfect10]

Yes, this is a known issue which we have already resolved and will be fixed in the next beta release which should be out in the next few days. :)

Best regards,

Derek

[maxp1981]

About 50k files on 100 subfolders or so. But I tried to reduce the number of files and folders down to like 3 folders and 3k files, doesnt work also.

When i copy the files from the subfolders into the root folder it imports (only tested with the 3k files not with 50k).

Ah, its with the Partypoker autoimport im having this trouble with, if it matters..manual import works fine.

[Josh]

Auto-import is used to import hands while you play. No histories, other than those actively being generated or recently played, should be in the directories PT3 is auto-importing from.

[MacAnthony]

I actually have this issue with my own stats when I apply certain filters (even simple ones like site). It shows more in my summary. I don't recall having any crashes while importing. I've had the issue the last 3 betas. First noticed it with my graph since the legend listed a different number of stats than the summary did.

[Josh]

Please click the link that appears under the Player Statistics report when you have differing numbers after filtering. It explains the situation.