New type of error - HM WONT START

[Arecal]

When I start HEM, it says "optimizing players... this process could take time, please be patient."

Then after a long while, a new window pops up which says: "The following error occurred: ERROR: 23505: duplicate key value violates unique constraint *pokerhands_hero_pkey*.


Please help me to fix this soon, cause my income depends on HEM, which is an awesome program. Please!

[fozzy71]

When I start HEM, it says "optimizing players... this process could take time, please be patient."

The optimize reports should only happen once, per player imported with known hole cards. It usually happens after a bulk import.

Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe.

Reboot, and run the installer first thing.

If it continues to optimize every time you restart HM:

You can disable this (make sure HM is closed) by going into the Holdem Manager\Config folder then right click and choose "New text Document" and name it NoOpt. Next time you launch HM it should skip this process.

Then after a long while, a new window pops up which says: "The following error occurred: ERROR: 23505: duplicate key value violates unique constraint *pokerhands_hero_pkey*.

This is an indicator of possible DB corruption/damage. You can try to fix that particular index - http://www.holdemmanager.net/faq/afm...aspx?faqid=168.

If that doesnt work, you can try the general Reindex command, from the maintenance window - http://www.holdemmanager.net/faq/afm...aspx?faqid=163


If none of that works, you may want to start a new DB.

*Try creating a new UTF DB - http://www.holdemmanager.net/faq/afm...aspx?faqid=146
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://www.holdemmanager.net/faq/afm...aspx?faqid=173
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB. - http://www.holdemmanager.net/faq/afm....aspx?faqid=21

Make sure you export/backup everything before deleting the old DB - http://www.holdemmanager.net/forum/s...ad.php?t=20754


If you play a site like stars/ftp you can email their support and ask for all your old hand histories and tourney summaries.

[Arecal]

It didn't work, I made a new database and imported all the files in it. But just like before, I can't view the hands in the tourney section. Also did the index thing and it still tries to optimize players when i start HEM.

What can I do now? This is too complicated.

[fozzy71]

I would suggest you reinstall postgresql completely - http://forums.holdemmanager.com/showthread.php?t=20755

[Arecal]

You can disable this (make sure HM is closed) by going into the Holdem Manager\Config folder then right click and choose "New text Document" and name it NoOpt. Next time you launch HM it should skip this process.

I finaly found the map called config. But I don't know which file to right click in this folder. Right now all I'm trying to do is to get into HEM to find a way to fix it with the steps you gave me, but even after waiting for an hour the optimizing window doesn't finish. So I need to know how I can disable it first before doing anything.

[netsrak]

You need to create a NEW file in this folder. This can be done via right click.