Unable to import hand

[icemf]

Hello! Today during the program PT3 was working suddenly the power of my computer was cut off. I turned on the computer again and realized that PT3 stopped to keep hands. The program gives the reason of error: "PokerStars: Unable to import hand (#36536646951). Reason: Unable to execute query: COPY tourney_holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: invalid page header in block 193 of relation "tourney_holdem_hand_summary" CONTEXT: COPY tourney_holdem_hand_summary, line 1: "3251 100 160 6 161 36536646951 2009/12/11 12:14:45 2009/12/11 15:15:40 3 2 2 2 1820.00 0.00 0.00 0.0..." )"

Please help me to solve this problem.

Thanks a lot.

Best regards,

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

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.

[icemf]

Thank you very much. The second way was useful for me and decided my problem.

[kraada]

Thanks for following up.