CASH - duplicated hands, see link
Results 1 to 5 of 5
  1. #1
    Member
    Join Date
    Mar 2014
    Posts
    77

    Default CASH - duplicated hands, see link

    Hi, all of a sudden, this is the situation.
    cash2.jpeg
    I have duplicated hands, in a random way, sometimes one hands is duplicated 3 times, sometimes 20times .
    Everytime I close and reload HM2 , problem auto-solves: hands are loaded in the ''active session'' 1 time only.
    The problem is that I need to visualize correct live stats .
    Session result is scrambled too.
    Regards.

  2. #2
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    Please try to vacuum/analyze and reindex your database - Hold'Em Manager 2 FAQs - Poker Software :: Database Manager (Ribbon)

    If you continue to have problems, try the following:

    Try creating a new DataBase and import a small portion of your \HM2Archive so you can see if the problem exists in the new DB - Hold'Em Manager 2 FAQs - Poker Software :: How to create a new database and import previously played hands

    If the new database seems to work properly, it sounds like your database might be corrupt. Please continue to use the new database and import the rest of your hands using the steps above. This is why regular backups are a good idea. If your database becomes corrupt you can restore a backup and only have to import the most recent hands (that were played after the backup was created) and edit any tournament results if necessary. I recommend keeping at least the most recent 2 or 3 backups in case the most recent one does not restore properly you can try the previous backup.

    Here is a FAQ explaining how to backup your database and all settings in one easy step - Hold'Em Manager 2 FAQs - Poker Software :: How does Backup and Restore Database, Settings and HUD configs work?
    Regards udbrky (Chris)

  3. #3
    Member
    Join Date
    Mar 2014
    Posts
    77

    Default

    Quote Originally Posted by udbrky View Post
    Please try to vacuum/analyze and reindex your database - Hold'Em Manager 2 FAQs - Poker Software :: Database Manager (Ribbon)
    Thanks. Step 1 done. Back in the ''active session'' window I got this message: cash4.jpeg
    I click on CANCEL and HM2 shut down.
    Should I keep trying next suggested steps, or there's something better / more urgent to do ?
    Regards.

  4. #4
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    You need to upgrade Postgres.

    Please note that reinstalling PostgreSQL will mean losing all your old data. If you have access to HM2 and your database was not corrupt then please follow these instructions for backing up your database as a precaution in case you cannot reconnect after reinstalling PostgreSQL - Hold'Em Manager 2 FAQs - Poker Software :: How does Backup and Restore Database, Settings and HUD configs work?

    If you cannot access the database in HM2 then you can backup your database using this method: Hold'Em Manager 2 FAQs - Poker Software :: How does Backup or Restore via PostgreSQL work? (Advanced Method) but if your database was corrupt then the best solution is to reimport all your hands from C:/HM2archive folder or if your pokersite supports it you can request all your hands and summaries and reimport them as restoring a corrupt database will just restore all the problems you had.

    Once you have backed up your previous database(s) then follow the instructions below to uninstall and reinstall PostgreSQL using the same database.

    1) Uninstall PostgreSQL from the Windows Control Panel.

    2) Run the command - start > programs > accessories > command prompt > right-click > run as administrator and type the following and then press enter:

    net user postgres /delete

    3) You should get a successfully completed response if done correctly. If you get a permission type error you likely didnt run it as administrator as explained above.

    4) Reboot your PC

    5) Install the same version of PostgreSQL (HM2 ships with 8.4) - http://www.enterprisedb.com/products...wnload#windows - as your previous database using these instructions - Hold'Em Manager 2 FAQs - Poker Software :: Reinstall PostgreSQL 8.4 while preserving database
    http://www.holdemmanager.com/downloads/postgres84
    Regards udbrky (Chris)

  5. #5
    Member
    Join Date
    Mar 2014
    Posts
    77

    Default

    Perfect, I need a new hard disk, it'll require me a few time, thanks for now.

Similar Threads

  1. Duplicated hands
    By mikitorto in forum General Support
    Replies: 2
    Last Post: 02-09-2015, 09:05 PM
  2. Duplicated hands
    By lautaaaaaa in forum Manager General
    Replies: 2
    Last Post: 11-16-2013, 11:05 AM
  3. Uploading duplicated hands
    By RiverSt4rs in forum Manager General
    Replies: 3
    Last Post: 04-05-2012, 09:45 PM
  4. HEM has duplicated my hands?
    By cjw-lfc in forum Manager General
    Replies: 1
    Last Post: 04-04-2011, 10:44 PM
  5. hands duplicated after db restore
    By DasWiesel in forum Manager General
    Replies: 3
    Last Post: 11-06-2008, 12:11 PM

Posting Permissions

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