Page 1 of 1

Error: PokerStars: Unable to import hand (#136802091483)

PostPosted: Tue Jun 16, 2015 5:35 pm
by thant0s
I'm using the trial version of pokertracker.

It always worked fine until today:

When i started playing, i noticed the HUD was taking a long time to show up at the table (playing zoom), and sometimes wouldn't even appear for an entire hand.

Then I found out pokertracker was not importing a lot of hands that I played (like 50% of them were getting this error):

Error: PokerStars: Unable to import hand (#136802091483). Reason: Error: Unable to execute query: COPY cash_hand_histories FROM STDIN;; Reason: Error: (ERROR: could not read block 20344 in file "base/83607/83915": read only 0 of 8192 bytes CONTEXT: COPY cash_hand_histories, line 2 )

From what I searched it seems to be related to hard disk problems? I'm not sure...

I tried the ''rebuild cache'' and ''housekeeping'' options on the database management tab but they didn't work, i dont know what to do anymore.

Edit: Apparently its something related to my database. I tried creating a new one and it worked just fine. I still want to use the old one tho

Thank you for your time

Re: Error: PokerStars: Unable to import hand (#136802091483)

PostPosted: Wed Jun 17, 2015 2:50 am
by WhiteRider
That does indicate a problem with one of the files which make up your database - you can try the possible solutions listed here and that may recover your data.

Re: Error: PokerStars: Unable to import hand (#136802091483)

PostPosted: Wed Jun 17, 2015 11:28 am
by thant0s
Thanks! The second step listed in the link actually worked, i was already losing all hope :D