Trial Version (import error)

[WhiteRider]

I thought you said it didn't let you save the file?
Were you able to complete APerfect10's instructions?

If so, Please enable logging, reproduce the problem and submit your PokerTracker.log file to the
Support system , and link to this thread in the reference field of the ticket.

[M500]

Yes, i did everything perfect 10 said after you helped me save, but it did not work.

[WhiteRider]

Are you getting exactly the same error as the OP?
If it's different, please post the error message here.

[M500]

Im not sure if it's the same log as the OP but PT3 stopped working once i turned off my CP in disgust at a dissapointing outcome...after that it would display the HUD every once in a while but did not update hands. Here is the current error log:
Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSBADF.tmp
2008/08/09 05:58:53: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Mr1600\FT20080809 Bardonia - $0.05-$0.10 - Pot Limit Hold'em.txt
2008/08/09 05:58:53: Full Tilt: Unable to import hand (#7573090183). Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: index "hhs:idx1-date_played" contains unexpected zero page at block 0 HINT: Please REINDEX it. CONTEXT: COPY holdem_hand_summary, line 1: "72 300 3 74 7573090183 2008/08/09 09:57:40 2008/08/09 05:58:53 8 3 3 0 2.00 4.00 4.00 0.00 1.10 0.10..." )
2008/08/09 05:59:39: Full Tilt: Unable to import hand (#7573096257). Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: index "hhs:idx1-date_played" contains unexpected zero page at block 0 HINT: Please REINDEX it. CONTEXT: COPY holdem_hand_summary, line 1: "73 300 3 74 7573096257 2008/08/09 09:58:47 2008/08/09 05:59:39 9 2 2 2 2.00 3.65 3.65 3.30 1.45 0.10..." )
2008/08/09 06:01:07: Full Tilt: Unable to import hand (#7573100396). Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: index "hhs:idx1-date_played" contains unexpected zero page at block 0 HINT: Please REINDEX it. CONTEXT: COPY holdem_hand_summary, line 1: "74 300 3 74 7573100396 2008/08/09 09:59:33 2008/08/09 06:01:07 9 5 5 5 2.00 3.30 3.30 3.30 1.00 0.10..." )

[WhiteRider]

OK, try using the Database menu to cluster, vacuum, analyse the DB.
If that doesn't help I'll ask Derek to take a look at this thread.

[M500]

Still nothing.. I'd appreciate you asking someone as PT3 has been down for a day or two now

[WhiteRider]

OK, will do..

[Peligroso]

This could be because of data corruption caused by a computer crash. Please try reindexing your database by going to Start -> Programs -> PostgreSQL -> Command Prompt. In the prompt, write "reindexdb -a" and press enter. This process might take a while if you have large databases.

[M500]

It asks for a password when i do this, which password is it requesting? When i run as an administrator it does not recognize the code.

[Peligroso]

It asks for a password when i do this, which password is it requesting? When i run as an administrator it does not recognize the code.

It asks for your PostgreSQL password. If you have forgotten your PostgreSQL password, please see the following guide:

How To: Remove PostgreSQL Password