Hi. I keep getting the following error on pt:
*********************************
PT Version: 2.16.03d
Error Date: 02/09/2008 18:50
Database Error: -1605
Error Text: SQLSTATE = 23000
[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that con
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 ( 368179, 368179, 11, {ts '2008-02-09 18:49:56'}, 3, 1.2500, 0.0000, 20216, {ts '2008-02-09 18:50:04'}, 'Golfcart (6 max)', '(did not show hand)', 20216, 1, 6, '5189389637', 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 ( 368179, 368179, 11, {ts '2008-02-09 18:49:56'}, 3, 1.2500, 0.0000, 20216, {ts '2008-02-09 18:50:04'}, 'Golfcart (6 max)', '(did not show hand)', 20216, 1, 6, '5189389637', 0 )
*********************************
Anyone know what is going on? i wanna try to reinstall pokertracker. What is the file that I keep so that the new installed version will have my database? i've done it once before, but forgot what file it would be
Thanks!