Unable to import HH's after prima update

[rivered]

I tried repairing my database twice but I still get these error messages.

*********************************
PT Version: 2.17.03
Error Date: 08/31/2008 13:00
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 ( 'treefrog17', 1, 15603, 6, 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 ( 'treefrog17', 1, 15603, 6, 0, 1, 0 )
*********************************

*********************************
PT Version: 2.17.03
Error Date: 08/31/2008 13:00
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 ( 'pimpcityusa', 1, 15601, 6, 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 ( 'pimpcityusa', 1, 15601, 6, 0, 1, 0 )
*********************************

[ptrack pat]

Read the FAQ, issue #2 again then, it tells you what to do if the repair doesn't work or the error comes back
viewtopic.php?f=30&t=1377

[rivered]

I'm trying to switch over to SQL, can you tell me which ODBC entry to use, and which encoding. Also where do I download the help files, I clicked on the help link in the corner of the SQl settings window, and went to the link, it was dead.

[ptrack pat]

PostgreSQL Unicode

The latest help files are linked at the bottom of this page
http://www.pokertracker.com/products/PTH/download.php

Latest PostgreSQL install directions
http://www.pokertracker.com/products/PT ... InstallSQL

[Lighto]

Pat, do you know what might be the problem for me? This new patch ain't fixing it.

[ptrack pat]

Pat, do you know what might be the problem for me? This new patch ain't fixing it.

It's worked fine for everyone else.

Are you using Vista?
Are you sure you are pointing PT to the right GameHistory.dat file?
What Prima site are you playing at? Right-click the desktop icon you use to start the software and select Properties from the popup menu. What is the value in the "Target" field?
Does the version number say 2.17.03 in the PT title bar?

[Lighto]

Im using XP.
Yes, Im sure Im pointing PT to the right Gamehistory.dat file. I've played on unibet for a while and it was just now that it stopped working with the new update there.
Im playing on Unibet.
Not quite sure what you mean with the value in the "Target" field, but maybe you mean this C:\Poker\UnibetpokerMPP\MPPoker.exe ?

[ptrack pat]

Does the version # in the title bar of the PT window say 2.17.03?

Open the Prima auto-import window. Click the Enable Logging box. Start the timer.
Play some hands for about 10 minutes. Then click the View Log link and copy/paste the text of the log file into a reply.

[Lighto]

Yes the PT window says 2.17.03

******************************
******************************
Logging started: 09/01/2008 07:15:37 PM
Prima Configured DB's: C:\Poker\UnibetpokerMPP\GameHistory.dat
Observed Settings: More Than Or Equal To from: 2 to: none
Main Settings: Database: My First Poker Tracker Database AR=off TMR=1 TREATAS=off
==============================
Retrieving from: C:\Poker\UnibetpokerMPP\GameHistory.dat
No new hands to load
Logging ends: 09/01/2008 07:15:38 PM
******************************
******************************
Logging started: 09/01/2008 07:16:37 PM
Prima Configured DB's: C:\Poker\UnibetpokerMPP\GameHistory.dat
Observed Settings: More Than Or Equal To from: 2 to: none
Main Settings: Database: My First Poker Tracker Database AR=off TMR=1 TREATAS=off
==============================
Retrieving from: C:\Poker\UnibetpokerMPP\GameHistory.dat
No new hands to load
Logging ends: 09/01/2008 07:16:38 PM
******************************
******************************
Logging started: 09/01/2008 07:17:37 PM
Prima Configured DB's: C:\Poker\UnibetpokerMPP\GameHistory.dat
Observed Settings: More Than Or Equal To from: 2 to: none
Main Settings: Database: My First Poker Tracker Database AR=off TMR=1 TREATAS=off
==============================
Retrieving from: C:\Poker\UnibetpokerMPP\GameHistory.dat
No new hands to load
Logging ends: 09/01/2008 07:17:38 PM
******************************
******************************
Logging started: 09/01/2008 07:18:37 PM
Prima Configured DB's: C:\Poker\UnibetpokerMPP\GameHistory.dat
Observed Settings: More Than Or Equal To from: 2 to: none
Main Settings: Database: My First Poker Tracker Database AR=off TMR=1 TREATAS=off
==============================
Retrieving from: C:\Poker\UnibetpokerMPP\GameHistory.dat
No new hands to load
Logging ends: 09/01/2008 07:18:38 PM
******************************
******************************
Logging started: 09/01/2008 07:19:38 PM
Prima Configured DB's: C:\Poker\UnibetpokerMPP\GameHistory.dat
Observed Settings: More Than Or Equal To from: 2 to: none
Main Settings: Database: My First Poker Tracker Database AR=off TMR=1 TREATAS=off
==============================
Retrieving from: C:\Poker\UnibetpokerMPP\GameHistory.dat
No new hands to load
Logging ends: 09/01/2008 07:19:38 PM
******************************
******************************
Logging started: 09/01/2008 07:20:38 PM
Prima Configured DB's: C:\Poker\UnibetpokerMPP\GameHistory.dat
Observed Settings: More Than Or Equal To from: 2 to: none
Main Settings: Database: My First Poker Tracker Database AR=off TMR=1 TREATAS=off
==============================
Retrieving from: C:\Poker\UnibetpokerMPP\GameHistory.dat
No new hands to load
Logging ends: 09/01/2008 07:20:38 PM
******************************
******************************
Logging started: 09/01/2008 07:21:38 PM
Prima Configured DB's: C:\Poker\UnibetpokerMPP\GameHistory.dat
Observed Settings: More Than Or Equal To from: 2 to: none
Main Settings: Database: My First Poker Tracker Database AR=off TMR=1 TREATAS=off
==============================
Retrieving from: C:\Poker\UnibetpokerMPP\GameHistory.dat
No new hands to load
Logging ends: 09/01/2008 07:21:38 PM
******************************
******************************
Logging started: 09/01/2008 07:22:38 PM
Prima Configured DB's: C:\Poker\UnibetpokerMPP\GameHistory.dat
Observed Settings: More Than Or Equal To from: 2 to: none
Main Settings: Database: My First Poker Tracker Database AR=off TMR=1 TREATAS=off
==============================
Retrieving from: C:\Poker\UnibetpokerMPP\GameHistory.dat
No new hands to load
Logging ends: 09/01/2008 07:22:38 PM
******************************
******************************
Logging started: 09/01/2008 07:23:38 PM
Prima Configured DB's: C:\Poker\UnibetpokerMPP\GameHistory.dat
Observed Settings: More Than Or Equal To from: 2 to: none
Main Settings: Database: My First Poker Tracker Database AR=off TMR=1 TREATAS=off
==============================
Retrieving from: C:\Poker\UnibetpokerMPP\GameHistory.dat
No new hands to load
Logging ends: 09/01/2008 07:23:38 PM
******************************
******************************
Logging started: 09/01/2008 07:24:38 PM
Prima Configured DB's: C:\Poker\UnibetpokerMPP\GameHistory.dat
Observed Settings: More Than Or Equal To from: 2 to: none
Main Settings: Database: My First Poker Tracker Database AR=off TMR=1 TREATAS=off
==============================
Retrieving from: C:\Poker\UnibetpokerMPP\GameHistory.dat
No new hands to load
Logging ends: 09/01/2008 07:24:38 PM
******************************
******************************
Logging started: 09/01/2008 07:25:38 PM
Prima Configured DB's: C:\Poker\UnibetpokerMPP\GameHistory.dat
Observed Settings: More Than Or Equal To from: 2 to: none
Main Settings: Database: My First Poker Tracker Database AR=off TMR=1 TREATAS=off
==============================
Retrieving from: C:\Poker\UnibetpokerMPP\GameHistory.dat
No new hands to load
Logging ends: 09/01/2008 07:25:38 PM
******************************
******************************
Logging started: 09/01/2008 07:26:38 PM
Prima Configured DB's: C:\Poker\UnibetpokerMPP\GameHistory.dat
Observed Settings: More Than Or Equal To from: 2 to: none
Main Settings: Database: My First Poker Tracker Database AR=off TMR=1 TREATAS=off
==============================
Retrieving from: C:\Poker\UnibetpokerMPP\GameHistory.dat
No new hands to load
Logging ends: 09/01/2008 07:26:38 PM
******************************
******************************
Logging started: 09/01/2008 07:27:38 PM
Prima Configured DB's: C:\Poker\UnibetpokerMPP\GameHistory.dat
Observed Settings: More Than Or Equal To from: 2 to: none
Main Settings: Database: My First Poker Tracker Database AR=off TMR=1 TREATAS=off
==============================
Retrieving from: C:\Poker\UnibetpokerMPP\GameHistory.dat
No new hands to load
Logging ends: 09/01/2008 07:27:38 PM

[ptrack pat]

If the GameHistory.dat file is growing in size then the only other thing I can think is that the hand history text is not being written in English. Is English your default language on this site? It not, I would suggest to uninstall the Unibet software and reinstall it and choose English as the default language when you do.