PokerTracker

I had an Access type DB before, and I just converted the DB in a PostgreSQL.

But when I'm trying to import new HH in my PostgreSQL DB, I'm getting error message..

Exactly those :



*********************************
PT Version: 2.17.02a
Error Date: 07/07/2008 14:34
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key value violates unique constraint "game_players_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Kd', 'Qc', 'o', 12.0000, 0.0000, 0.0000, 0.0000, 12.0000, 16.0000, 'Y', 'KQo', 13, 12, 0, 1, 0, 1, 48738, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
DataObject: d_game_players
Syntax In Error: INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Kd', 'Qc', 'o', 12.0000, 0.0000, 0.0000, 0.0000, 12.0000, 16.0000, 'Y', 'KQo', 13, 12, 0, 1, 0, 1, 48738, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 07/07/2008 14:35
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key value violates unique constraint "game_players_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, when_folded, played_hand, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Kd', '2s', 'o', 2.0000, 0.0000, 0.0000, 0.0000, 2.0000, 0.0000, 'Pre-flop', 'Y', 'K2o', 13, 2, 0, 0, 0, 0, 48734, 0, 2, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
DataObject: d_game_players
Syntax In Error: INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, when_folded, played_hand, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Kd', '2s', 'o', 2.0000, 0.0000, 0.0000, 0.0000, 2.0000, 0.0000, 'Pre-flop', 'Y', 'K2o', 13, 2, 0, 0, 0, 0, 48734, 0, 2, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 07/07/2008 14:40
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key value violates unique constraint "game_players_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, final_hand, hand_rank_id, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, '8d', '7c', 'o', 8.0000, 12.0000, 0.0000, 0.0000, 20.0000, 27.2000, 'Y', 'high card ace', 1, '87o', 8, 7, 0, 1, 0, 1, 48740, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
DataObject: d_game_players
Syntax In Error: INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, final_hand, hand_rank_id, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, '8d', '7c', 'o', 8.0000, 12.0000, 0.0000, 0.0000, 20.0000, 27.2000, 'Y', 'high card ace', 1, '87o', 8, 7, 0, 1, 0, 1, 48740, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 07/07/2008 14:40
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key value violates unique constraint "game_players_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, final_hand, hand_rank_id, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Ac', '7s', 'o', 12.0000, 0.0000, 20.0000, 0.0000, 32.0000, 43.0000, 'Y', 'two pairs, aces and fives', 3, 'A7o', 14, 7, 0, 0, 0, 1, 48743, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
DataObject: d_game_players
Syntax In Error: INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, final_hand, hand_rank_id, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Ac', '7s', 'o', 12.0000, 0.0000, 20.0000, 0.0000, 32.0000, 43.0000, 'Y', 'two pairs, aces and fives', 3, 'A7o', 14, 7, 0, 0, 0, 1, 48743, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 07/07/2008 14:41
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key value violates unique constraint "game_players_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Kd', 'Qc', 'o', 12.0000, 0.0000, 0.0000, 0.0000, 12.0000, 16.0000, 'Y', 'KQo', 13, 12, 0, 1, 0, 1, 48738, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
DataObject: d_game_players
Syntax In Error: INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Kd', 'Qc', 'o', 12.0000, 0.0000, 0.0000, 0.0000, 12.0000, 16.0000, 'Y', 'KQo', 13, 12, 0, 1, 0, 1, 48738, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 07/07/2008 14:42
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key value violates unique constraint "game_players_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Kd', 'Qc', 'o', 12.0000, 0.0000, 0.0000, 0.0000, 12.0000, 16.0000, 'Y', 'KQo', 13, 12, 0, 1, 0, 1, 48738, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
DataObject: d_game_players
Syntax In Error: INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Kd', 'Qc', 'o', 12.0000, 0.0000, 0.0000, 0.0000, 12.0000, 16.0000, 'Y', 'KQo', 13, 12, 0, 1, 0, 1, 48738, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 07/07/2008 14:48
Database Error: -1
Error Text: Database transaction information not available.

Call SetTrans or SetTransObject function.
DataObject: d_dd_game_level
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 07/07/2008 14:48
Database Error: -1
Error Text: Database transaction information not available.

Call SetTrans or SetTransObject function.
DataObject: d_dd_game_level
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 07/07/2008 14:48
Database Error: -1
Error Text: Database transaction information not available.

Call SetTrans or SetTransObject function.
DataObject: d_dd_game_level
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 07/07/2008 14:51
Database Error: -1
Error Text: Database transaction information not available.

