PT Tournament Data Gone After Conversion to PostgreSQL

[natesteiner21]

I made the conversion last night and once I got everything to work and started up PT all of my ring game stats where there but the tourney stuff was not. I've checked the filters and they are all off/not working. One thing that is strange is that in the misc. stats page and the position stats page I have information that is obviously left over from tournaments that I can't see at this point.

Another issue I'm having after the conversion is that the table overlay no longer works using the SQL database. It still works using the Access database but not the SQL database.

Any help would be appreciated.

P.S. I'm also using PAHUD.

[ptrack pat]

You need to tell PokerAce to use the new database...
http://www.pokertracker3.com/products/P ... gprefdbase

Did you get any errors with the conversion? Did it say in the status section that it completed successfully?
Are you sure there are no filters, did you click the Remove All Filters button on the Preferences tab?
This data looks OK when you open the old Access database?

[natesteiner21]

Actually now that you mention it I did encounter a couple of errors. I have the log file but it's all greek to me. I can attach it if you need me too. Should I redo the conversion?

I'm sure all of the filters are off.

The data looks fine in the Access database.

[ptrack pat]

Yes, do the conversion again. If it pops up with any error messages, please make sure to write them down before closing the prompt.

[natesteiner21]

Alright, I've done as asked. There is a lot of information on the error messages.

What exactly am I looking for? The first message is an error message the second message is actually a tournament history.

What info do you need?

[ptrack pat]

What is the first error? Is it something do to with an idex ?? Please just try to describe them as best as possible.

[natesteiner21]

Is there a way to post a picture?

--
A database error has occurred.

DBCode: 7 Error Text: SQLSTATE = 22P05
ERROR: character 0x9d of encoding "WIN1252" has no equivalent in "UTF8";
Error while executing the query

No changes made to database.

INSERT INTO players (player_id, screen_name, treeview_icon, main_site_id, tourney_player, tourney_hide_ind) VALUES (21413,
(there are a bunch of weird characters here...)

This error message was written to the error file: XXXXXXXXXXXXXXXXXXXXXXXXX

[ptrack pat]

Open the Utilities > PostgreSQL Settings window.

The ODBC Entry To Use field should be "PostgreSQL Unicode" and the Encoding should be "UNICODE"

Change these values, save the changes and then try to convert the db again.

[natesteiner21]

Sir, you are a gentleman and a scholar.

Thanks for your help.