Page 1 of 1

Hands stopped importing.

PostPosted: Mon Mar 24, 2008 10:33 am
by dj11
After a tourney which gave me multiple errors like this ;

PokerStars: Unable to import hand (#16200228492. Reason: Unable to execute query: COPY tourney_holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: invalid page header in block 379 of relation "tourney_holdem_hand_summary" CONTEXT: COPY tourney_holdem_hand_summary, line 1: "1 100 241 1 402 16200228492 2008/03/23 23:54:54 2008/03/24 06:18:01 9 2 2 2 110.00 0 3225 1 32 5 37 ..." )

(In each error, only the line # changed, incrementally.)

Since then, as I start a new game I get a message that the first hand is importing, but no more hands import.
An oddity about this problem are that the time I spent in each of 5 tourneys is correct, but no hands show. This started on the 23rd and has continued this morning.

I'm more than willing to reload PT3, but don't want to have to manually re add my winnings.

Suggestions?

Re: Hands stopped importing.

PostPosted: Mon Mar 24, 2008 11:40 am
by dj11
I should add that I can update the tourney info, like what kind of game it was, i.e 5 table SnG, but manual entry of winnings is not saving.

Re: Hands stopped importing.

PostPosted: Mon Mar 24, 2008 2:07 pm
by APerfect10
Please send me your latest PostgreSQL log file which is located in your PostgreSQL\8.2\data\pg_log directory. Send it to me via the [url=http://www.pokertracker3.com/support/7yc]Support system[/url7yc]. It appears that your PostgreSQL database is corrupt. We should be able to zap this bad block and get around the problem.

Best regards,

Derek