Call SetTrans or SetTransObject function.
DataObject: d_dd_game_level
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 07/07/2008 14:56
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key value violates unique constraint "game_players_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Kd', 'Qc', 'o', 12.0000, 0.0000, 0.0000, 0.0000, 12.0000, 16.0000, 'Y', 'KQo', 13, 12, 0, 1, 0, 1, 48738, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
DataObject: d_game_players
Syntax In Error: INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Kd', 'Qc', 'o', 12.0000, 0.0000, 0.0000, 0.0000, 12.0000, 16.0000, 'Y', 'KQo', 13, 12, 0, 1, 0, 1, 48738, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 07/07/2008 14:58
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key value violates unique constraint "game_players_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Kd', 'Qc', 'o', 12.0000, 0.0000, 0.0000, 0.0000, 12.0000, 16.0000, 'Y', 'KQo', 13, 12, 0, 1, 0, 1, 48738, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
DataObject: d_game_players
Syntax In Error: INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Kd', 'Qc', 'o', 12.0000, 0.0000, 0.0000, 0.0000, 12.0000, 16.0000, 'Y', 'KQo', 13, 12, 0, 1, 0, 1, 48738, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 07/07/2008 15:01
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key value violates unique constraint "game_players_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, when_folded, played_hand, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Kd', '2s', 'o', 2.0000, 0.0000, 0.0000, 0.0000, 2.0000, 0.0000, 'Pre-flop', 'Y', 'K2o', 13, 2, 0, 0, 0, 0, 48734, 0, 2, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
DataObject: d_game_players
Syntax In Error: INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, when_folded, played_hand, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Kd', '2s', 'o', 2.0000, 0.0000, 0.0000, 0.0000, 2.0000, 0.0000, 'Pre-flop', 'Y', 'K2o', 13, 2, 0, 0, 0, 0, 48734, 0, 2, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 07/07/2008 15:02
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key value violates unique constraint "game_players_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, final_hand, hand_rank_id, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, '8d', '7c', 'o', 8.0000, 12.0000, 0.0000, 0.0000, 20.0000, 27.2000, 'Y', 'high card ace', 1, '87o', 8, 7, 0, 1, 0, 1, 48740, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
DataObject: d_game_players
Syntax In Error: INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, final_hand, hand_rank_id, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, '8d', '7c', 'o', 8.0000, 12.0000, 0.0000, 0.0000, 20.0000, 27.2000, 'Y', 'high card ace', 1, '87o', 8, 7, 0, 1, 0, 1, 48740, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 07/07/2008 15:02
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key value violates unique constraint "game_players_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, final_hand, hand_rank_id, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Ac', '7s', 'o', 12.0000, 0.0000, 20.0000, 0.0000, 32.0000, 43.0000, 'Y', 'two pairs, aces and fives', 3, 'A7o', 14, 7, 0, 0, 0, 1, 48743, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
DataObject: d_game_players
Syntax In Error: INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, final_hand, hand_rank_id, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Ac', '7s', 'o', 12.0000, 0.0000, 20.0000, 0.0000, 32.0000, 43.0000, 'Y', 'two pairs, aces and fives', 3, 'A7o', 14, 7, 0, 0, 0, 1, 48743, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 07/07/2008 15:02
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key value violates unique constraint "game_players_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Kd', 'Qc', 'o', 12.0000, 0.0000, 0.0000, 0.0000, 12.0000, 16.0000, 'Y', 'KQo', 13, 12, 0, 1, 0, 1, 48738, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
DataObject: d_game_players
Syntax In Error: INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 4630, 8, 209287, 8, 'Kd', 'Qc', 'o', 12.0000, 0.0000, 0.0000, 0.0000, 12.0000, 16.0000, 'Y', 'KQo', 13, 12, 0, 1, 0, 1, 48738, 0, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.0000, 4630, 0, 0, 0, 400.0000 )
*********************************

Go to the Utilities/Database Maintenance and Options window.

Click on the database description text at the top left corner of the window.
Then hit the F11 key on your PC. This will cause another tab to appear
called "Orphaned Data". You will need to use the little arrow icons that
appear at the top right corner of the tab to scroll to see this new tab.

Click on the "RingCheck" button. This may take a little while to run
especially if you have a lot of hands so just let it come back and prompt
you when it's done. Once it comes back, click the "Fix Now" button. This
will run through and clean up all the orphaned records so that you can
import the hands again.

worked perfectly

thank you

Hi,

i'm running my PostgreSQL DB on a Linux Debian Server. I've got a similar problem like the Thread Creator. Can I do the steps which are discribed in the 2nd Thread from the command line or can i Use a Windows Remote GUI Tool to do this job ?

Thx for your help!
Stargate

PM me with the name and email address used to purchase PT2. I have no record of this name/email you used for your account.

ptrack pat wrote:PM me with the name and email address used to purchase PT2. I have no record of this name/email you used for your account.

I'm currently using the Trail of PT3 but my error is very similar:

Code: Select all

2008-07-20 12:11:16 CEST ZUSAMMENHANG: COPY holdem_hand_summary, Zeile 1: »682 300 1 13 7296786965 2008/07/20 07:37:04 2008/07/20 09:56:15 8 0 0 0 4.65 0.00 0.00 0.00 0.60 0.0...«
2008-07-20 12:11:17 CEST FEHLER: duplizierter Schlüssel verletzt Unique-Constraint »hhs-unique_hand_no«


("dublizierter Schlüssel verletzt Unique" is german and means: "DUPLICATE KEY VIOLATES UNIQUE CONSTRAIN")

This it the PT2 forum, you need post PT3 issues in that forum
http://www.pokertracker3.com/forums/viewforum.php?f=16