Open Side Menu Go to the Top

06-10-2010 , 05:16 PM
I'm sure this is a simple fix, but earlier today, when PokerStars was having its server issues, I thought it was on my end, so I uninstalled and reinstalled Stars.
Since then, I'm getting this message for every hand I play.

PokerStars: Unable to import hand (#45336545609). Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: invalid page header in block 83 of relation "holdem_hand_summary" CONTEXT: COPY holdem_hand_summary, line 1: "2081

I'm sure it's a quick fix, but what is it?
Errors Importing Hands
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards • Splash Pots • CoinRaces
Errors Importing Hands
06-10-2010 , 05:41 PM
I am having the same problem with my Absolute hand histories.
06-10-2010 , 06:00 PM
There are two main reasons for this kind of 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 Database Management window - it may take a while but shouldn't take more than an hour or two unless your database is very large.

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.
Errors Importing Hands
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards • Splash Pots • CoinRaces
Errors Importing Hands

      
m