PDA

View Full Version : ERROR: 23505 during optimize reports



Hooorny
09-26-2008, 09:42 AM
When I start HM the following error occurs during optimizing Players:

"ERROR: 23505: duplicate key violates unique constraint 'playerhandsflop_hero_pkey'"

What can I do? Thanks in advance!

paracelse
09-27-2008, 10:43 AM
I have the same problem.

Rvg72
09-27-2008, 11:54 PM
Please do this:

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




Truncate Table SpecialHoleCardActions_hero;
Truncate Table PlayerVsPlayer_hero;
Truncate Table PlayerHandsCashMisc_hero;
Truncate Table PlayerHandsTourneyMisc_hero;
Truncate Table PlayerHandsFlop_hero;
Truncate Table PlayerHandsTurn_hero;
Truncate Table PlayerHandsRiver_hero;
Truncate Table AllInSituations_hero;
Truncate Table PlayerHandsFlop_hero;
Truncate Table PlayerHandsTurn_hero;
Truncate Table PlayerHandsRiver_hero;
Truncate Table AllInSituations_hero;
Truncate Table PlayerHandsCashKeyColumns_hero;
Truncate Table PlayerHandsTourneyKeyColumns_hero;
Delete from OptimizedPlayers;
Delete from UnOptimizedHeros;


Press F5 to execute this all at once. You should then do a full Vacuum – with a huge DB this could take a couple of hours. Right click the DB go to maintenance and select Full.

Next download this version:

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

Then launch Holdem Manager and you will need to optimize again and if you see any errors let me know right away what they say but hopefully you’ll be ok after doing this.

Roy