PDA

View Full Version : ERROR: 23505: duplicate key violates unique constraint 'playerhandsflop_hero_pkey'



dunno
09-12-2009, 01:25 PM
I always get that error when i start HM.Ive done everything that is said in this post http://208.109.95.123/forum/showthread.php?p=11728 but it didnt helped.
Pls help me :(

fozzy71
09-12-2009, 06:21 PM
I hope you didnt download that ancient 1.06.04 beta version of HM?


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


HM > Options > Database Management > Fix Indexes > select your index mentioned and rebuild.

See if it helps. If not, try a Full/Vacuum/Analyze and Reindex thru PGAdmin. If that doesn't work you may end up having to create a new DB.