Pokerstars auto import fatal error

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

Moderator: Moderators

Pokerstars auto import fatal error

Postby Handstand » Sun Aug 03, 2008 2:47 pm

I am having trouble importing hands in PT3 Beta 15 from pokerstars.
I just updated my old pre-release expired beta version with this new registered Beta 15 version that i downloaded 10 min ago without PostgreSQL. But it keeps firing these errors after i has completed the update of the DB.

2008/08/03 20:43:45: PokerStars: Unable to import hand (#19329079763). Reason: Unable to execute query: COPY tourney_holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: extra data after last expected column CONTEXT: COPY tourney_holdem_hand_summary, line 1: "118 100 1 5 3 19329079763 2008/08/03 18:42:35 2008/08/03 20:43:44 9 2 0 0 2210.00 2028.00 0.00 0.00 ..." )
2008/08/03 20:44:35: PokerStars: Unable to import hand (#19329105677). Reason: Unable to execute query: COPY tourney_holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: extra data after last expected column CONTEXT: COPY tourney_holdem_hand_summary, line 1: "119 100 1 5 3 19329105677 2008/08/03 18:43:34 2008/08/03 20:44:35 9 3 0 0 2135.00 3300.00 0.00 0.00 ..." )
2008/08/03 20:44:58: PokerStars: Unable to import hand (#19329128428). Reason: Unable to execute query: COPY tourney_holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: extra data after last expected column CONTEXT: COPY tourney_holdem_hand_summary, line 1: "120 100 1 5 3 19329128428 2008/08/03 18:44:25 2008/08/03 20:44:58 9 0 0 0 2135.00 0.00 0.00 0.00 375..." )
2008/08/03 20:45:52: PokerStars: Unable to import hand (#19329139065). Reason: Unable to execute query: COPY tourney_holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: extra data after last expected column CONTEXT: COPY tourney_holdem_hand_summary, line 1: "121 100 1 5 3 19329139065 2008/08/03 18:44:49 2008/08/03 20:45:52 9 0 0 0 2135.00 0.00 0.00 0.00 375..." )
Handstand
 
Posts: 15
Joined: Thu Apr 03, 2008 11:14 am

Re: Pokerstars auto import fatal error

Postby WhiteRider » Sun Aug 03, 2008 5:35 pm

Did you create a new database?
The pre-release database isn't compatible with the post-release importer.
You need to export your hands from your old database and import them into a newly created one.
See this FAQ: viewtopic.php?f=45&t=4849
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Pokerstars auto import fatal error

Postby Handstand » Mon Aug 04, 2008 6:23 am

Thanks for the fast reply - no - i did not create a new database, so obvious this is my next step - i will write the result in this thread once the new db creation has been completed.

Thanks - so fare ;)
Handstand
 
Posts: 15
Joined: Thu Apr 03, 2008 11:14 am


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests