PokerTracker

Hey

When I create a db on another disk using the guidelines "_dave_" gave, it gives me the same import error as some of the other users in here had. The db is both active, default and have selected it as the played hand db in the autoimport tab.

If I create a whole new db in pt3, and thereby not having it on another disk, I don't get any errors.
I have gotten "_dave_"s guide to work in the beta 8 and 9 many times.
what can I do?

Code: Select all

E:\Program Files\PokerTracker 3\Processed\Played\FT20080411 $10 + $1 Sit & Go (45625974), Table 1 - 15-30 - No Limit Hold'em - Logged In As DesrAw.txt
2008/05/02 20:48:32:       Unable to import hand. 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: "1   300   1   1   1   5992683242   2008/04/11 18:43:53   2008/05/02 20:48:25   9   5   3   2   1500.00   1470.00   1500.00   900.0..." )
2008/05/02 20:48:32:       Unable to import hand. 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: "2   300   1   1   1   5992693524   2008/04/11 18:44:53   2008/05/02 20:48:25   9   2   0   0   1320.00   1500.00   0.00   0.00   75...." )
2008/05/02 20:48:32:       Unable to import hand. 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: "3   300   1   1   1   5992701291   2008/04/11 18:45:39   2008/05/02 20:48:25   9   0   0   0   1320.00   0.00   0.00   0.00   60.00   ..." )
2008/05/02 20:48:32:       Unable to import hand. 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: "4   300   1   1   1   5992703921   2008/04/11 18:45:55   2008/05/02 20:48:25   9   2   0   0   1320.00   1230.00   0.00   0.00   180..." )
2008/05/02 20:48:32:       Unable to import hand. 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: "5   300   1   1   1   5992709446   2008/04/11 18:46:27   2008/05/02 20:48:25   9   6   2   2   1380.00   1350.00   1170.00   1170...." )
2008/05/02 20:48:33:       Unable to import hand. 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: "6   300   1   1   1   5992718749   2008/04/11 18:47:22   2008/05/02 20:48:25   9   3   3   3   1380.00   1455.00   1455.00   1455...." )
2008/05/02 20:48:33:       Unable to import hand. 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: "7   300   1   1   1   5992727803   2008/04/11 18:48:15   2008/05/02 20:48:25   9   4   4   0   1380.00   1320.00   1320.00   0.00   ..." )
2008/05/02 20:48:33:       Unable to import hand. 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: "8   300   1   1   1   5992739953   2008/04/11 18:49:26   2008/05/02 20:48:25   9   0   0   0   1320.00   0.00   0.00   0.00   75.00   ..." )
2008/05/02 20:48:33:       Unable to import hand. 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: "9   300   1   1   1   5992744524   2008/04/11 18:49:52   2008/05/02 20:48:25   9   0   0   0   1320.00   0.00   0.00   0.00   75.00   ..." )
2008/05/02 20:48:33:       Unable to import hand. 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: "10   300   1   2   1   5992750614   2008/04/11 18:50:27   2008/05/02 20:48:25   9   3   2   0   1320.00   1425.00   1285.00   0.00..." )
2008/05/02 20:48:33:       Unable to import hand. 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: "11   300   1   2   1   5992761264   2008/04/11 18:51:29   2008/05/02 20:48:25   9   2   2   2   915.00   755.00   -0.00   -0.00   18..." )


_dave_s guide

cheers
DesrAw

Did you create the new database using the new schema? It looks like you created the database using the old schema...

Best regards,

Derek

aaah nice point. found the schema. will test it later.
thank you

cheers
DesrAw