ERROR: 23505: duplicate key violates unique constraint 'playerhandsflop_hero_pkey'
Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    Sep 2009
    Posts
    1

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

    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

  2. #2
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,803

    Default

    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.

Similar Threads

  1. Replies: 5
    Last Post: 11-22-2009, 12:34 AM
  2. Always Duplicate Hands Error
    By kriok in forum Manager General
    Replies: 10
    Last Post: 01-11-2009, 02:21 PM
  3. ERROR: 23505 during optimize reports
    By Hooorny in forum Manager General
    Replies: 2
    Last Post: 09-27-2008, 11:54 PM
  4. duplicate hands
    By bg26892 in forum Manager General
    Replies: 1
    Last Post: 09-07-2008, 07:21 PM
  5. DB error 23505
    By Ar3s in forum Manager General
    Replies: 8
    Last Post: 08-16-2008, 05:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •