Quote:
Originally Posted by jlevu
I've been using PT3 for awhile and it's been working fine, but today my comp froze and I had to hold the power button to turn it off. Now PT is no longer able to access all the hands in my database. When I auto import, I get this error:
Fatal Exception during Auto-Import process: Unable to execute query: INSERT INTO player VALUES (0, 0, '[Split Pot]', '[Split Pot]', 0, 0, 0, FALSE);; Reason: Fatal Error (ERROR: invalid page header in block 277 of relation "player" )
And when I hit the tournaments tab to look over hands, no players or hands show up, only this message:
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
That sounds like a damaged file in your database. You could try doing a ReIndex in Database > Housekeeping, but if that doesn't help..
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.
Quote:
Originally Posted by Sorrybadbeat
After installing the latest update I get a password error.I tried a bunch of the recommended passwords but none of them worked.The weird thing is that after I click proceed anyway, everything works, all of my hands are there and it also imports correctly but I keep having to go through multiple screens to use my pokertracter.
Do you mean the latest update of PT3? That doesn't affect PostgreSQL at all, so wouldn't cause issues with your passwords.
You can set PostgreSQL to not need a password, which should remove the extra screens - this will not allow anyone else to connect from outside your machine. Search for the "How To: Remove PostgreSQL Password" in the PokerTracker forums.
Quote:
Originally Posted by MakeBelieve
It seems to work but sometimes the stat still stays white, is this the corect method? maybe '= 18' isnt correct?
'= 18' will only work when the value is exactly 18. Using ' >= 18' will colour it when the value is 18 or more, so try that.
--WhiteRider