maybe database was broken?

[charles1122]

Hello,
my pt3 can not auto-import the tournament and housekeeping's always with Error
it's probably because Power Failure with my PC when the PT3 was auto-importing and at that time was in a tourment.

i consider that the database of SQL was broken.
can you do me a favor tell me what should i do with my SQL?

PokerStars: Unable to import hand (#65890510559). Reason: Unable to execute query: COPY tourney_holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: invalid page header in block 2421 of relation base/17712/21029 CONTEXT: COPY tourney_holdem_hand_player_statistics, line 1: "11495 32288 32288 0 5 253 2011/08/12 05:31:41 2 5 f t 0 f 0 f t f f f 0 f 0 f f f f f 0 f 0 f f f f ..." )

[WhiteRider]

Try doing a ReIndex in Database > Housekeeping.
If that doesn't fix the issue..
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.

Alternatively, create a new database and re-import the hand history files - that way any damaged files in the old database will not matter.

[charles1122]

hello,
thank you very much for your help.
a little problem that i can not find the "Configuration Files" at Start --> Programs --> PostgreSQL8.4
there are only PgadminIII,application stack builder,sql shell,documentation in it.
can you do me a favor tell me another way?for example using PgadminIII to configuration the files.
thank you very much

[kraada]

You can find the file then by clicking Start --> My Computer --> C: --> Program Files (x86) --> PostgreSQL --> 8.4 --> data and the postgresql.conf file should be there. Open it with Notepad and make and save the changes, then you can restart PostgreSQL from the Start menu.