import problems every 15 minutes

[bean]

every 15 minutes my pt shuts down. i keep having import problems. i downloaded the newest patch and still problems. this is getting real fustrating. if u want me to send u hand history logs and all that stuff u have to walk me through it like im a 5 year old because i just dont understand this stuff.
thanks

[ptrack mike]

Are you getting import errors? If so, what do they say? Be specific about what is happening so we have some idea of how to respond.

What site?
What version number of PT2?
Are you using Vista?
Are you using any other programs at the same time, like PokerAce?
What type of database? Access or PostgreSQL?

[bean]

hi im running

acess, windows(not vista), pokerstars, (version 2.17.02a), also run poker ace hud. never had any problems ever. everytime it happens i shut it all down and repair the database which works for awhile.

and i get this all the time and many more daily

PT Version: 2.17.02
Error Date: 04/30/2008 21:51
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO player_winnings ( date_played, game_level_id, site_id, player_id, session_id, opponent_id, won_from, times_beat, real_player_id, real_opp_id ) VALUES ( {ts '2008-04-30 00:00:00'}, 5, 11, 15014, 47009, 21704, 1.7500, 1, 15014, 21704 )
DataObject: d_gr_player_winnings_new
Syntax In Error: INSERT INTO player_winnings ( date_played, game_level_id, site_id, player_id, session_id, opponent_id, won_from, times_beat, real_player_id, real_opp_id ) VALUES ( {ts '2008-04-30 00:00:00'}, 5, 11, 15014, 47009, 21704, 1.7500, 1, 15014, 21704 )
*********************************

*********************************
PT Version: 2.17.02
Error Date: 04/30/2008 21:51
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

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 ( 15429, 9, 223643, 9, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 'Pre-flop', 'Y', 0, 46845, 0, 9, 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, 15429, 0, 0, 0, 19.7500 )
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 ( 15429, 9, 223643, 9, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 'Pre-flop', 'Y', 0, 46845, 0, 9, 0, 0, 0, 0, 0, 0

[ptrack pat]

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

It tells you there what to do if the repair works for a while and then comes back.

[bean]

ok i did this Go to the Utilities/Database Maintenance and Options window. Click on the Hand History DB's tab at the end of the window. Click on the "Add File" button and point it to the hhdb_old.mdb file you just renamed. and now when i import ive lost my whole database. only shows todays hands. how can i delete everything before june 1 2008. i would like to have all of those being shown. also is this going to be a problem with pt3?

[ptrack pat]

I said it was issue #2 in that FAQ, not #1. Please read it again.

[bean]

oops i missed that. sorry :(

how do i undo the first step i did? thanks

[ptrack pat]

Rename the hhdb.mdb file to hhdb_xxx.mdb and then rename the other hh file (did you call it hhdb_old.mdb?) to hhdb.mdb.