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.
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.