pokertracker error messages

[franky272727]

tracker has stopped working and im getting this message for every hand
2012/12/23 23:13:02: Full Tilt: Unable to import hand (#31720412511). Reason: Unable to execute query: COPY tourney_holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: index "tourney_holdem_hand_summary_primary_key" contains unexpected zero page at block 0 HINT: Please REINDEX it. CONTEXT: COPY tourney_holdem_hand_summary, line 1: "1 300 9517 7 23516 31720412511 2012/12/23 20:01:02 2012/12/23 23:13:02 9 0 0 0 3000.00 0.00 0.00 0.0..." )
any thoughts?

[kraada]

You can reindex your database via the Database --> Housekeeping menu. That should fix things for you.

[manool]

Hello! I v got the similar one.
ERROR: invalid page header in block 60 of relation "tourney_holdem_hand_summary
version - 3.13.13beta. OS - W7. I got the same on desktop witn W XP but after upgrade PT to latest version everything is OK.

[manool]

as for cash games - rush on FullTilt - hands imported correctly. tu

[manool]

Hello! I v got the similar one.
ERROR: invalid page header in block 60 of relation "tourney_holdem_hand_summary
version - 3.13.13beta. OS - W7. I got the same on desktop witn W XP but after upgrade PT to latest version everything is OK.

help me plz

[manool]

this is the whole error:
: Full Tilt: Unable to import hand (#31726415471). Reason: Unable to execute query: COPY tourney_holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: invalid page header in block 60 of relation "tourney_holdem_hand_summary" CONTEXT: COPY tourney_holdem_hand_summary, line 1: "330 300 492 7 484 31726415471 2012/12/24 18:09:50 2012/12/24 22:10:23 3 2
I do still need an advice. tu.

[WhiteRider]

That suggests an error in your database, which could be a disk error in one of the database files.
Go to Database > Housekeeping and select ReIndex and Rebuild Cache along with the default options, and that should fix it.

[manool]

hello. tu.
when I tried error also appeared:
unable to execute query: "REINDEX DATABASE "PT3 DB";
reason: fatal error( ERROR: invalid page header in bloc 0
of relation "holdem_tourney_hand_summary")

[WhiteRider]

That looks like you could have a disk error. 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.
It would probably be safer to re-import to a new database anyway, given the errors in this one.

[manool]

ok then, why do cash game hands importing corectly when tourneys' dont?