Error messages can't import from Stars

[ryanghall]

Hi,

My PT has worked great for a couple of years but it's stopped importing hands as of today. I was playing various 114s/225s/335s SNGs on Stars and a Step 5 WSOP SNG.

Here are the error messages I received. Any help would be greatly appreciated as it's not working at all now. Thanks, Ryan:

*********************************
PT Version: 2.16.03d
Error Date: 03/08/2008 11:16
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, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, when_folded, all_in, forced_all_in, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, 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 ( 9116, 486946, 6, 9, 2, 'Ac', 'Ts', 'o', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 'Pre-flop', 0, 0, 'ATo', 14, 10, 0, 0, 0, 0, 2, 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, 6777, 0, 0, 0, 1500.0000, 0.0000, 0.0000 )
DataObject: d_game_players_tourney
Syntax In Error: INSERT INTO tourney_game_players ( tourney_id, game_id, player_id, seat_number, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, when_folded, all_in, forced_all_in, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, 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 ( 9116, 486946, 6, 9, 2, 'Ac', 'Ts', 'o', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 'Pre-flop', 0, 0, 'ATo', 14, 10, 0, 0, 0, 0, 2, 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, 6777, 0, 0, 0, 1500.0000, 0.0000, 0.0000 )
*********************************

*********************************
PT Version: 2.16.03d
Error Date: 03/08/2008 11:21
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'jawad1', 1, 62828, 2, 0, 0, 1 )
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 ( 'jawad1', 1, 62828, 2, 0, 0, 1 )
*********************************

*********************************
PT Version: 2.16.03d
Error Date: 03/08/2008 11:24
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 9113, 486953, 486953, {ts '2008-03-08 11:25:06'}, 4, 'VI', 0, 200.0000, 62820, {ts '2008-03-08 11:24:27'}, '80130123 1', '(did not show hand)', 62820, 0, 5, 0, '15829022525' )
DataObject: d_game_tourney
Syntax In Error: INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 9113, 486953, 486953, {ts '2008-03-08 11:25:06'}, 4, 'VI', 0, 200.0000, 62820, {ts '2008-03-08 11:24:27'}, '80130123 1', '(did not show hand)', 62820, 0, 5, 0, '15829022525' )
*********************************

*********************************
PT Version: 2.16.03d
Error Date: 03/08/2008 11:24
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 9114, 486961, 486961, {ts '2008-03-08 11:26:02'}, 4, 'VI', 0, 500.0000, 52270, {ts '2008-03-08 11:24:36'}, '80130537 1', '(did not show hand)', 52270, 0, 5, 0, '15829040525' )
DataObject: d_game_tourney
Syntax In Error: INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 9114, 486961, 486961, {ts '2008-03-08 11:26:02'}, 4, 'VI', 0, 500.0000, 52270, {ts '2008-03-08 11:24:36'}, '80130537 1', '(did not show hand)', 52270, 0, 5, 0, '15829040525' )
*********************************

*********************************
PT Version: 2.16.03d
Error Date: 03/08/2008 11:24
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, flop_1, flop_2, flop_3, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 9115, 486945, 486945, {ts '2008-03-08 11:20:31'}, 1, 'II', 0, '2d', '7c', '2s', 645.0000, 62825, {ts '2008-03-08 11:24:44'}, '80130938 1', '(did not show hand)', 62825, 2, 9, 0, '15828934875' )
DataObject: d_game_tourney
Syntax In Error: INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, flop_1, flop_2, flop_3, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 9115, 486945, 486945, {ts '2008-03-08 11:20:31'}, 1, 'II', 0, '2d', '7c', '2s', 645.0000, 62825, {ts '2008-03-08 11:24:44'}, '80130938 1', '(did not show hand)', 62825, 2, 9, 0, '15828934875' )
*********************************

*********************************
PT Version: 2.16.03d
Error Date: 03/08/2008 11:24
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'nomore loans', 1, 62829, 2, 0, 0, 1 )
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 ( 'nomore loans', 1, 62829, 2, 0, 0, 1 )
*********************************

*********************************
PT Version: 2.16.03d
Error Date: 03/08/2008 11:25
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, flop_1, flop_2, flop_3, turn, river, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 9112, 486945, 486945, {ts '2008-03-08 11:20:32'}, 17, 'III', 0, '6s', '2d', 'Qs', '8s', '7h', 300.0000, 57367, {ts '2008-03-08 11:25:07'}, '80127602 1', '(did not show hand)', 57367, 2, 8, 0, '15828935018' )
DataObject: d_game_tourney
Syntax In Error: INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, flop_1, flop_2, flop_3, turn, river, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 9112, 486945, 486945, {ts '2008-03-08 11:20:32'}, 17, 'III', 0, '6s', '2d', 'Qs', '8s', '7h', 300.0000, 57367, {ts '2008-03-08 11:25:07'}, '80127602 1', '(did not show hand)', 57367, 2, 8, 0, '15828935018' )
*********************************

