Page 1 of 1

Import Error

PostPosted: Wed Nov 05, 2008 10:57 pm
by WaltrSobchak
I have been using PT2 forever and have never had a problem until now...all of a sudden i am getting the following error message...can anybody help?!?!

*********************************
PT Version: 2.17.01
Error Date: 02/27/2008 21:28
Database Error: 999
Error Text: SQLSTATE = IM008
[Microsoft][ODBC Driver Manager] Dialog failed
Object: ue_opendatabase event of w_frame
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 05/30/2008 01:10
Database Error: -1102
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'CRU'.

No changes made to database.

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

Re: Import Error

PostPosted: Wed Nov 05, 2008 11:41 pm
by ptrack pat
What's the latest error message?? These errors are months old.

Re: Import Error

PostPosted: Thu Nov 06, 2008 12:48 am
by WaltrSobchak
whoops, sorry...

********************************
PT Version: 2.17.02a
Error Date: 11/05/2008 21:44
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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 ( 29476, 4, 391062, 7, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 'Pre-flop', 'Y', 0, 66027, 2, 8, 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, 29476, 0, 0, 0, 47.1500 )
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 ( 29476, 4, 391062, 7, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 'Pre-flop', 'Y', 0, 66027, 2, 8, 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, 29476, 0, 0, 0, 47.1500 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 11/05/2008 21:44
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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 ( 391062, 391062, 11, {ts '2008-11-05 21:43:26'}, 2, '2c', '6s', '8c', '7h', 'Td', 52.9000, 2.6000, 29464, {ts '2008-11-05 21:44:34'}, 'Wallach', 'a pair of eights', 29464, 3, 9, '8831010282', 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 ( 391062, 391062, 11, {ts '2008-11-05 21:43:26'}, 2, '2c', '6s', '8c', '7h', 'Td', 52.9000, 2.6000, 29464, {ts '2008-11-05 21:44:34'}, 'Wallach', 'a pair of eights', 29464, 3, 9, '8831010282', 0 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 11/05/2008 21:45
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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 ( 18673, 5, 391054, 1, 1.0000, 0.0000, 0.0000, 0.0000, 1.0000, 0.0000, 'After flop', 'Y', 0, 65945, 4, 6, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 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, 1.0000, 18673, 0, 0, 0, 61.0600 )
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 ( 18673, 5, 391054, 1, 1.0000, 0.0000, 0.0000, 0.0000, 1.0000, 0.0000, 'After flop', 'Y', 0, 65945, 4, 6, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 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, 1.0000, 18673, 0, 0, 0, 61.0600 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 11/05/2008 21:45
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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 ( 18761, 1, 391054, 5, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 'Pre-flop', 'Y', 0, 65883, 3, 8, 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, 18761, 0, 0, 0, 249.6000 )
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 ( 18761, 1, 391054, 5, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 'Pre-flop', 'Y', 0, 65883, 3, 8, 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, 18761, 0, 0, 0, 249.6000 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 11/05/2008 21:46
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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 ( 18761, 2, 391055, 2, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 'Pre-flop', 'Y', 0, 65924, 0, 8, 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, 18761, 0, 0, 0, 206.9500 )
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 ( 18761, 2, 391055, 2, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 'Pre-flop', 'Y', 0, 65924, 0, 8, 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, 18761, 0, 0, 0, 206.9500 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 11/05/2008 21:51
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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 ( 412, 37091, 37091, {ts '2008-11-05 21:48:00'}, 12, 'N/A', 0, 975.0000, 25979, {ts '2008-11-05 21:51:00'}, 'Table 73', '(did not show hand)', 25979, 1, 9, 0, '8831086545' )
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 ( 412, 37091, 37091, {ts '2008-11-05 21:48:00'}, 12, 'N/A', 0, 975.0000, 25979, {ts '2008-11-05 21:51:00'}, 'Table 73', '(did not show hand)', 25979, 1, 9, 0, '8831086545' )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 11/05/2008 21:51
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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_game_number, ub_kill_game ) VALUES ( 391055, 391055, 11, {ts '2008-11-05 21:43:06'}, 2, 2.5000, 0.0000, 29357, {ts '2008-11-05 21:51:14'}, 'Inez (deep)', '(did not show hand)', 29357, 1, 9, '8831004830', 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_game_number, ub_kill_game ) VALUES ( 391055, 391055, 11, {ts '2008-11-05 21:43:06'}, 2, 2.5000, 0.0000, 29357, {ts '2008-11-05 21:51:14'}, 'Inez (deep)', '(did not show hand)', 29357, 1, 9, '8831004830', 0 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 11/05/2008 21:51
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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 ( 391061, 391061, 11, {ts '2008-11-05 21:47:21'}, 2, '9h', 'Kc', '9d', 'Qh', '7d', 14.0000, 0.7000, 0, {ts '2008-11-05 21:51:16'}, 'Montpeliar', '[--Split--]', 0, 2, 8, '8831075762', 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 ( 391061, 391061, 11, {ts '2008-11-05 21:47:21'}, 2, '9h', 'Kc', '9d', 'Qh', '7d', 14.0000, 0.7000, 0, {ts '2008-11-05 21:51:16'}, 'Montpeliar', '[--Split--]', 0, 2, 8, '8831075762', 0 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 11/05/2008 21:51
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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, 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 ( 391057, 391057, 11, {ts '2008-11-05 21:45:53'}, 2, '4h', '8s', '5h', 'Ts', 18.0000, 0.9000, 29467, {ts '2008-11-05 21:51:19'}, 'Ogden', '(did not show hand)', 29467, 3, 8, '8831051586', 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, 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 ( 391057, 391057, 11, {ts '2008-11-05 21:45:53'}, 2, '4h', '8s', '5h', 'Ts', 18.0000, 0.9000, 29467, {ts '2008-11-05 21:51:19'}, 'Ogden', '(did not show hand)', 29467, 3, 8, '8831051586', 0 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 11/05/2008 21:51
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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 ( 413, 37084, 37084, {ts '2008-11-05 21:43:03'}, 10, 'N/A', 0, '5h', 'Jc', '8h', 'Qd', '6d', 1600.0000, 13992, {ts '2008-11-05 21:51:25'}, 'Table 2', 'a pair of jacks', 13992, 4, 6, 0, '8831003954' )
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 ( 413, 37084, 37084, {ts '2008-11-05 21:43:03'}, 10, 'N/A', 0, '5h', 'Jc', '8h', 'Qd', '6d', 1600.0000, 13992, {ts '2008-11-05 21:51:25'}, 'Table 2', 'a pair of jacks', 13992, 4, 6, 0, '8831003954' )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 11/05/2008 21:51
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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 ( 414, 37085, 37085, {ts '2008-11-05 21:43:36'}, 9, 'N/A', 0, '9h', '2d', '7h', 1125.0000, 5594, {ts '2008-11-05 21:51:28'}, 'Table 2', '(did not show hand)', 5594, 2, 8, 0, '8831013182' )
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 ( 414, 37085, 37085, {ts '2008-11-05 21:43:36'}, 9, 'N/A', 0, '9h', '2d', '7h', 1125.0000, 5594, {ts '2008-11-05 21:51:28'}, 'Table 2', '(did not show hand)', 5594, 2, 8, 0, '8831013182' )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 11/05/2008 21:51
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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_game_number, ub_kill_game ) VALUES ( 391054, 391054, 11, {ts '2008-11-05 21:43:06'}, 2, 3.5000, 0.0000, 22185, {ts '2008-11-05 21:51:32'}, 'Welch', '(did not show hand)', 22185, 1, 9, '8831004626', 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_game_number, ub_kill_game ) VALUES ( 391054, 391054, 11, {ts '2008-11-05 21:43:06'}, 2, 3.5000, 0.0000, 22185, {ts '2008-11-05 21:51:32'}, 'Welch', '(did not show hand)', 22185, 1, 9, '8831004626', 0 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 11/05/2008 21:51
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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 ( 391056, 391056, 11, {ts '2008-11-05 21:44:42'}, 2, 'Js', '2s', '6h', '3c', '2h', 199.2000, 3.0000, 0, {ts '2008-11-05 21:51:35'}, 'Yeager', '[--Split--]', 0, 5, 9, '8831031527', 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 ( 391056, 391056, 11, {ts '2008-11-05 21:44:42'}, 2, 'Js', '2s', '6h', '3c', '2h', 199.2000, 3.0000, 0, {ts '2008-11-05 21:51:35'}, 'Yeager', '[--Split--]', 0, 5, 9, '8831031527', 0 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 11/05/2008 21:51
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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 ( 391062, 391062, 11, {ts '2008-11-05 21:50:07'}, 2, '5h', '8s', 'Ad', '2s', 'Ah', 14.5000, 0.7000, 29294, {ts '2008-11-05 21:51:38'}, 'Spanish Wells', '(did not show hand)', 29294, 2, 9, '8831121596', 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 ( 391062, 391062, 11, {ts '2008-11-05 21:50:07'}, 2, '5h', '8s', 'Ad', '2s', 'Ah', 14.5000, 0.7000, 29294, {ts '2008-11-05 21:51:38'}, 'Spanish Wells', '(did not show hand)', 29294, 2, 9, '8831121596', 0 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 11/05/2008 21:51
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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, 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 ( 391061, 391061, 11, {ts '2008-11-05 21:49:22'}, 2, '5h', '4h', 'Td', 'Kd', 22.5000, 1.1000, 29449, {ts '2008-11-05 21:51:39'}, 'Winery Ridge', '(did not show hand)', 29449, 2, 9, '8831109102', 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, 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 ( 391061, 391061, 11, {ts '2008-11-05 21:49:22'}, 2, '5h', '4h', 'Td', 'Kd', 22.5000, 1.1000, 29449, {ts '2008-11-05 21:51:39'}, 'Winery Ridge', '(did not show hand)', 29449, 2, 9, '8831109102', 0 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 11/05/2008 21:51
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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 ( 391064, 391064, 11, {ts '2008-11-05 21:46:40'}, 2, '3s', 'Qs', '8c', 'Th', 'Qh', 2.5000, 0.1000, 27561, {ts '2008-11-05 21:51:41'}, 'Harlem (deep)', 'a pair of queens', 27561, 2, 7, '8831064487', 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 ( 391064, 391064, 11, {ts '2008-11-05 21:46:40'}, 2, '3s', 'Qs', '8c', 'Th', 'Qh', 2.5000, 0.1000, 27561, {ts '2008-11-05 21:51:41'}, 'Harlem (deep)', 'a pair of queens', 27561, 2, 7, '8831064487', 0 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 11/05/2008 21:51
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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_game_number, ub_kill_game ) VALUES ( 391068, 391068, 11, {ts '2008-11-05 21:48:04'}, 2, 2.5000, 0.0000, 9451, {ts '2008-11-05 21:51:53'}, 'Wallach', '(did not show hand)', 9451, 1, 9, '8831087717', 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_game_number, ub_kill_game ) VALUES ( 391068, 391068, 11, {ts '2008-11-05 21:48:04'}, 2, 2.5000, 0.0000, 9451, {ts '2008-11-05 21:51:53'}, 'Wallach', '(did not show hand)', 9451, 1, 9, '8831087717', 0 )
*********************************

*********************************
PT Version: 2.17.02a
Error Date: 11/05/2008 21:54
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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 ( 391057, 1111735219, 5, {ts '2008-11-05 21:45:52'}, 2, 2.5000, 0.0000, 20090, {ts '2008-11-05 21:54:32'}, 'MORGAN CT', '(did not show hand)', 20090, 0, 7, 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 ( 391057, 1111735219, 5, {ts '2008-11-05 21:45:52'}, 2, 2.5000, 0.0000, 20090, {ts '2008-11-05 21:54:32'}, 'MORGAN CT', '(did not show hand)', 20090, 0, 7, 0 )
*********************************

Re: Import Error

PostPosted: Thu Nov 06, 2008 8:46 am
by ptrack pat
See the FAQ, issue #2
viewtopic.php?f=30&t=1377

Re: Import Error

PostPosted: Thu Nov 06, 2008 5:53 pm
by WaltrSobchak
Thanks for the replies, Pat. Quick question - If I start a new database, do i lose all of the info i have on other players in terms of PAHUD, etc...I'm sorry if this is a stupid question, but i've never had any problem with PT before and once I started using it over a year ago i've been on cruise control with it...Thanks for the help...

Re: Import Error

PostPosted: Thu Nov 06, 2008 8:33 pm
by ptrack pat
No, PokerAce can pull the stats from both databases, see here...
http://www.pokertracker.com/products/PA ... gprefdbase