Page 1 of 1

problem importing ongame hands

PostPosted: Sun Sep 28, 2008 11:08 am
by m1kko
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

Re: problem importing ongame hands

PostPosted: Sun Sep 28, 2008 12:12 pm
by ptrack pat
Make sure you have the right SQLite drivers, install the drivers from this FAQ
viewtopic.php?f=30&t=1376

Re: problem importing ongame hands

PostPosted: Sun Sep 28, 2008 12:26 pm
by m1kko
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 )
*********************************

Re: problem importing ongame hands

PostPosted: Sun Sep 28, 2008 2:39 pm
by ptrack pat
That's a different issue, see the FAQ, issue #2
viewtopic.php?f=30&t=1377