cant import hands

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

Moderator: Moderators

cant import hands

Postby Bitz0 » Tue Dec 04, 2012 7:25 pm

i had a few power outages last week while i was playing on several sites and running pt3, everything was working fine before that but ever since my computer shutoff twice from the power outage i always get this message when trying to import hands

PokerStars: Unable to import hand (#90129356583). Reason: Unable to execute query: COPY tourney_holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: index "thhps:idx2-id_player" contains unexpected zero page at block 0 HINT: Please REINDEX it. CONTEXT: COPY tourney_holdem_hand_player_statistics, line 1: "3558182 114593 114593 30 197 12007 2012/12/02 05:54:07 0 3 t t 1 t 0 f f f t f 0 f 0 f f f t f 0 f 0..." )

any help is much appreciated
Bitz0
 
Posts: 1
Joined: Thu Mar 26, 2009 8:40 pm

Re: cant import hands

Postby WhiteRider » Wed Dec 05, 2012 3:43 am

That sounds like the power failure may have broken something in your database. Usually this can be fixed by using the ReIndex option from Database > Housekeeping, so please try that first. I'd suggest using the default options and including Rebuild Cache as well, to make sure everything is correct in your database. This will take some considerable time if you have a large database so please schedule it when you're going to be away from your computer for a while, or at least not playing.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests