Error: Help

[pj94z]

I recently re-installed PT and now I'm getting the following error msg when importing hands from full tilt poker.

I am running postgres DB. Latest ver of PT.

http://www.pjdarji.com/poker/pterror.jpg

[ptrack pat]

Restart the computer.

Install the latest patch if you don't have it already, version 2.17.01g from this link (MAKE SURE YOU DOWNLOAD THE PATCH INSTALL, the second link on this page, and NOT the full version:
http://www.pokertracker3.com/products/PTH/download.php

Then open just one instance of PT and see if you can import again.

[pj94z]

Yes - I already had the G patch installed prior to these problems.

I did reboot the PC and it seems to be working ...but I'm still got that same pop up error msg after a reboot.

But, it's not happening everytime now. I will reboot again a few times and monitor and see if this keeps happening.

will post back with results.

[pj94z]

rebooted pc a few times.

Still having this error msg everytime I try to import hands WHILE im playing at the tables.

I do not get this error when datamining.

any ideas ?

[pj94z]

Also, here is a list of my PT error log, if it helps ?

http://www.pjdarji.com/poker/pterror2.jpg

[ptrack pat]

If you are getting database errors then I need to know the most recent entry from the pterrorlog.txt file not a list of the errors caused by incorrectly formatted hands. Is it still the error about the duplicate key on the PLAYERS table?

Are you sure that you don't have multiple instances of PT running?

If you restart the computer, go to the File > Import Hand Histories/Tournament Summaries window, click the Select Files To Import button and then navigate to the Full Tilt hand history folder and select a file to import does it still give a database error?

[pj94z]

some recent entries from PT error log:



*********************************
PT Version: 2.17.01g
Error Date: 02/16/2008 15:18
Database Error: 7
Error Text: SQLSTATE = 42703
ERROR: column "turn_bet_ck_raése_n" of relation "game_players" does not exist;
Error while executing the query

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_raése_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 ( 34388, 9, 3223768, 2, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 'Pre-flop', 'Y', 0, 455527, 2, 8, 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, 34388, 0, 0, 0, 128.8500 )
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_raése_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 ( 34388, 9, 3223768, 2, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 'Pre-flop', 'Y', 0, 455527, 2, 8, 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, 34388, 0, 0, 0, 128.8500 )
*********************************

*********************************
PT Version: 2.17.01g
Error Date: 03/18/2008 00:20
Database Error: 101
Error Text: SQLSTATE = 08001
FATAL: the database system is starting up

Object: ue_opendatabase event of w_frame
*********************************

*********************************
PT Version: 2.17.01g
Error Date: 04/09/2008 23:12
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key violates unique constraint "player_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'thusspokematt', 1, 122470, 11, 0, 1, 0 )
DataObject: d_player_names
Syntax In Error: INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'thusspokematt', 1, 122470, 11, 0, 1, 0 )
*********************************

*********************************
PT Version: 2.17.01g
Error Date: 04/09/2008 23:19
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key violates unique constraint "player_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'pocketjokers33', 1, 122497, 11, 0, 1, 0 )
DataObject: d_player_names
Syntax In Error: INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'pocketjokers33', 1, 122497, 11, 0, 1, 0 )
*********************************

*********************************

[pj94z]

Not running more then 1 instance of PT.

I tried importing hands via tournament summaries like you said, it did work without errors.

[pj94z]

Would like to add that this problem ONLY started happening AFTER I re-installed PT a few days ago. Prior to that, it was all working fine.

Could this have anything to do with having 2 postgres DBs on my HDD?

[ptrack pat]

PT Version: 2.17.01g
Error Date: 04/09/2008 23:19
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key violates unique constraint "player_idx_01";

This last error is from 3 days ago. Is this the last error in the file or is there any from today?

It's odd that it would allow you to import manually but not via the auto-import window.

Does it give this error right away on the auto-import window or does it work for a time and then it errors out later on?

It shouldn't matter how many databases you have.