Database Error
Posted: Fri Aug 07, 2009 7:53 pmHi, I am getting tons of errors like the following when importing with PT2.
*********************************
PT Version: 2.17.03b
Error Date: 05/16/2009 22:22
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.
No changes made to database.
INSERT INTO tourney_game_players ( tourney_id, game_id, player_id, seat_number, button, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, when_folded, all_in, forced_all_in, won_hand, 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, pbet, 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, rfold, rbet, rcheck, rraise, rcall, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count, ante_amt, blind_amt ) VALUES ( 14588, 750013, 43044, 5, 4, 125.0000, 0.0000, 0.0000, 0.0000, 125.0000, 0.0000, 'Pre-flop', 0, 0, 0, 3, 4, 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, 43044, 0, 0, 0, 1255.0000, 25.0000, 100.0000 )
DataObject: d_game_players_tourney
Syntax In Error: INSERT INTO tourney_game_players ( tourney_id, game_id, player_id, seat_number, button, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, when_folded, all_in, forced_all_in, won_hand, 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, pbet, 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, rfold, rbet, rcheck, rraise, rcall, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count, ante_amt, blind_amt ) VALUES ( 14588, 750013, 43044, 5, 4, 125.0000, 0.0000, 0.0000, 0.0000, 125.0000, 0.0000, 'Pre-flop', 0, 0, 0, 3, 4, 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, 43044, 0, 0, 0, 1255.0000, 25.0000, 100.0000 )
*********************************
*********************************
PT Version: 2.17.03b
Error Date: 05/16/2009 22:22
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.
No changes made to database.
INSERT INTO tourney_game_players ( tourney_id, game_id, player_id, seat_number, button, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, when_folded, all_in, forced_all_in, won_hand, 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, pbet, 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, rfold, rbet, rcheck, rraise, rcall, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count, ante_amt, blind_amt ) VALUES ( 14588, 750013, 43044, 5, 4, 125.0000, 0.0000, 0.0000, 0.0000, 125.0000, 0.0000, 'Pre-flop', 0, 0, 0, 3, 4, 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, 43044, 0, 0, 0, 1255.0000, 25.0000, 100.0000 )
DataObject: d_game_players_tourney
Syntax In Error: INSERT INTO tourney_game_players ( tourney_id, game_id, player_id, seat_number, button, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, when_folded, all_in, forced_all_in, won_hand, 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, pbet, 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, rfold, rbet, rcheck, rraise, rcall, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count, ante_amt, blind_amt ) VALUES ( 14588, 750013, 43044, 5, 4, 125.0000, 0.0000, 0.0000, 0.0000, 125.0000, 0.0000, 'Pre-flop', 0, 0, 0, 3, 4, 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, 43044, 0, 0, 0, 1255.0000, 25.0000, 100.0000 )
*********************************
