import error with DB on another disk

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

Moderator: Moderators

import error with DB on another disk

Postby DesrAw » Fri May 02, 2008 2:56 pm

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
DesrAw
 
Posts: 62
Joined: Sun Feb 17, 2008 11:39 am

Re: import error with DB on another disk

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

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

Best regards,

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

Re: import error with DB on another disk

Postby DesrAw » Sat May 03, 2008 8:25 am

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

cheers
DesrAw
DesrAw
 
Posts: 62
Joined: Sun Feb 17, 2008 11:39 am


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 6 guests