PokerTracker

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!!

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]

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.

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

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

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?

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.