Database erro -1605
Posted: Fri May 02, 2008 11:51 pmI'm getting the following error and no hands are being saved.
*********************************
PT Version: 2.17.00i
Error Date: 05/02/2008 22:16
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, flop_1, flop_2, flop_3, 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 ( 167702, 167702, 11, {ts '2008-05-02 23:11:02'}, 21, '3s', 'As', '4h', 102.0000, 3.0000, 8408, {ts '2008-05-02 22:16:35'}, 'Pine Run (6 max)', '(did not show hand)', 8408, 2, 5, '6265808880', 0 )
DataObject: d_game......
*********************************
PT Version: 2.17.00i
Error Date: 05/02/2008 22:16
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, flop_1, flop_2, flop_3, 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 ( 167702, 167702, 11, {ts '2008-05-02 23:11:02'}, 21, '3s', 'As', '4h', 102.0000, 3.0000, 8408, {ts '2008-05-02 22:16:35'}, 'Pine Run (6 max)', '(did not show hand)', 8408, 2, 5, '6265808880', 0 )
DataObject: d_game......
