is postgres the only option here?

[drewlo]

I understand that "invalid argument" errors can be fixed by renaming the database but I have done this several times and am getting import errors after only a few hours. Is Postgres the only solution for this?...I am "repairing the database" every few hours and it works a while before getting errors again...errors below..

Now I've also been getting the following errors...what are my options?


*********************************
PT Version: 2.17.03b
Error Date: 09/24/2008 11:04
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, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, when_folded, played_hand, 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 ( 7, 5, 749582, 6, 'Th', '8h', 's', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 'Pre-flop', 'Y', 'T8s', 10, 8, 1, 0, 0, 0, 88855, 1, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 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, 7251, 0, 0, 0, 65.2000 )
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, when_folded, played_hand, 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 ( 7, 5, 749582, 6, 'Th', '8h', 's', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 'Pre-flop', 'Y', 'T8s', 10, 8, 1, 0, 0, 0, 88855, 1, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 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, 7251, 0, 0, 0, 65.2000 )
*********************************

*********************************
PT Version: 2.17.03b
Error Date: 09/24/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 ( 42009, 2, 749990, 1, 0.2500, 0.0000, 0.0000, 0.0000, 0.2500, 0.0000, 'Pre-flop', 'Y', 0, 88902, 5, 6, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 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.2500, 42009, 0, 0, 0, 41.4500 )
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 ( 42009, 2, 749990, 1, 0.2500, 0.0000, 0.0000, 0.0000, 0.2500, 0.0000, 'Pre-flop', 'Y', 0, 88902, 5, 6, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 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.2500, 42009, 0, 0, 0, 41.4500 )
*********************************

*********************************
PT Version: 2.17.03b
Error Date: 09/24/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 ( game_id, game_number, site_id, date_played, game_level_id, flop_1, flop_2, flop_3, pot, rake, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, ub_kill_game ) VALUES ( 749989, 1375370289, 17, {ts '2008-09-24 21:49:20'}, 22, '4s', 'Td', 'Ts', 1.2500, 0.2500, 7, {ts '2008-09-24 21:51:41'}, 'Daylami (max 6)', 'a pair of tens', 7251, 2, 5, 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, pot, rake, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, ub_kill_game ) VALUES ( 749989, 1375370289, 17, {ts '2008-09-24 21:49:20'}, 22, '4s', 'Td', 'Ts', 1.2500, 0.2500, 7, {ts '2008-09-24 21:51:41'}, 'Daylami (max 6)', 'a pair of tens', 7251, 2, 5, 0 )
*********************************

*********************************
PT Version: 2.17.03b
Error Date: 09/24/2008 21:53
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO game ( game_id, game_number, site_id, date_played, game_level_id, pot, rake, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, ub_kill_game ) VALUES ( 749992, 1375372444, 17, {ts '2008-09-24 21:51:36'}, 22, 0.5000, 0.0000, 37113, {ts '2008-09-24 21:53:36'}, 'Pilsudski (max 6)', '(did not show hand)', 37113, 0, 5, 0 )
DataObject: d_game
Syntax In Error: INSERT INTO game ( game_id, game_number, site_id, date_played, game_level_id, pot, rake, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, ub_kill_game ) VALUES ( 749992, 1375372444, 17, {ts '2008-09-24 21:51:36'}, 22, 0.5000, 0.0000, 37113, {ts '2008-09-24 21:53:36'}, 'Pilsudski (max 6)', '(did not show hand)', 37113, 0, 5, 0 )
*********************************

*********************************
PT Version: 2.17.03b
Error Date: 09/24/2008 21:53
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

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, pot, rake, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, ub_kill_game ) VALUES ( 749989, 1375370289, 17, {ts '2008-09-24 21:49:20'}, 22, '4s', 'Td', 'Ts', 1.2500, 0.2500, 7, {ts '2008-09-24 21:53:50'}, 'Daylami (max 6)', 'a pair of tens', 7251, 2, 5, 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, pot, rake, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, ub_kill_game ) VALUES ( 749989, 1375370289, 17, {ts '2008-09-24 21:49:20'}, 22, '4s', 'Td', 'Ts', 1.2500, 0.2500, 7, {ts '2008-09-24 21:53:50'}, 'Daylami (max 6)', 'a pair of tens', 7251, 2, 5, 0 )
*********************************

*********************************
PT Version: 2.17.03b
Error Date: 09/24/2008 21:55
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO game ( game_id, game_number, site_id, date_played, game_level_id, pot, rake, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, ub_kill_game ) VALUES ( 749992, 1375372444, 17, {ts '2008-09-24 21:51:36'}, 22, 0.5000, 0.0000, 37113, {ts '2008-09-24 21:55:36'}, 'Pilsudski (max 6)', '(did not show hand)', 37113, 0, 5, 0 )
DataObject: d_game
Syntax In Error: INSERT INTO game ( game_id, game_number, site_id, date_played, game_level_id, pot, rake, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, ub_kill_game ) VALUES ( 749992, 1375372444, 17, {ts '2008-09-24 21:51:36'}, 22, 0.5000, 0.0000, 37113, {ts '2008-09-24 21:55:36'}, 'Pilsudski (max 6)', '(did not show hand)', 37113, 0, 5, 0 )
*********************************

*********************************
PT Version: 2.17.03b
Error Date: 09/24/2008 21:55
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

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, pot, rake, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, ub_kill_game ) VALUES ( 749989, 1375370289, 17, {ts '2008-09-24 21:49:20'}, 22, '4s', 'Td', 'Ts', 1.2500, 0.2500, 7, {ts '2008-09-24 21:55:49'}, 'Daylami (max 6)', 'a pair of tens', 7251, 2, 5, 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, pot, rake, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, ub_kill_game ) VALUES ( 749989, 1375370289, 17, {ts '2008-09-24 21:49:20'}, 22, '4s', 'Td', 'Ts', 1.2500, 0.2500, 7, {ts '2008-09-24 21:55:49'}, 'Daylami (max 6)', 'a pair of tens', 7251, 2, 5, 0 )

[ptrack pat]

See this FAQ, issue #2, NOT #1 which involves renaming the hand history database. If the repair doesn't work, it tells you what to do...
viewtopic.php?f=30&t=1377