Error when HEM loads

[eratik]

Every time i start HEM it tries to optimize for a while, and then gets this error:

http://img243.imageshack.us/img243/885/bugij9.jpg

[morny]

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 playerhandscashmisc_idx1” without the quotes and press F5 to run it. It should finish quickly
6) Type

CREATE INDEX "playerhandscashmisc_idx1"
ON playerhandscashmisc
USING btree
(playerhand_id);


And press F5 – this could take many minutes or more depending on the size of your db. After doing this launch Holdem Manager and try importing some new hands