error message on 888 import

[OsullivanB]

Pacific Poker: Unable to import hand (#118935344). Reason: Unable to execute query: COPY holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: index "hhps:idx4-date_played" contains unexpected zero page at block 5273 HINT: Please REINDEX it. CONTEXT: COPY holdem_hand_player_statistics, line 1: "327652 14046 14046 0 6 59851 2011/09/17 13:18:47 9 9 f f 0 f 0 f t f f f 0 f 0 f f f f f 0 f 0 f f f..." )

This has suddenly popped up as a problem. I had made no changes prior to this and had been running PT3 with 888 for quite some time with no hitches.

Please advise

[WhiteRider]

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.

[OsullivanB]

Thanks. ReIndex solved the problem.

[WhiteRider]

Great - thanks for letting me know.