PT3 suddenly doesnt import / Error msg

[soci]

I get fllwing msg and obv neither HUD nor the import works although I dont remember to have changed a thing.

thanks for the help



2011/02/22 16:03:12: Full Tilt: Hand Imported (#28430097633) from $3 + $0.30 Tournament (220845181), Table 4
2011/02/22 16:03:20: Full Tilt: Unable to import hand (#28430093186). Reason: Unable to execute query: COPY tourney_holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: could not read block 0 of relation 1663/16403/16940: read only 0 of 8192 bytes CONTEXT: COPY tourney_holdem_hand_player_statistics, line 1: "244292 217375 217375 0 12 41 2011/02/22 15:02:27 6 8 f t 0 f 0 f t f f f 0 f 0 f f f f f 0 f 0 f f f..." )
2011/02/22 16:03:20: Full Tilt: Hand Imported (#28430093186) from $3 + $0.30 KO Sit & Go (221080666), Table 3
2011/02/22 16:03:38: Full Tilt: Unable to import hand (#28430104238). Reason: Unable to execute query: COPY tourney_holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR

[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.

[soci]

thanks - computer indeed crashed before this happened.
so I went into houskeeping and chose re-index option which gave me fllwg error msg

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

any idea?
should I simply delete current database and create a new one & copy paste all the HH data in the new database?

[kraada]

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.

[soci]

I just created a NEW DB and set it as the active one.
It started importing HH from the ongoing mtt without an error msg and the HUD works fine now.
Guess the best way is to have it manually import the HH archive after the session is over..

thanks for your help - i like the tool just fine since I got it and am thankful for the prompt support.
hope ftp would apply same support standards :)

cheers