I'm still waiting for the PT4 Import crash fix in the next beta, but I noticed something else in my log files.
I have a ton of the following messages :
2012/01/03 07:25:38.882 [00076]: [00000F94][PostgresConnection (Error)] Unable to execute query: UPDATE tourney_summary SET id_tourney_type = 200, date_start = '2010/04/13 20:26:57', date_end = '2010/04/13 20:26:57', hand_no_start = '42620597745', hand_no_end = '42620597745', cnt_players = 4, amt_buyin = 42107526.51, amt_fee = 0.40, currency = 'USD', amt_bounty = 842150.45 WHERE id_tourney = 2968;; Reason: Fatal Error (ERROR: numeric field overflow DETAIL: A field with precision 7, scale 2 must round to an absolute value less than 10^5. )
2012/01/03 07:25:38.882 [00000]: [00000F94][HandHistoryDatabaseImport] DatabaseVariables: Query(Error): Unable to execute query: UPDATE tourney_summary SET id_tourney_type = 200, date_start = '2010/04/13 20:26:57', date_end = '2010/04/13 20:26:57', hand_no_start = '42620597745', hand_no_end = '42620597745', cnt_players = 4, amt_buyin = 42107526.51, amt_fee = 0.40, currency = 'USD', amt_bounty = 842150.45 WHERE id_tourney = 2968;; Reason: Fatal Error (ERROR: numeric field overflow DETAIL: A field with precision 7, scale 2 must round to an absolute value less than 10^5. )
This is for about 5 PokerStars tournaments in my PT3 database. I checked the actual tournaments/hands and in fact see nothing wrong. E.g. the tournament for above errors simply shows a buy-in of $4.00 in PT3, so I'm wondering where this 42107526.51 is coming from. And I wasn't even aware there is an amt_bounty field as well (have never seen bounty-support in PT3).
