problem importing ongame hands

Any support related posts should go here.

problem importing ongame hands

Postby m1kko » Sun Sep 28, 2008 11:08 am

I am trying to import hands from ongame but it gives me the following error.
Error - duplicate seats found for game #P4-77472876-37.
This error is usually indicative of the hand history information being improperly recorded in the PokerRoom (or skin) database file.
I have tried creating new database, without result.
Thanks
m1kko
 
Posts: 2
Joined: Sun Jun 15, 2008 8:36 am

Re: problem importing ongame hands

Postby ptrack pat » Sun Sep 28, 2008 12:12 pm

Make sure you have the right SQLite drivers, install the drivers from this FAQ
viewtopic.php?f=30&t=1376
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: problem importing ongame hands

Postby m1kko » Sun Sep 28, 2008 12:26 pm

It didn't help, also I got more error messages:

PT Version: 2.17.03d
Error Date: 09/28/2008 19:26
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'zepekhino', 1, 47029, 7, 0, 1, 0 )
DataObject: d_player_names
Syntax In Error: INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'zepekhino', 1, 47029, 7, 0, 1, 0 )
*********************************

*********************************
PT Version: 2.17.03d
Error Date: 09/28/2008 19:26
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'zepekhino', 1, 47023, 7, 0, 1, 0 )
DataObject: d_player_names
Syntax In Error: INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'zepekhino', 1, 47023, 7, 0, 1, 0 )
*********************************

*********************************
PT Version: 2.17.03d
Error Date: 09/28/2008 19:26
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'zepekhino', 1, 47028, 7, 0, 1, 0 )
DataObject: d_player_names
Syntax In Error: INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'zepekhino', 1, 47028, 7, 0, 1, 0 )
*********************************

*********************************
PT Version: 2.17.03d
Error Date: 09/28/2008 19:26
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'wishpooshs', 1, 47019, 7, 0, 1, 0 )
DataObject: d_player_names
Syntax In Error: INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'wishpooshs', 1, 47019, 7, 0, 1, 0 )
*********************************
m1kko
 
Posts: 2
Joined: Sun Jun 15, 2008 8:36 am

Re: problem importing ongame hands

Postby ptrack pat » Sun Sep 28, 2008 2:39 pm

That's a different issue, see the FAQ, issue #2
viewtopic.php?f=30&t=1377
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 4 guests