Page 1 of 1

Import Error with PT

PostPosted: Sun Apr 27, 2008 4:41 pm
by orive002
I played in some tournaments earlier which i rarely do and am now getting this import error

File Name
"C:\Program Files\Full Tilt Poker\HandHistory\MDBuyes\FT20080427 Satellite to FTOPS Event #15 (47068067), Table 2 - 10-20 - Pot Limit Hold'em - Logged In As MDBuyes.txt"

Error Message
"no button line found for tournament game #6196295532."

I deleted the hand histories for that tournament thinking maybe it would just skip over this but i am still getting it. Anyone know what I can do?

Re: Import Error with PT

PostPosted: Sun Apr 27, 2008 4:59 pm
by ptrack pat
This means that the hand histories created by Full Tilt are not formatted correctly. There isn't anything PT can do about these errors.

If you still get the error then you need to move this hand history file out of the hand history folder so PT doesn't attempt to keep importing it and giving the same error message every time.

Re: Import Error with PT

PostPosted: Sun Apr 27, 2008 5:45 pm
by orive002
I've deleted that hand history but am still getting an error. This message is written in the pterrorlog

Any idea?



PT Version: 2.16.03d
Error Date: 04/26/2008 06:08
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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, 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 ( 24788, 1, 430439, 3, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 'Pre-flop', 'Y', 0, 48727, 2, 6, 0, 0, 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, 0.0000, 24788, 0, 0, 0, 10.0500 )
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, 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 ( 24788, 1, 430439, 3, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 'Pre-flop', 'Y', 0, 48727, 2, 6, 0, 0, 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, 0.0000, 24788, 0, 0, 0, 10.0500 )
*********************************

Re: Import Error with PT

PostPosted: Sun Apr 27, 2008 7:06 pm
by orive002
It looks to be working. After I deleted the hands I had to restart PT

Re: Import Error with PT

PostPosted: Mon Apr 28, 2008 2:25 am
by orive002
Its actually wasn't working. It worked for a few imports but got messed up again

Re: Import Error with PT

PostPosted: Mon Apr 28, 2008 10:25 am
by ptrack pat

Re: Import Error with PT

PostPosted: Wed Apr 30, 2008 12:17 am
by orive002
I went to the sticky and was pretty sure that I had reached the maximum amount of hands for one database even though it was only around 300K hands. I started a new database and its still acting up. I'm still getting an error message, but it records some of my hands from a current session. Its really weird because its only some hands, and just ignores some of the others. What should i do?

Re: Import Error with PT

PostPosted: Wed Apr 30, 2008 8:47 am
by ptrack pat
Did you make the new database you created the "Dflt" database?
Did you close and restart PT afterwards?
Did you click on the Observed Hands tab of the Full Tilt auto-import window and change the database listed there to be the new database you created?

highfalutin