Page 1 of 1

Manual hands import: value "2089872920" is out of range...

PostPosted: Sat May 17, 2008 6:05 am
by bender
I was importing hand histories to PT 3.00.1 (registered). I got a lot of identical errors:
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" )
All the errors are about "2089872920". The number is not in any history files though.
The DB was created by PT 3.00.1. My first attempt to import failed due to insufficient disk space, so I had a lot of duplicates during this import (when I encountered the "2089872920" problem).

Re: Manual hands import: value "2089872920" is out of range...

PostPosted: Sat May 17, 2008 6:11 am
by WhiteRider
Please attach some of these hand histories to the Support system.

Re: Manual hands import: value "2089872920" is out of range...

PostPosted: Tue May 20, 2008 5:08 am
by chuckk
I am getting the exact same errors. even the 2089872920" problem) is the same. Has this been resolved? Do you need me to do a support ticket since I am having the exact same error?


So far 82 errors out of 85,900 successful


Chuck

Re: Manual hands import: value "2089872920" is out of range...

PostPosted: Wed May 21, 2008 10:06 am
by WhiteRider
What sites are you both at?
Yes, please attach more hands, and link here - also give as much info as possible.
Thanks.

Re: Manual hands import: value "2089872920" is out of range...

PostPosted: Fri May 23, 2008 6:06 pm
by bender
Full Tilt. I am not sure what details you need. I submitted a ticket with hand history file.