Wrong statics and some missing

[Pokeriblogi]

I have "little" problem with my PT3.

I can´t import my Poker Stars hands. It says:
2008/09/08 23:32:54: PokerStars: Unable to import hand (#20251411565). Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: invalid page header in block 247 of relation "holdem_hand_summary" CONTEXT: COPY holdem_hand_summary, line 1: "2 100 3 321 20251411565 2008/09/08 20:33:02 2008/09/08 23:32:54 6 4 2 2 2.65 2.40 13.00 12.00 5.60 0..." )

Here you can see " a little" wrong stats. Total hand are ok but i haven´t won (yet) that much :D . 140d is closer . I ran housekeeping and errors there too
Here is picture where can see the problem
[ img ]

Tournament stats are ok and hud update normal.

What can i do?! :cry:

[WhiteRider]

Please see the Database / Postgres FAQ.

[Pokeriblogi]

I didn´t found this kind of error from Database / Postgres FAQ

2008/09/09 18:20:47: PokerStars: Unable to import hand (#20269766081). Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: invalid page header in block 247 of relation "holdem_hand_summary" CONTEXT: COPY holdem_hand_summary, line 1: "256 100 4 334 20269766081 2008/09/09 15:21:36 2008/09/09 18:20:47 7 3 3 3 2.75 2.50 2.50 2.50 1.75 0..." )

[WhiteRider]

Sorry, no - that exact message isn't there, but I understand it's similar to this:

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.

[Pokeriblogi]

It ask password when I try to do that in Command Promt. I can´t write anything in password field. When I press enter comes: "reindexdb: could not connect to database postgres: FATAL : password authenticati on failed for user "postgres"

E:now PT import hands but stats are still wrong. How can i delete those hands which are imported wrong and falsify statics? It seems that PT has mixed up tournament hand history and cash game history files. Tournament hand history have imported as a cash game hand history.

[WhiteRider]

This is a known issue in Beta 17 and should be fixed for the next release.
When Selective Purge is added (Development Timeline) you will be able to remove the incorrect sessions, but at the moment there is no way to do this I'm afraid.