Import Error with PT

[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?

[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.

[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 )
*********************************

[orive002]

It looks to be working. After I deleted the hands I had to restart PT

[orive002]

Its actually wasn't working. It worked for a few imports but got messed up again

[ptrack pat]

See this FAQ, issue #2
http://www.pokertracker3.com/forums/vie ... =30&t=1377

[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?

[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?