Error when importing +200k hands

Any support related posts should go here.

Error when importing +200k hands

Postby PoPr » Sun Oct 12, 2008 4:56 am

PT Version: 2.17.03
I am trying to import over 4000 HH files (a total of +200k hands) that I played at PS. I am using generic auto import, and have made an empty database to import these HH's into.
I left the import running over night and this morning I got the error message:

A database error has occured.

DBCode: -1605 Error Text: SQLSTATE = 23000

[Microsoft][ODBC Microsoft Access Driver] Your changes at the tabell couldn't be done, because the Index, the primarkey or the relation would content multiple Datas.

No changes made in database.

INSERT INTO players ( screen_name, treeview_icon, player:id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'Fussi', 1, 21415, 2, 0, 1, 0 )


Help?
PoPr
 
Posts: 7
Joined: Tue Apr 15, 2008 10:55 am

Re: Error when importing +200k hands

Postby ptrack pat » Sun Oct 12, 2008 10:18 am

What email was used to purchase PT2? I have no record of this one used for the site.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Error when importing +200k hands

Postby PoPr » Sun Oct 12, 2008 10:57 am

PM sent about the email.
PoPr
 
Posts: 7
Joined: Tue Apr 15, 2008 10:55 am

Re: Error when importing +200k hands

Postby ptrack pat » Sun Oct 12, 2008 1:26 pm

The only time I've seen this kind of error is if you possibly had more than one instance of PT running and didn't realize it. Try restarting the computer, opening just one instance of PT and doing the import again.

I guess another possible thing that could cause it would be if you had aliases assigned to a particular player and somehow those 2 names ended up playing in the same hand together. But I think that would have caused an error on a different table name.
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