Cannot read hands/database anymore

[jlevu]

I've been using PT3 for awhile and it's been working fine, but today my comp froze and I had to hold the power button to turn it off. Now PT is no longer able to access all the hands in my database. When I auto import, I get this error:

Fatal Exception during Auto-Import process: Unable to execute query: INSERT INTO player VALUES (0, 0, '[Split Pot]', '[Split Pot]', 0, 0, 0, FALSE);; Reason: Fatal Error (ERROR: invalid page header in block 277 of relation "player" )

And when I hit the tournaments tab to look over hands, no players or hands show up, only this message:

Unable to execute query:
SELECT player.id_player,
player.id_site
player.player_name,
player.val_icon FROM player
WHERE player.id_player > 0
AND player.id_player_alias = 0
AND player.id_player in(
SELECT DISTINCT
tourney_holdem_hand_player_sta

[kraada]

There are two main reasons for this error. The first is a result of data corruption from a computer crash that requires reindexing your database. You can reindex your database from the Housekeeping menu.

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.

[jlevu]

So I tried to Reindex and got this error:

There were errors during the housekeeping process:
Unable to execute query: REINDEX DATABASE "PT3 DB"; Reason: Fatal Error (ERROR: invalid page header in block 7265 of relation "tourney_holdem_hand_summary" )
Unable to execute query: VACUUM;; Reason: Fatal Error (ERROR: invalid page header in block 7265 of relation "tourney_holdem_hand_summary" )
Unable to execute query: ANALYZE;; Reason: Fatal Error (ERROR: invalid page header in block 7265 of relation "tourney_holdem_hand_summary" )

Would re installing PT3 fix my problems? I'm not that attached to the data I have collected... it'll only take a week or so to get back enough hands to be useful.

[WhiteRider]

Reinstalling PT3 will not make any difference - this is an error in the database.
Did you try Kraada's second method?

The alternative is to create a new database and reimport your hands.