PokerTracker

2012/09/18 23:07:24: PokerStars: Unable to import hand (#86392364566). Reason: Unable to execute query: COPY tourney_holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: invalid input syntax for type numeric: "660,00" CONTEXT: COPY tourney_holdem_hand_summary, line 1, column amt_p_effective_stack: "660,00" )

just upgrade to Beta version 3.13 and that's the message I started getting after 5 imported hands... anyone knows what's up? :shock:

What operating system do you use?
What language are your regional settings in?
If you change regional settings to English does it work then?

Same problem here...I use WIN XP, regional settings in CZ. I changed it to ENG and tried to import hands manually but didnt help.
EDIT: now a new sng is being imported fine (under eng reg. settings)

me the same

yesterday before the beta update it works fine and after the update this....

2012/09/19 10:08:42: PokerStars: Unable to import hand (#86397214379). Reason: Unable to execute query: COPY tourney_holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: invalid input syntax for type numeric: "500,00" CONTEXT: COPY tourney_holdem_hand_summary, line 1, column amt_p_effective_stack: "500,00"

I`m using Win 7 Home Premium
and my language setting is english

Thanks for the information - we have found out what causes this and the development team are working on a fix.

In the meantime, it isn't the language as such which causes the issue - it is the regional settings for currency.
If you go to regional and language settings in Control Panel, and pick English for the Standards and Formats section, so that currency is shown as $1,000.00 (the currency symbol doesn't matter - it is the comma and decimal point which are important) and restart PT3 it should work OK.

Just a heads up: Im having the same issue with the mac version of PT3 under Lion (10.7.4, in german - pokerstars logs in english ofc).
It seem that sometimes quit / restart work for a couple of hands before it break again.

I changed the reginal settings but manual import of partypoker hands does not work.


2012/09/19 13:15:04: Import file: D:\PokerHandHistories\Pokertracker verwerkt\Pokertracker verwerkt 2012\PartyGaming\$3,500 Gtd (2679144) Table #4_3973151.txt
2012/09/19 13:15:04: Invalid date specified in hand history (Line #5)
2012/09/19 13:15:04: Invalid date specified in hand history (Line #43)
2012/09/19 13:15:04: Invalid date specified in hand history (Line #82)
2012/09/19 13:15:04: Invalid date specified in hand history (Line #131)
2012/09/19 13:15:04: Invalid date specified in hand history (Line #176)
2012/09/19 13:15:04: Invalid date specified in hand history (Line #215)
2012/09/19 13:15:04: Invalid date specified in hand history (Line #254)
2012/09/19 13:15:04: Invalid date specified in hand history (Line #301)
2012/09/19 13:15:04: Invalid date specified in hand history (Line #345)
2012/09/19 13:15:04: Invalid date specified in hand history (Line #390)
2012/09/19 13:15:04: Invalid date specified in hand history (Line #448)
2012/09/19 13:15:04: Invalid date specified in hand history (Line #494)

This is only on tournament hands. Cash hand are fine with the adjusted reginal settings.

it works for 5 minutes and then he shows me again

2012/09/19 13:20:58: PokerStars: Unable to import hand (#86402022228). Reason: Unable to execute query: COPY tourney_holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: invalid input syntax for type numeric: "320,00" CONTEXT: COPY tourney_holdem_hand_summary, line 1, column amt_p_effective_stack: "320,00" )

the same proplem to me. Windows XP, PL locale. Previous version worked fine. Problem starts after upgrading. Is here any way to downgrade?

Dutch:

Please send us that file via our support system so we can take a look at it.

Everyone else:

This is a known issue with the latest beta - if you change your regional settings as WhiteRider explains above that should fix things as a temporary measure until we have a new version available.