Page 1 of 1

Anybody Know What the Prob is Here

PostPosted: Tue Oct 28, 2008 10:05 pm
by dravensbook
Cant import any hands this error message keeps popping up. This is what is coming up in the PT error log. Ive never seen this before and have no idea what the prob. is. Thanks for your help


PT Version: 2.17.03b
Error Date: 10/25/2008 09:18
Database Error: -1605
Error Text: SQLSTATE = 23000
[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that con

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 ( 20, 4, 43237, 5, 'Qh', '2c', 'o', 0.1000, 0.0000, 0.0000, 0.0000, 0.1000, 0.0000, 'Pre-flop', 'Y', 'Q2o', 12, 2, 0, 0, 0, 0, 12058, 1, 6, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 2, 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.1000, 2405, 0, 0, 0, 10.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 ( 20, 4, 43237, 5, 'Qh', '2c', 'o', 0.1000, 0.0000, 0.0000, 0.0000, 0.1000, 0.0000, 'Pre-flop', 'Y', 'Q2o', 12, 2, 0, 0, 0, 0, 12058, 1, 6, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 2, 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.1000, 2405, 0, 0, 0, 10.0000 )
*********************************

*********************************
PT Version: 2.17.03b
Error Date: 10/25/2008 09:23
Database Error: -1605
Error Text: SQLSTATE = 23000
[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that con

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 ( 20, 3, 43237, 6, 'Qh', '9d', 'o', 0.1000, 0.2000, 0.4000, 0.8000, 1.5000, 0.0000, 'Y', 'two pairs, queens and nines', 3, 'Q9o', 12, 9, 0, 0, 0, 0, 12058, 3, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0, 2, 1, 0, 0, 0, 1, 0.1000, 2405, 0, 0, 0, 10.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 ( 20, 3, 43237, 6, 'Qh', '9d', 'o', 0.1000, 0.2000, 0.4000, 0.8000, 1.5000, 0.0000, 'Y', 'two pairs, queens and nines', 3, 'Q9o', 12, 9, 0, 0, 0, 0, 12058, 3, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0, 2, 1, 0, 0, 0, 1, 0.1000, 2405, 0, 0, 0, 10.0000 )
*********************************

Re: Anybody Know What the Prob is Here

PostPosted: Tue Oct 28, 2008 11:27 pm
by ptrack pat
What site are the hands from? Full Tilt? If so, the problem is their hand histories not PT. Some of the hands have multiple players listed in the same seat at the start of a hand. You would have to look in the hand history file and remove any hand you see like this in order for the other hands to import.

Re: Anybody Know What the Prob is Here

PostPosted: Wed Oct 29, 2008 1:42 am
by dravensbook
These hands are from Stars

Re: Anybody Know What the Prob is Here

PostPosted: Wed Oct 29, 2008 1:54 am
by dravensbook
I played one hand on a 0.1/0.2 just to see if it was still doing it and it is. Here is the hand history. I didnt see anything strange about the HH maybe you will though.



PokerStars Game #21584249716: Hold'em No Limit ($0.01/$0.02) - 2008/10/29 1:50:43 ET
Table 'Olbersia' 6-max Seat #5 is the button
Seat 1: watership02 ($2.45 in chips)
Seat 2: Honey508 ($2 in chips)
Seat 3: dravensbook ($1 in chips)
Seat 5: LITILLO08 ($1.84 in chips)
Seat 6: Nolax ($2.50 in chips)
Nolax: posts small blind $0.01
watership02: posts big blind $0.02
dravensbook: posts big blind $0.02
*** HOLE CARDS ***
Dealt to dravensbook [Ac 6d]
Honey508: folds
dravensbook: checks
LITILLO08: raises $0.02 to $0.04
Nolax: folds
watership02: folds
dravensbook: folds
Uncalled bet ($0.02) returned to LITILLO08
LITILLO08 collected $0.07 from pot
*** SUMMARY ***
Total pot $0.07 | Rake $0
Seat 1: watership02 (big blind) folded before Flop
Seat 2: Honey508 folded before Flop (didn't bet)
Seat 3: dravensbook folded before Flop
Seat 5: LITILLO08 (button) collected ($0.07)
Seat 6: Nolax (small blind) folded before Flop

Re: Anybody Know What the Prob is Here

PostPosted: Wed Oct 29, 2008 8:14 am
by ptrack pat
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.

Re: Anybody Know What the Prob is Here

PostPosted: Wed Oct 29, 2008 2:11 pm
by dravensbook
Ok did that and this message came up- The orphaned records have been cleaned up. However there appears to be a problem with your database where a relationship between 2 tables has been deleted somehow.

Re: Anybody Know What the Prob is Here

PostPosted: Wed Oct 29, 2008 3:28 pm
by ptrack pat
I would suggest then that you start a new database or convert the current database to PostgreSQL
http://www.pokertracker.com/products/PT ... InstallSQL

Re: Anybody Know What the Prob is Here

PostPosted: Wed Oct 29, 2008 3:51 pm
by dravensbook
Just started a new database. Just for future reference though do you have any idea what caused this problem.

highfalutin