Page 1 of 1

PT Tournament Data Gone After Conversion to PostgreSQL

PostPosted: Thu Mar 06, 2008 11:59 pm
by 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.

Re: PT Tournament Data Gone After Conversion to PostgreSQL

PostPosted: Fri Mar 07, 2008 12:18 am
by 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?

Re: PT Tournament Data Gone After Conversion to PostgreSQL

PostPosted: Fri Mar 07, 2008 4:04 pm
by 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.

Re: PT Tournament Data Gone After Conversion to PostgreSQL

PostPosted: Fri Mar 07, 2008 4:08 pm
by 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.

Re: PT Tournament Data Gone After Conversion to PostgreSQL

PostPosted: Fri Mar 07, 2008 5:22 pm
by 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?

Re: PT Tournament Data Gone After Conversion to PostgreSQL

PostPosted: Fri Mar 07, 2008 5:38 pm
by 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.

Re: PT Tournament Data Gone After Conversion to PostgreSQL

PostPosted: Fri Mar 07, 2008 7:20 pm
by 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

Re: PT Tournament Data Gone After Conversion to PostgreSQL

PostPosted: Fri Mar 07, 2008 7:33 pm
by 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.

Re: PT Tournament Data Gone After Conversion to PostgreSQL

PostPosted: Sat Mar 08, 2008 12:18 pm
by natesteiner21
Sir, you are a gentleman and a scholar.

Thanks for your help.