PokerStars tournament import error (too long level code)

[mmore1q3]

When I managed to get upto the level 28 in a tournament on Sunday, PTO 1.13.05e started throwing import errors.

Pokerstars uses roman numerals for tournament levels in hand histories, and level 28 is 'XXVIII' and is thus 6 characters long, and that seems to cause the import error.

I pondered about the problem for a few minutes and then found the exact problem (too long level code for the field) and invented a mitigating solution which also verfies the reason for the error:
Manually editing the hand history for a shorter level code (e.g. XXVII), enables PTO to import the hands of that level.

SQL error from postgreSQL seems to directly point to reason being field-length of only 5 characters, and when I checked the table through pgAdmin, it showed the field to be 5 characters long.

*********************************
PTO Version: 1.13.05e
Error Date: 12/22/2009 21:23
Database Error: 7
Error Text: SQLSTATE = 22001
ERROR: value too long for type character varying(5);
Error while executing the query

No changes made to database.

INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, player_id_low, real_player_id_low, low_possible ) VALUES ( 76, 5928, 3.6041302145e+10, {ts '2009-12-20 15:15:58'}, 36, 'XXVIII', 0, 20000.0000, 7705, {ts '2009-12-22 21:23:45'}, '221476102 4', '(did not show hand)', 7705, 0, 5, 0, -2, -2, 0 )
DataObject: d_game_tourney
Syntax In Error: INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, player_id_low, real_player_id_low, low_possible ) VALUES ( 76, 5928, 3.6041302145e+10, {ts '2009-12-20 15:15:58'}, 36, 'XXVIII', 0, 20000.0000, 7705, {ts '2009-12-22 21:23:45'}, '221476102 4', '(did not show hand)', 7705, 0, 5, 0, -2, -2, 0 )
*********************************

The exact hand-history row causing the import error is:

Code: Select all

PokerStars Game #36041302145: Tournament #221476102, $10+$1 USD Omaha Hi/Lo Pot Limit - Level XXVIII (5000/10000) - 2009/12/20 15:15:58 EET [2009/12/20 8:15:58 ET]

[ptrack mike]

Manually editing the hand history for a shorter level code (e.g. XXVII), enables PTO to import the hands of that level.

Yes, that is the solution. It is a rare situation that won't be a problem after Omaha gets added to PT3.