Merge HUD not working and error message

[thorbahn]

Sometimes it works fine, but for some merge tournies the hud does not pop up and in the import window i get this message for each hand:

Merge: Unable to import hand (#4045520100133). Reason: Unable to execute query: COPY tourney_holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: invalid page header in block 3660 of relation "tourney_holdem_hand_player_statistics_primary_key" CONTEXT: COPY tourney_holdem_hand_player_statistics, line 9: "151628 154109......

thanks for any help!

[kraada]

Try doing a ReIndex in Database > Housekeeping.
If that doesn't fix the issue..
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.

Alternatively, create a new database and re-import the hand history files - that way any damaged files in the old database will not matter.