*********************************
PT Version: 2.16.03d
Error Date: 03/08/2008 11:33
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 ( 9112, 486947, 50973, 6, 8, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 'Pre-flop', 0, 0, 0, 1, 7, 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, 50973, 0, 0, 0, 1830.0000, 0.0000, 0.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 ( 9112, 486947, 50973, 6, 8, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 'Pre-flop', 0, 0, 0, 1, 7, 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, 50973, 0, 0, 0, 1830.0000, 0.0000, 0.0000 )
*********************************

*********************************
PT Version: 2.16.03d
Error Date: 03/08/2008 11:34
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'jawad1', 1, 62828, 2, 0, 0, 1 )
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 ( 'jawad1', 1, 62828, 2, 0, 0, 1 )
*********************************

*********************************
PT Version: 2.16.03d
Error Date: 03/08/2008 11:34
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 9113, 486950, 486950, {ts '2008-03-08 11:31:25'}, 5, 'VIII', 0, 850.0000, 29115, {ts '2008-03-08 11:34:43'}, '80130123 1', '(did not show hand)', 29115, 0, 2, 0, '15829143482' )
DataObject: d_game_tourney
Syntax In Error: INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 9113, 486950, 486950, {ts '2008-03-08 11:31:25'}, 5, 'VIII', 0, 850.0000, 29115, {ts '2008-03-08 11:34:43'}, '80130123 1', '(did not show hand)', 29115, 0, 2, 0, '15829143482' )
*********************************

*********************************
PT Version: 2.16.03d
Error Date: 03/08/2008 11:34
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 9114, 486965, 486965, {ts '2008-03-08 11:36:34'}, 5, 'VIII', 0, 875.0000, 28486, {ts '2008-03-08 11:34:52'}, '80130537 1', '(did not show hand)', 28486, 0, 3, 0, '15829243847' )
DataObject: d_game_tourney
Syntax In Error: INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 9114, 486965, 486965, {ts '2008-03-08 11:36:34'}, 5, 'VIII', 0, 875.0000, 28486, {ts '2008-03-08 11:34:52'}, '80130537 1', '(did not show hand)', 28486, 0, 3, 0, '15829243847' )
*********************************

*********************************
PT Version: 2.16.03d
Error Date: 03/08/2008 11:35
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 9115, 486951, 486951, {ts '2008-03-08 11:32:42'}, 18, 'V', 0, 375.0000, 15281, {ts '2008-03-08 11:35:05'}, '80130938 1', '(did not show hand)', 15281, 0, 8, 0, '15829168750' )
DataObject: d_game_tourney
Syntax In Error: INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 9115, 486951, 486951, {ts '2008-03-08 11:32:42'}, 18, 'V', 0, 375.0000, 15281, {ts '2008-03-08 11:35:05'}, '80130938 1', '(did not show hand)', 15281, 0, 8, 0, '15829168750' )
*********************************

*********************************
PT Version: 2.16.03d
Error Date: 03/08/2008 11:35
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'nomore loans', 1, 62828, 2, 0, 0, 1 )
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 ( 'nomore loans', 1, 62828, 2, 0, 0, 1 )
*********************************

*********************************
PT Version: 2.16.03d
Error Date: 03/08/2008 11:35
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, flop_1, flop_2, flop_3, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 9116, 486946, 486946, {ts '2008-03-08 11:27:00'}, 16, 'I', 0, '5c', '9c', '3c', 140.0000, 62827, {ts '2008-03-08 11:35:27'}, '80132449 1', '(did not show hand)', 62827, 4, 9, 0, '15829059185' )
DataObject: d_game_tourney
Syntax In Error: INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, flop_1, flop_2, flop_3, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 9116, 486946, 486946, {ts '2008-03-08 11:27:00'}, 16, 'I', 0, '5c', '9c', '3c', 140.0000, 62827, {ts '2008-03-08 11:35:27'}, '80132449 1', '(did not show hand)', 62827, 4, 9, 0, '15829059185' )
*********************************

*********************************
PT Version: 2.16.03d
Error Date: 03/08/2008 11:35
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'MBUENO', 1, 62827, 2, 0, 0, 1 )
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 ( 'MBUENO', 1, 62827, 2, 0, 0, 1 )
*********************************

[ryanghall]

Oh, and it's PT2 I'm using unless it updates itself.

Ryan

[ptrack mike]

See #2 in this FAQ:
viewtopic.php?f=30&t=1377

[ryanghall]

Mike,

If the database is, in fact, full then can I delete ring game hands and still have room? Or is it the tournament section that is full?

Ryan

[ptrack mike]

Yes, if you delete a lot of hands and then Compact your database that should free up some space.