Error converting table - unable to convert PT2 to SQL

[hbundy]

Sorry to bother you - finally got postgres installed after your useful posts and tried to run conversion on PT2 data - got error message:

Error Crreating table - DATAWINDOW_PREFS

7-SQLstate = 42601
error - syntax error at or near "window"
error while executing the query

I got the same error when I tried to convert the database on my other computer! HELP

[ptrack pat]

What version of PostgreSQL did you install? If it's 8.4 you need to uninstall it and download either 8.2. or 8.3 because PT2 does not support 8.4.

[gp18089]

When I try to convert acess database to SQl I take the message:

Error creating index-player_idx_01

7-SQLSTATE=23505
ERROR:could not create unique index "player_idx_01"
Table contains duplicated values.;
Error while executing the query

Any ideas? Version 8.3

[ptrack pat]

When I try to convert acess database to SQl I take the message:

Error creating index-player_idx_01

7-SQLSTATE=23505
ERROR:could not create unique index "player_idx_01"
Table contains duplicated values.;
Error while executing the query

Any ideas? Version 8.3

That error would mean that the Access database you are trying to convert is corrupted.

[gp18089]

This database has about 300,000 hands and works fine as access with PT2. I want to convert it to pSQL and then to convert it to PT3 database to start work at PT3. Can I do something or should I forget the update?

[ptrack pat]

I would suggest instead of converting it in PT2 that you use the Utilities > Export Hand Histories To File option to export all the hands in it to text files which you can then manually import into PT3. The imports into PT3 are MUCH faster, it won't take any longer than the process of converting PT2 to PostgreSQL.

[gp18089]

What about my tournament summaries? I have made a backup for a few of them but not all. Could I request from Stars or i can export them from Poker Tracker? Thanks for the suggestion.

[ptrack pat]

The export has 2 tabs, one for ring games and one for tournaments. If you imported the Stars tournament summaries from emails then the tourney tab on that window will export those summaries as well which PT3 should be able to import.

[gp18089]

Unfortunately, it exports the hands since 04/14/2009 when it containes hands from 2006 from Pokerstars.

[ptrack pat]

Unfortunately, it exports the hands since 04/14/2009 when it containes hands from 2006 from Pokerstars.

If it's only exporting hands since 4/14/09 and not before then either you have some filters set on the export window or the data is corrupted. Since you had other db errors, this could be the problem. Have you been making regular backups of your data?