problems with ipoker and PTO 1.13.02

[Ratatuj]

Hi, I've downloaded PTO to try it. Yesterday it worked well, but today I got an error. ipoker.

PTO Version: 1.13.02
Error Date: 10/16/2008 23:36
Database Error: 7
Error Text: SQLSTATE = S1000
ERROR: duplicate key violates unique constraint "game_players_idx_01"

No changes made to database.

INSERT INTO game_players ( player_id, seat_number, game_id, button, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, when_folded, played_hand, final_hand, hand_rank_id, 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, hole_card_1, hole_card_2, hole_card_3, hole_card_4, suited, hole_cards, card_order1, card_order2, card_order3, card_order4, connector_hand2, connector_hand2g, connector_hand3, pair_hand2, trip_hand ) VALUES ( 2, 6, 44517, 8, 0.5000, 0.0000, 0.0000, 0.0000, 0.5000, 0.0000, 'After flop', 'Y', 'a pair of kings', 2, 0, 0, 0, 10658, 1, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 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.5000, 2, 0, 0, 0, 50.0000, 'Kd', '8c', '5c', '3c', 'xyyy', 'K853', 13, 8, 5, 3, 0, 0, 0, 0, 0 )
DataObject: d_game_players
Syntax In Error: INSERT INTO game_players ( player_id, seat_number, game_id, button, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, when_folded, played_hand, final_hand, hand_rank_id, 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, hole_card_1, hole_card_2, hole_card_3, hole_card_4, suited, hole_cards, card_order1, card_order2, card_order3, card_order4, connector_hand2, connector_hand2g, connector_hand3, pair_hand2, trip_hand ) VALUES ( 2, 6, 44517, 8, 0.5000, 0.0000, 0.0000, 0.0000, 0.5000, 0.0000, 'After flop', 'Y', 'a pair of kings', 2, 0, 0, 0, 10658, 1, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 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.5000, 2, 0, 0, 0, 50.0000, 'Kd', '8c', '5c', '3c', 'xyyy', 'K853', 13, 8, 5, 3, 0, 0, 0, 0, 0 )

[ptrack mike]

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 "Ring Check" 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.

[Ratatuj]

[ img ]

i see no database description text at the top left corner. is it "Database: OMAHA_PM"? then i hit it and pressed F11 but nothing happened, no other tab appeared. don't know what to do (

[ptrack mike]

Click the OMAHA_PM text. Then press the F11 key on the keyboard. Arrows will appear next to the Misc. tab.

Also, how many hands have you imported so far? It looks like you have a lot of sessions.

[Ratatuj]

thanks a lot. i don't know why, yesterday i pressed F11 a lot but had no result. today have reinstalled the program, pressed again and again had no result but finaly this tab appeared and i fixed the problem. i think i will bye this soft this week.

[Ratatuj]

Hi, as a registered user now I ask for help again )

[ img ]

and the same on every hand. that happend after I tried to import Full Tilt's hands in the ipoker base by mistake. after that ipoker hands can't import too.

[ptrack mike]

You can try reindexing as detailed here in the 4th post of this thread:
archives/PT2/viewtopic.php?t=13546&highlight=reindex+pgadmin

You can just reindex the HAND_HISTORIES table as that is the one causing the error.

[Ratatuj]

i'm a problem boy but i didn't find any Schemas in my pgAdmin )

[ img ]

[ptrack mike]

Click on your database name then the plus sign will appear allowing you to drill down to the schema.

[Ratatuj]

Thanks, your advice did help!