Import Error

Any support related posts should go here.

Import Error

Postby WaltrSobchak » Wed Nov 05, 2008 10:57 pm

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 )
*********************************
WaltrSobchak
 
Posts: 9
Joined: Thu Sep 11, 2008 1:08 am

Re: Import Error

Postby ptrack pat » Wed Nov 05, 2008 11:41 pm

What's the latest error message?? These errors are months old.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Import Error

Postby WaltrSobchak » Thu Nov 06, 2008 12:48 am

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 )
*********************************
WaltrSobchak
 
Posts: 9
Joined: Thu Sep 11, 2008 1:08 am

Re: Import Error

Postby ptrack pat » Thu Nov 06, 2008 8:46 am

See the FAQ, issue #2
viewtopic.php?f=30&t=1377
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Import Error

Postby WaltrSobchak » Thu Nov 06, 2008 5:53 pm

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...
WaltrSobchak
 
Posts: 9
Joined: Thu Sep 11, 2008 1:08 am

Re: Import Error

Postby ptrack pat » Thu Nov 06, 2008 8:33 pm

No, PokerAce can pull the stats from both databases, see here...
http://www.pokertracker.com/products/PA ... gprefdbase
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm


Return to PTH Support

Who is online

Users browsing this forum: No registered users and 1 guest