Import Error: PokerStars

[tmemmerson]

I have long had a problem w/ the HUD and Hero stats being displayed. The commercial release versions 1 & 2, seemed to temporarily display hero stats in Cash, then stop displaying (maybe 1 hour into a session.) I could temporarily remedy this problem by opening "congifure HUD" then clicking "apply." Keep in mind, I never had to change any configurations, they were already correct, but they wouldn't display properly for the hero unless I clicked "apply" every hour or so.

For this problem, I installed beta 13, in hope this would remedy the issue. Instead, I still have the same Hero Issue, with an import issue. It appears that I can no longer import hand summaries, every time a hand is set to import, the following error message appears...



PokerStars: Unable to import hand (#18246595064). Reason: Unable to execute query: COPY holdem_hand_player_detail FROM STDIN;; Reason: Fatal Error (ERROR: index "holdem_hand_player_primary_key" contains unexpected zero page at block 15169 HINT: Please REINDEX it. CONTEXT: COPY holdem_hand_player_detail, line 1: "2109779 155361 1 0 0 94.40 0.00 0.00 4.00 0.00 0.00 0.00 1.00 2 0 0 0 f f f f f f f f f f f f f 0.00..." )

[kraada]

There can be several reasons for this error. The first is that your database needs to be reindexed as a result of data corruption from a computer crash. 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 reindexing your database does not solve this issue, it may be the 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 very bottom and add the line zero_damaged_pages = on 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 may want to think about replacing it.