Page 1 of 1

Can't import from Boss

PostPosted: Sat Aug 08, 2009 11:31 am
by Swant
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

Re: Can't import from Boss

PostPosted: Sat Aug 08, 2009 12:03 pm
by WhiteRider
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.

Re: Can't import from Boss

PostPosted: Sat Aug 08, 2009 1:21 pm
by Swant
Its asking for a password. I have no idea what it is

Re: Can't import from Boss

PostPosted: Sat Aug 08, 2009 3:42 pm
by kraada
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.

Re: Can't import from Boss

PostPosted: Sat Aug 08, 2009 5:47 pm
by Swant
It worked, thanks

highfalutin