FTP new HH's tripping red errors in import status (b10)

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

FTP new HH's tripping red errors in import status (b10)

Postby DavidC » Fri May 02, 2008 5:46 am

I'm not sure why this is happening, but here's what I'm getting when I try to import the new FTP HH's in beta 10.

2008/05/02 04:55:29: Full Tilt: Unable to import hand (#xxx). Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: extra data after last expected column CONTEXT: COPY holdem_hand_summary, line 1: "11937 300 1 2 xxxx 2008/05/02 00:36:14 2008/05/02 04:55:29 2 2 2 2 7548.50 7448.50 7348.50 714..." )
DavidC
 
Posts: 26
Joined: Wed Mar 05, 2008 12:13 pm

Re: FTP new HH's tripping red errors in import status (b10)

Postby Josh » Fri May 02, 2008 9:52 am

You must create a new database with beta 10.
Josh
Site Admin
 
Posts: 6222
Joined: Sat Dec 08, 2007 6:03 pm

Re: FTP new HH's tripping red errors in import status (b10)

Postby DavidC » Fri May 02, 2008 5:34 pm

Sorry I should have specified that. I did create a new db, and set it to active and default database. However, I'll tell you how I got the HH's to import.

While FTP was running, I cut and pasted a bunch of .tmp files from the hand history dir to another directory (to try to save observed hands immediately after FTP's update).

This may be the source of the errors, but the amount of errors (massive) and the readability of the files (clear) are confusing me. I looks to me like the files should be just fine, I don't get it. I'm sorry I didn't include this info in my OP.
DavidC
 
Posts: 26
Joined: Wed Mar 05, 2008 12:13 pm

Re: FTP new HH's tripping red errors in import status (b10)

Postby DavidC » Fri May 02, 2008 5:37 pm

I also deleted my previous DB's, just to avoid confusion.
DavidC
 
Posts: 26
Joined: Wed Mar 05, 2008 12:13 pm

Re: FTP new HH's tripping red errors in import status (b10)

Postby APerfect10 » Sat May 03, 2008 12:33 am

Please zip the hand histories then send them to us via the Support system so that we can look into the issue.

Best regards,

Derek
APerfect10
Site Admin
 
Posts: 4489
Joined: Sat Dec 08, 2007 6:03 pm

Re: FTP new HH's tripping red errors in import status (b10)

Postby DavidC » Sat May 03, 2008 2:30 am

done ty.
DavidC
 
Posts: 26
Joined: Wed Mar 05, 2008 12:13 pm


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 11 guests