Database error message

[quaider]

Got this message when opening PTS:

A database error has occurred.
DBcode:-1605 Error Text: SQLSTATE=23000
[Microsoft][ODBC Microsoft Access Driver] The changes u 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 players ( screen_name,treeview_icon,player_id,main_site_id,hide_ind,ring_player,tourney_player) VALUES ('shineyshine',1,1235,2,0,1,0)

This error message was written to the error file: C:\Program Files \Pokertracker Stud\pterrorlog.txt. Please send this AND the hand history file that caused the error to pokertracker@comcast.net so that we can diagnose the problem. I went to Program files \ Pokertracker Stud but I couldn't find pterrorlog.txt?

Also how do I fing the hand history find that caused the error?

[ptrack mike]

I usually don't need to see the hand that caused this type of error.

Try using the Utilities > Repair A Poker Database option to fix the file.

[quaider]

I did that it seems to have worked.
I have like 13K hands in PTS , and I dont think I played that many , plus shouldnt the trial version have stopped me at 1K.

[ptrack mike]

I have like 13K hands in PTS , and I dont think I played that many , ...

You must have. PTS doesn't make up hands.

...plus shouldnt the trial version have stopped me at 1K.

The PTS trial doesn't work like that. It's a 30 day, unlimited hands trial.

[jbone85]

I am getting the same error, but repairing my database is not working. It just keeps reoccurring, please help!

[ptrack mike]

Is it the exact same error? Is this happening in Poker Tracker Stud or Hold'em?

[jbone85]

Is it the exact same error? Is this happening in Poker Tracker Stud or Hold'em?

Hold Em and it is not the same each time. It is the same message, but different hand histories. Just in case you need to know I just made another database, although I have never had this issue with ones in the past.

[ptrack mike]

If you don't mind, please create a new post in the PT Hold'em Support section so Pat can help troubleshoot the problem.
viewforum.php?f=28

[joeeich]

Hello, I am getting a similar database error, and I have tried to repair the database using two different ways (using PTS and using the Windows/Start/etc. one) and it's still a problem. The database error I get is "DBCode: -1206 Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database 'I'. It may not be a database that your application recognizes, or the file may be corrupt. No changes made to database".

This is happening with pretty much every file I try to load into PTS. Can you please help me figure out what's wrong. Thanks.

Joe

[ptrack mike]

Please see this FAQ:
viewtopic.php?f=42&t=14683