Open Side Menu Go to the Top

07-08-2009 , 03:54 PM
My PT3 import no longer works. I updated to beta v28.3 recently & haven't used it since 7 now I get an error:

PokerStars: Unable to import hand (#30239149221). Reason: Unable to execute query: COPY holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: invalid input syntax for integer: "t" CONTEXT: COPY holdem_hand_player_statistics, line 1, column cnt_players: "t" )

Trolled the PT site & here & seems to suggest "reindexdb -a" tried this & I get
"reindexdb: could not connect to database postgres: FATAL: role "owner" does not exist
Whats my play? Also tried ignoring faulty hardware.
FATAL ERROR
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards • Splash Pots • CoinRaces
FATAL ERROR
07-08-2009 , 05:23 PM
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.
07-23-2010 , 03:34 AM
i did everything as instrusted but still getting the same errror
07-23-2010 , 05:55 AM
This:
Quote:
Originally Posted by Jay_Oh
"reindexdb: could not connect to database postgres: FATAL: role "owner" does not exist
..sounds like the reindex is running under the wrong user - it should be the "postgres" user, it sounds like it is trying to use "owner". Did you use the full command:
reindexdb -U postgres -a
..to force it to use the postgres user?

If that doesn't work please schedule a remote assistance session where someone can logon to your computer with you and directly troubleshoot/resolve the issue.
07-23-2010 , 01:45 PM
2010/07/23 13:44:45: PokerStars: Unable to import hand (#47162359976). Reason: Unable to execute query: COPY holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: invalid input syntax for integer: "f" CONTEXT: COPY holdem_hand_player_statistics, line 1, column cnt_players: "f" )

still showing up.

EDIT: created a new db and everyting seems to be working.

Last edited by milbs06; 07-23-2010 at 02:00 PM.
FATAL ERROR
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards • Splash Pots • CoinRaces
FATAL ERROR

      
m