Data base error

[Cuongster]

Hi PT support !

I use PT V2 since a while and I have many bugs but this data base error is recent. I don't know if there is a link with the size of my database (I have more than 200 000 hands history).

Here are the message errors in the pterrorlog.txt :

PT Version: 2.16.03d
Error Date: 11/18/2008 17:22
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][Pilote ODBC Microsoft Access] Argument non valide.

No changes made to database.

INSERT INTO game ( game_id, game_number, site_id, date_played, game_level_id, flop_1, flop_2, flop_3, turn, river, pot, rake, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, ub_game_number, ub_kill_game ) VALUES ( 494570, 494570, 11, {ts '2008-11-18 11:12:58'}, 5, 'Jd', '4c', '3h', '2s', '4h', 65.5000, 3.0000, 33482, {ts '2008-11-18 17:22:06'}, 'Painted Peak', 'two pairs, aces and fours', 33482, 3, 9, '9039397039', 0 )
DataObject: d_game
Syntax In Error: INSERT INTO game ( game_id, game_number, site_id, date_played, game_level_id, flop_1, flop_2, flop_3, turn, river, pot, rake, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, ub_game_number, ub_kill_game ) VALUES ( 494570, 494570, 11, {ts '2008-11-18 11:12:58'}, 5, 'Jd', '4c', '3h', '2s', '4h', 65.5000, 3.0000, 33482, {ts '2008-11-18 17:22:06'}, 'Painted Peak', 'two pairs, aces and fours', 33482, 3, 9, '9039397039', 0 )
*********************************

*********************************
PT Version: 2.16.03d
Error Date: 11/18/2008 18:40
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][Pilote ODBC Microsoft Access] Argument non valide.

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 ( 29555, 7, 495352, 6, 'Ks', '7c', 'o', 1.0000, 0.0000, 0.0000, 0.0000, 1.0000, 1.9000, 'Y', 'two pairs, queens and sevens', 3, 'K7o', 13, 7, 0, 0, 0, 1, 95363, 7, 8, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 1, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0.5000, 29555, 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 ( 29555, 7, 495352, 6, 'Ks', '7c', 'o', 1.0000, 0.0000, 0.0000, 0.0000, 1.0000, 1.9000, 'Y', 'two pairs, queens and sevens', 3, 'K7o', 13, 7, 0, 0, 0, 1, 95363, 7, 8, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 1, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0.5000, 29555, 0, 0, 0, 10.0000 )
*********************************

*********************************
PT Version: 2.16.03d
Error Date: 11/18/2008 18:40
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][Pilote ODBC Microsoft Access] Argument non valide.

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 ( 8820, 9, 495351, 7, 3.0000, 4.0000, 0.0000, 0.0000, 7.0000, 0.0000, 'After turn', 'Y', 0, 95427, 7, 9, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 1, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1.0000, 8820, 0, 1, 0, 88.3000 )
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 ( 8820, 9, 495351, 7, 3.0000, 4.0000, 0.0000, 0.0000, 7.0000, 0.0000, 'After turn', 'Y', 0, 95427, 7, 9, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 1, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1.0000, 8820, 0, 1, 0, 88.3000 )
*********************************

There are more and more message like this.

The problem is that my PT "freeze" while I playing and doesn't continue to save hands :

[img=http://img264.imageshack.us/img264/7035/pt2databaseerror1ey2.th.jpg][img=http://img264.imageshack.us/images/thpix.gif]

[img=http://img508.imageshack.us/img508/6763/pt2databasesizetb1.th.jpg][img=http://img508.imageshack.us/images/thpix.gif]

When I compact the database, it works for a while but rebug after 1 or 2 hours of playing. I also use "repair database" tool.

What can I do ? Is my database too big ?

Thank you in advance for your help and support !

[ptrack pat]

See this FAQ, issue #2
viewtopic.php?f=30&t=1377