do not work on williamhill

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

do not work on williamhill

Postby dpzhang » Sun Apr 01, 2012 1:18 pm

iPoker: Unable to import hand (#3229280602). Reason: Unable to execute query: COPY holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: invalid page header in block 1659 of relation "holdem_hand_player_statistics" CONTEXT: COPY holdem_hand_player_statistics, line 1: "7195 2420 2420 0 6 2951 2012/04/01 15:41:48 5 9 t t 0 f 1 t f f t f 0 f 0 t f f t t 0 f 0 f f f t f ..." )
what can i do?
dpzhang
 
Posts: 6
Joined: Sun Apr 01, 2012 1:09 pm

Re: do not work on williamhill

Postby WhiteRider » Sun Apr 01, 2012 4:37 pm

Firstly, if you're not using at least v3.12 of PT3, please update.

Download page
PT3 Build History / Release Notes

I doubt that is the issue, but you will need to be up to date.

That error more likely indicates a problem with one of the files which makes up the database.
Try using the ReIndex option under Database > Housekeeping, along with the defaults, and see if that helps.

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.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: do not work on williamhill

Postby dpzhang » Sun Apr 01, 2012 10:30 pm

when i click Start --> Programs --> PostgreSQL --> i can not find configuration file.i use postgresql8.3
dpzhang
 
Posts: 6
Joined: Sun Apr 01, 2012 1:09 pm

Re: do not work on williamhill

Postby WhiteRider » Mon Apr 02, 2012 3:39 am

Later versions don't show it in the Start menu, but you should see it for 8.3:

2012-04-02 08h34_52.png

However, if you don't see it there you can access it directly using Windows Explorer, in :

C:\Program Files\PostgreSQL\8.3\data

Note that if you're using Vista or Win7 you'll need to run Notepad as Administrator in order to be able to save your changes.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests