An error while converting a PT2 DB

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

An error while converting a PT2 DB

Postby Leadan » Sat May 10, 2008 11:01 am

Here is the error log.
This is a minor error, that's not important if I can't fix it.

2008/05/10 16:51:35: Info: Import beginning
2008/05/10 16:51:35: Info: Converting PokerTracker v2 Database: FIRST_PT2_DATABASE_POSTGRESQL_PT3
2008/05/10 16:51:35: Info: Retrieving hand count from database...
2008/05/10 16:51:35: Info: Database contains 15,541 PokerStars hands.
2008/05/10 16:51:35: Info: Importing PokerStars hands...
2008/05/10 16:51:35: Info: Starting import of 14,380 hands...
2008/05/10 16:51:44: Error: Unable to import hand. Reason: Unable to execute query: COPY holdem_hand_player_detail FROM STDIN;; Reason: Fatal Error (ERROR: invalid input syntax for type numeric: "1.#J" CONTEXT: COPY holdem_hand_player_detail, line 183, column val_f_bet_made_pct: "1.#J" )
2008/05/10 16:52:46: Info: + Complete (15,541 hands, 1 errors, 0 duplicates)
2008/05/10 16:52:46: Info: Import complete. 15,541 hands in 1 file were imported. (1 errors, 0 duplicates)
2008/05/10 16:52:46: Info: Importing alias information...


Another question :

Can I save a postgreSQL db in my External HDD? With my old access db for PT2, there is the ptrack.mdb file, but with postgreSQL i don't know how to proceed.
Thanks.
Leadan
 
Posts: 7
Joined: Thu Apr 17, 2008 10:50 pm

Re: An error while converting a PT2 DB

Postby WhiteRider » Sun May 11, 2008 4:33 am

Leadan wrote:Here is the error log.
This is a minor error, that's not important if I can't fix it.

It just sounds like a corrupt hand history text, and it doesn't look like there's a way to identify the hand.
Josh, maybe you should write the hand number to the error window, if it can be determined?

Can I save a postgreSQL db in my External HDD? With my old access db for PT2, there is the ptrack.mdb file, but with postgreSQL i don't know how to proceed.

It's not straightforward, but read the Postgres FAQ.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: An error while converting a PT2 DB

Postby Josh » Sun May 11, 2008 10:32 am

If you don't mind, please export your PT2 PokerStars hands to disk and try to manually import them. If you get the same error, the PokerTracker.log file should show the last file it was importing before the error. Please attach that file to a support ticket and reference this thread.
Josh
Site Admin
 
Posts: 6222
Joined: Sat Dec 08, 2007 6:03 pm


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 39 guests

cron