Can't import from Boss

General discussion of PokerTracker 3.

Moderator: Moderators

Can't import from Boss

Postby Swant » Sat Aug 08, 2009 11:31 am

I think it was the latest uppdate that caused it.
I get the error message:

Boss Media: Unable to import hand (#1089336173). Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: index "holdem_hand_summary_primary_key" contains unexpected zero page at block 241 HINT: Please
Swant
 
Posts: 6
Joined: Tue Dec 16, 2008 8:50 pm

Re: Can't import from Boss

Postby WhiteRider » Sat Aug 08, 2009 12:03 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.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Can't import from Boss

Postby Swant » Sat Aug 08, 2009 1:21 pm

Its asking for a password. I have no idea what it is
Swant
 
Posts: 6
Joined: Tue Dec 16, 2008 8:50 pm

Re: Can't import from Boss

Postby kraada » Sat Aug 08, 2009 3:42 pm

Try "dbpass" (without the quotes). It won't show you that you're typing for security reasons; just type and hit enter and it should let you in if that's the right password.

If it isn't, follow this tutorial and then you won't need to use a password.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Can't import from Boss

Postby Swant » Sat Aug 08, 2009 5:47 pm

It worked, thanks
Swant
 
Posts: 6
Joined: Tue Dec 16, 2008 8:50 pm


Return to General [Read Only]

Who is online

Users browsing this forum: No registered users and 37 guests

cron
highfalutin