PDA

View Full Version : Party - error importing hands today



ChipTrick
11-30-2011, 07:29 AM
Hi,

Yesterday all hh were imported fine, and today import cause errors, even with yesterday hands.
Postgres writes in log (event viewer) this:
ERROR: value too long for type character varying(20)
STATEMENT: insert into GameTypes (GameTypeDescription,BigBlind,SmallBlind,Ante,IsTo urney,PokerGameType,PokerGame, Currency_ID) Values ('$0.1/0.2499999990579200035500588922 NL',25,10,0,False,0,1,1); select currval('gametypes_gametype_ID_seq')

I play 25nl on party. Importing old 10nl hands gives:
ERROR: value too long for type character varying(20)
STATEMENT: insert into GameTypes (GameTypeDescription,BigBlind,SmallBlind,Ante,IsTo urney,PokerGameType,PokerGame, Currency_ID) Values ('$0.05/0.0999999996231680014200235569 NL',10,5,0,False,0,1,1); select currval('gametypes_gametype_ID_seq')

As far I remember I have done nothing with the system, what can affect on such problems with representation of floats. Just before today session I have tried to install HM2, but canceled installation in the middle.
Trying to fix the problem, I have reinstalled HM1, and made test import using newly created database - no success.

Pls, help. This problem stops me to play entirely.

ChipTrick
11-30-2011, 09:06 AM
Issue was fixed by changing all settings in "Regional and Language Options" to English, rebooting, and then changing settings back to my regional settings. It seems some kind of corrupted format setting cause the problem. But I suspect, this could be a bug anyway - relying on regional settings while parsing and storing hh.

Patvs
12-01-2011, 03:50 AM
set the date formatting of your computer to M/d/yyyy (and not to European default d/M/yyyy) with regional settings English (United States) and reboot, if you ever have this issue again.