PT3 problem - not sure how to explain it.

[steelerian]

From what I can figure out, this is only a problem with Tournament hands, that imported during yesterdays session, on 03/05/2013.

When I import hands from this session I am getting the following error text in the "Import Status" window on the "Auto Import" tab;

2013/05/04 20:46:23: PokerStars: Hand Imported (#98064530096) from 803010395 187
2013/05/04 20:46:23: PokerStars: Unable to import hand (#98064498468). Reason: Unable to execute query: COPY tourney_holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: invalid page header in block 33789 of relation "tourney_holdem_hand_player_statistics" CONTEXT: COPY tourney_holdem_hand_player_statistics, line 1: "186479 498174 498174 0 127 1783 2013/05/03 19:47:23 1 9 f f 0 f 0 f t f f f 0 f 0 f f f f f 0 f 0 f ..." )

Then when I go to the "Texas Holdem, Tournaments" tab to view my results, filtered for this session, I get the following error text in the "Player" window:

Unable to execute query:
SELECT player.id_player,
player.id_site,
player.player_name,
player.val_icon FROM player
WHERE player.id_player > 0
AND player.id_player_alias = 0
AND player.id_player in (
SELECT DISTINCT
tourney_holdem_hand_player_sta (I cannot read any more of this last line as the window isnt wide enough)


In the "Cache Status" box on the "Texas Holdem, Tournaments" tab the Holdem is 100% but the Holem Tourney is 0%.


I have tried several things;
1. I have run housekeeping to try to resolve this - no joy
2. I have tried to purge all hands from this session - but again got an error message saying that some hands could not be purged
3. I have tried re-importing the hands from Pokerstars, but again get same problems I have already explained.

So, I am really lost and need some help?

Thanks
Ian

[kraada]

Please see this documentation on this error. I realize it's written for PT4 but the same solutions apply - you can find Reindex in PT3 in Database --> Housekeeping.