Page 1 of 1

problem importing hands (ongame)

PostPosted: Fri May 16, 2008 11:32 am
by kyotoisok
i just tried to import all my old hands into the new pt3 but i got a lot of errors. (i exported all my pt2 hand histories to notepad files). all these hands would have shown up properly in pt2 so i don't know what the problem is.

pretty sure all the full tilt hands imported properly. the only problem was with the ongame ones.
(95% of my db is ongame)


here's a screen shot.. i can send more info if you need it.

[ img ]

i can pm an example .txt file that won't import.
here is the error message
Code: Select all
Unable to import hand. Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR:  value "2089872920" is out of range for type smallint CONTEXT:  COPY holdem_hand_summary, line 1, column id_limit: "2089872920" )


thanks

Re: problem importing hands (ongame)

PostPosted: Fri May 16, 2008 12:12 pm
by WhiteRider
Don't PM it - attach it to the Support system.
Thanks.

Re: problem importing hands (ongame)

PostPosted: Fri May 16, 2008 12:39 pm
by kyotoisok
done.

thanks!

Re: problem importing hands (ongame)

PostPosted: Sat May 17, 2008 10:45 am
by LouisCyphre
I encountered the exact same problem when converting my PT2 DB and get the quoted error message for every single hand.
What is the solution to this?

Re: problem importing hands (ongame)

PostPosted: Sat May 17, 2008 11:27 am
by Josh
I'll need to put out a release to fix the problem.