Database erro -1605

Any support related posts should go here.

Database erro -1605

Postby bigmo24 » Fri May 02, 2008 11:51 pm

I'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......
bigmo24
 
Posts: 5
Joined: Fri May 02, 2008 11:31 pm

Re: Database erro -1605

Postby ptrack mike » Sat May 03, 2008 6:43 am

Install the latest PATCH, version 2.17.02 from this link (MAKE SURE YOU DOWNLOAD THE PATCH INSTALL, the second link on this page, and NOT the full version:
http://www.pokertracker3.com/products/PTH/download.php

Then, open only one instance of PT, use the Utilities > Repair A Poker Database option and then try the import again.
ptrack mike
 
Posts: 1731
Joined: Thu Feb 21, 2008 5:48 pm


Return to PTH Support

Who is online

Users browsing this forum: No registered users and 7 guests

cron
highfalutin