PT3 Crash when trying to add a variable

[jerr24jerr]

I want to see in the HUD the amount every player has won so far in that session. For this I'm trying to add a variable to Player Statistics. The variable I'm trying to add is

Code: Select all

Name: var_amt_session
Expression: lookup_sessioninfo_player('amt_won', id_player )

however, if I try to click on validate or apply PT3 crashes everytime.

the end of the log file is below.

Code: Select all

2008/10/15 23:24:10.390: [00003244][PostgresConnection] Connecting to database: PT3 DB
2008/10/15 23:24:10.406: [00003244][PostgresConnection] [0x0218f2f0] Successfully connected to: PT3 DB [26709600] (PostgreSQL version 80304)
2008/10/15 23:24:10.421: [00003244][PostgresConnection] Connecting to database: PT3 DB
2008/10/15 23:24:10.437: [00003244][PostgresConnection] [0x0218f950] Successfully connected to: PT3 DB [35191216] (PostgreSQL version 80304)
2008/10/15 23:24:11.046: [- Main -][PokerStarsOptions] Unable to access registry key
2008/10/15 23:24:11.093: [- Main -][Players] Buddies:
2008/10/15 23:24:11.093: [- Main -][Players] 0 buddies found
2008/10/15 23:24:13.968: [00000320][Query] Connecting to database: PokerTracker 3 Database
2008/10/15 23:24:13.968: [00000320][Query] Executing SQL:   SELECT id_player,   id_site,   player_name,   val_icon  FROM player  WHERE id_player > 0  AND id_player_alias = 0  AND id_player in (    SELECT DISTINCT holdem_table_session_summary.id_player    FROM     holdem_table_session_summary   WHERE  1=1 )  ORDER BY player_name_search asc
2008/10/15 23:24:13.984: [00000320][Query] Query execution time: 18.79456747 ms :   SELECT id_player,   id_site,   player_name,   val_icon  FROM player  WHERE id_player > 0  AND id_player_alias = 0  AND id_player in (    SELECT DISTINCT holdem_table_session_summary.id_player    FROM     holdem_table_session_summary   WHERE  1=1 )  ORDER BY player_name_search asc
2008/10/15 23:24:14.812: [00002800][QueryReportCtrl] Query load time: 672 ms
2008/10/15 23:24:14.953: [00002448][ThreadDestroyer::Entry] Beginning thread.
2008/10/15 23:25:29.609: [- Main -][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries/.xml
2008/10/15 23:25:31.921: [- Main -][App] Shutting down subsystems...
2008/10/15 23:25:31.921: [- Main -][System] Application exiting


what seems odd here is the "loading query file" line. It looks as if it is trying to access a file with unix and windows paths mixed. I am not sure if that's the reason for the crash though.

Thanks for the help.

[WhiteRider]

You won't be able to do this - the stats used in the HUD have to be in the 'holdem cash player statistics' section, and that section generates stats by going through the hands played by the player so you can't use the session database fields.
Hopefully this will be extended to allow this kind of stat.

[jerr24jerr]

Is that the reason for the crash?

[WhiteRider]

It may be, but it obviously shouldn't crash!
Please create a ticket about this on the Support system , and link to this thread in the reference field of the ticket so that we can investigate.