Hi,

For some reason I've started getting the following error today.

2009/03/19 14:46:10: Auto-Import beginning
2009/03/19 14:46:10: PokerStars: Starting auto-import.
2009/03/19 14:46:10: PokerStars: Found 1 files to monitor.
2009/03/19 14:46:10: PokerStars: Loading hand history file: C:\Program Files\PokerStars\HandHistory\JamieCarra\HH20090319 T149134159 No Limit Hold'em $4 + $0.40.txt
2009/03/19 14:46:14: PokerStars: Unable to import hand (#26127015490). Reason: Unable to execute query: COPY tourney_holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: could not read block 974 of relation 1663/16438/16970: Invalid argument CONTEXT: COPY tourney_holdem_hand_player_statistics, line 1: "68411 20871 20871 0 27 600 2009/03/19 15:39:35 4 f f 0 f 0 f t f f f 0 f 0 f f f f f 0 f 0 f f f f f..." )
2009/03/19 14:46:14: PokerStars: Hand Imported (#26127015490) from 149134159 20
2009/03/19 14:46:19: PokerStars: Unable to import hand (#26127045697). Reason: Unable to execute query: COPY tourney_holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: could not read block 974 of relation 1663/16438/16970: Invalid argument CONTEXT: COPY tourney_holdem_hand_player_statistics, line 1: "68412 20871 20871 0 27 600 2009/03/19 15:40:55 4 f f 0 f 0 f t f f f 0 f 0 f f f f f 0 f 0 f f f f f..." )
2009/03/19 14:46:19: PokerStars: Hand Imported (#26127045697) from 149134159 20
2009/03/19 14:46:25: PokerStars: Unable to import hand (#26127094651). Reason: Unable to execute query: COPY tourney_holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: could not read block 974 of relation 1663/16438/16970: Invalid argument CONTEXT: COPY tourney_holdem_hand_player_statistics, line 1: "68413 20871 20871 0 27 600 2009/03/19 15:43:01 6 f t 0 f 0 f t f f f 0 f 0 f f f f f 0 f 0 f f f f f..." )
2009/03/19 14:46:25: PokerStars: Hand Imported (#26127094651) from 149134159 20
2009/03/19 14:46:32: PokerStars: Unable to import hand (#26127118070). Reason: Unable to execute query: COPY tourney_holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: could not read block 974 of relation 1663/16438/16970: Invalid argument CONTEXT: COPY tourney_holdem_hand_player_statistics, line 1: "68414 20871 20871 0 27 600 2009/03/19 15:44:01 8 f f 0 f 0 f f f f f 0 f 0 t f f t f 0 f 0 t f t t f..." )
2009/03/19 14:46:32: PokerStars: Hand Imported (#26127118070) from 149134159 20
2009/03/19 14:47:22: PokerStars: Unable to import hand (#26127156954). Reason: Unable to execute query: COPY tourney_holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: could not read block 974 of relation 1663/16438/16970: Invalid argument CONTEXT: COPY tourney_holdem_hand_player_statistics, line 1: "68415 20871 20871 0 28 600 2009/03/19 15:45:39 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 f f..." )
2009/03/19 14:47:22: PokerStars: Hand Imported (#26127156954) from 149134159 20
2009/03/19 14:48:41: PokerStars: Unable to import hand (#26127183903). Reason: Unable to execute query: COPY tourney_holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: could not read block 974 of relation 1663/16438/16970: Invalid argument CONTEXT: COPY tourney_holdem_hand_player_statistics, line 1: "68416 20871 20871 0 28 600 2009/03/19 15:46:48 0 f f 0 f 0 f t f f f 0 f 0 f f f f f 0 f 0 f f f f f..." )
2009/03/19 14:48:41: PokerStars: Hand Imported (#26127183903) from 149134159 20
2009/03/19 14:49:47: PokerStars: Unable to import hand (#26127219243). Reason: Unable to execute query: COPY tourney_holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: could not read block 974 of relation 1663/16438/16970: Invalid argument CONTEXT: COPY tourney_holdem_hand_player_statistics, line 1: "68417 20871 20871 0 28 600 2009/03/19 15:48:19 2 f f 0 f 0 f t f f f 0 f 0 f f f f f 0 f 0 f f f f f..." )
2009/03/19 14:49:47: PokerStars: Hand Imported (#26127219243) from 149134159 20
2009/03/19 14:50:55: PokerStars: Unable to import hand (#26127243175). Reason: Unable to execute query: COPY tourney_holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: could not read block 974 of relation 1663/16438/16970: Invalid argument CONTEXT: COPY tourney_holdem_hand_player_statistics, line 1: "68418 20871 20871 0 28 600 2009/03/19 15:49:20 3 t t 0 f 2 t f f t f 0 f 0 f f t t f 0 f 0 f f f f f..." )
2009/03/19 14:50:55: PokerStars: Hand Imported (#26127243175) from 149134159 20
2009/03/19 14:51:45: PokerStars: Importing observed hands from table '149134159 15'
2009/03/19 14:51:51: PokerStars: Unable to import hand (#26127272876). Reason: Unable to execute query: COPY tourney_holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: could not read block 974 of relation 1663/16438/16970: Invalid argument CONTEXT: COPY tourney_holdem_hand_player_statistics, line 1: "68419 20879 20879 0 28 600 2009/03/19 15:50:36 8 f f 1 f 0 f f f t f 0 f 0 f f f f f 0 f 0 f f f f f..." )
2009/03/19 14:51:51: PokerStars: Hand Imported (#26127272876) from 149134159 15
2009/03/19 14:51:57: PokerStars: Unable to import hand (#26127269929). Reason: Unable to execute query: COPY tourney_holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: could not read block 974 of relation 1663/16438/16970: Invalid argument CONTEXT: COPY tourney_holdem_hand_player_statistics, line 1: "68420 20871 20871 9 28 600 2009/03/19 15:50:29 4 t t 1 t 0 f f f t f 0 f 0 f f f t f 0 f 0 f f f t f..." )
2009/03/19 14:51:57: PokerStars: Hand Imported (#26127269929) from 149134159 20
2009/03/19 14:53:24: PokerStars: Unable to import hand (#26127291554). Reason: Unable to execute query: COPY tourney_holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: could not read block 974 of relation 1663/16438/16970: Invalid argument CONTEXT: COPY tourney_holdem_hand_player_statistics, line 1: "68421 20879 20879 69 28 600 2009/03/19 15:51:24 9 f f 0 f 1 t f f t f 0 f 1 t f f t f 1 t 0 t t f t ..." )
2009/03/19 14:53:24: PokerStars: Hand Imported (#26127291554) from 149134159 15

Any idea how I can get the HUD working again?

Thanks,

Gerard

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 PostgreSQL command prompt. Click Start --> Programs --> PostgreSQL --> Command prompt. At the prompt that appears, type “reindexdb -a” and hit enter. Be aware that if you have large databases this may take a while, so be patient and wait for it to finish.
(If the re-index doesn't work because you are not logged in as user 'postgres' enter: "reindexdb -U postgres -a").

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, it seems to be working again after I did the first thing