PDA

View Full Version : Error when trying to Purge hands



Twan
10-09-2008, 06:29 AM
I get this error message when I try purging hands from my DB

ERROR: XX002: index "playershandcashkeycolumns_idx" is not a btree

what should I do?

morny
10-09-2008, 11:21 AM
Hi, you have an issue with one of your indexes. Here is how you fix it:

1) Open pgadmin from your start menu in windows under postgresql
2) Double click on the server name and enter your postgresql password (default is postgrespass)
3) Click on Databases and select the current database
4) Click on the Icon at the top that has the SQL and pencil
5) Type "drop index playershandcashkeycolumns_idx" without the quotes and press F5
6) Type (well copy and paste is better)

CREATE INDEX playershandcashkeycolumns_idx_idx1
ON playershandcashkeycolumns
USING btree
(player_id, actiontype);

And press F5. It should be good after this.

Twan
10-10-2008, 07:57 AM
Hi I cant get it to work.
In step 5 after I press F5 I get this message

ERROR: index "playershandcashkeycolumns_idx" does not exist
SQL state: 42704

and where should I paste to in step 6? the same place as I wrote at in step 5? If so should I delete what I wrote in step 5 before I paste?

I've tried both ways and get an erorr message.

Rvg72
10-11-2008, 01:24 AM
Hi, this is the query you need to run in step 6 (and you can skip step 4 now since the index is already dropped)

CREATE INDEX playerhandscashkeycolumns_idx1
ON playerhandscashkeycolumns
USING btree
(player_id,handtimestamp);


Roy

Twan
11-29-2008, 07:41 AM
I gave up on fixing this for a while but now my hard drive is getting full so I really need to purge hands.

I still get this error message when I try purging hands from my DB

ERROR: XX002: index "playershandcashkeycolumns_idx" is not a btree

I have done the steps Morny wrote many times but in step 5 I get this message after I push F5

ERROR: relation "playerhandscashkeycolumns_idx1" already exists
SQL state: 42P07

And in step 6 when I past what Roy posted and push F5 I get this message:

ERROR: relation "playerhandscashkeycolumns_idx1" already exists
SQL state: 42P07

and purging hands still doesnt work.

What shall I do next??

regards,
twan

morny
11-29-2008, 11:26 AM
Weve made this easier now, follow this FAQ

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168

Twan
11-30-2008, 01:43 PM
I tried to follow the FAQ but when I go to the Datbase Control Panel and push connect and see the list of my databases in the Database control panel I DON'T have a button that says Fix Indexes so I cant do what the FAQ tells me to do.
I have the latest HM version.

what to do?

morny
11-30-2008, 03:59 PM
Sounds like you dont have the newest release please update

http://www.holdemmanager.com/downloads/HmUpdate1.06.04beta.exe