Poker tracker 3 fatal error

[mihninio]

I have this text in the importing hands box ( i'll copy/paste it ) : PartyGaming: Unable to import hand (#12001920579). Reason: Unable to execute query: COPY holdem_hand_player_detail FROM STDIN;; Reason: Fatal Error (ERROR: index "holdem_hand_player_detail_primary_key" contains unexpected zero page at block 9810 HINT: Please REINDEX it. CONTEXT: COPY holdem_hand_player_detail, line 2: "808535 18182 3 39 10 10.00 0.05 0.00 1.00 0.00 0.00

I don't know what to do!!

[mihninio]

And i have another message when the text above apears in the dialog box of poker tracker, this message is from windows : [b]Windows was unable to save all the data for the file C:\Program files\PostgreSQL\8.3\data\base\16403\18140.The data has been lost.This error may be caused by a failure of your computer hardware or network connection.Please try to save this file elsewhere. [/b]

[WhiteRider]

That sounds like it could be a file error in your database, possibly from a hard disk error.

First, please try running Database > Housekeeping with the ReIndex option ticked in addition to the defaults.

The second reason for this error is a result of faulty hardware. You can set PostgreSQL to ignore these errors by clicking Start --> Programs --> PostgreSQL --> Configuration Files --> Edit postgresql.conf. In the configuration file that appears, go to the bottom of the file and add the text “zero_damaged_pages = on” on a new line and then save and close the file. Click Start --> Programs --> PostgreSQL --> Reload Configuration and PostgreSQL will ignore the damaged data. If you continue to have problems with that hard drive, you should consider replacing it.

[mihninio]

Thanks very much i made the first thing you said and now it works perfectly.

[WhiteRider]

That's good to hear - thanks for letting us know!

[afardal]

Hi,

I have the same problem with PT4, but I can't run housekeeping, I'm guessing because I need the full version? My HUD is not working either, I suspect because of this.
Is there any way I can solve this problem without having to purchase any more products?

[kraada]

That functionality should exist in the trial and you can use the second method as well. Please give that second method a try first though if you're having trouble with getting housekeeping running.