It was working perfectly fine last night after I installed it and used it. I open it up tonight, and I get this error message (followed by what appears to be some sort of programming equation) in every window.

What's going on?

edit: Delete thread. Restarted and it's working. At least PT3 is consistent. :/

i have the same problem but it doesnt work when i restart it, i ran disk check and stuff but still not working can anyone help

Full Tilt: Unable to import hand (#14157831924). Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: invalid page header in block 5

That's a different error.
There are two main reasons for this kind of error. The first is a result of data corruption from a computer crash that requires reindexing your database. You can reindex your database from the PostgreSQL command prompt. Click Start --> Programs --> PostgreSQL --> Command prompt. At the prompt that appears, type “reindexdb -a” and hit enter. Be aware that if you have large databases this may take a while, so be patient and wait for it to finish.
(If the re-index doesn't work because you are not logged in as user 'postgres' enter: "reindexdb -U postgres -a").

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. If you continue to have problems with that hard drive, you should consider replacing it.

hey thanks , ill try it now
a restart probably caused it or a crash so ill try the first suggestion

this is what i get

reindexdb: reindexing of database "PT3 DB" failed: ERROR: invalid page header i
n block 462 of relation "holdem_hand_summary"

i dont know why it happen, it was working fine for a week and today i had to reset my pc, after that i get this error and it wont run

Did you do the second step with zero_damaged_pages = on? That should clear that error out.

should i type it with # infront or not ? i see the other lines have it

You need to remove the #. That "comments out" the line - anything after # will be ignored.

Up up please :$

I guess i'm having the same ****in' problem

Can't even choose my screenname anymore.





The story is that I was forced to format my system because I could'nt boot anymore, so I could'nt export my database but hopefully my postgres directory was on another partition.

I listened to some random who told me that I could just easily uninstall/reinstall postgres and copy/paste my old "data" dir.

So now all I have is a 3GB data dir, please tell me that my database is still fixable please please :'(

I tried the reindexdb command thing but still don't work.

I replied to your duplicate post on the PT3 forums.