PokerTracker

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,

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.

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

Thanks for following up.