Duplicate Hands Error in HM2: How do I solve?

Been working on fixing this for weeks and havent been able to do anything about it. Have tried making a new database, importing hands specifically to part of my desktop and having the archive in a different part, etc. Have asked around, and nobody else in my circles have had this error, so I have no idea.

Here's what it looks like. For reference, I played only 8 hands, but HM2 is counting the same hands anywhere from 1-6 extra times, which makes my hands played look like this and any hero stats unusable.

https://gyazo.com/f2956cea3d193c18c21fe5e0831a5db1

Have tried updating to latest beta, uninstall/reinstall, etc. Ready to just give up and go on HUDless sites at this point :mad:

Any help appreciated!



Edit, everything works fine with HM3 so will just use that. Can disregard this, or fix it if it ends up being a common issue.

i) Please try to vacuum/analyze and reindex your database - http://hm2faq.holdemmanager.com/ques...29#maintenance

ii) 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 - http://hm2faq.holdemmanager.com/ques...y+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 - http://hm2faq.holdemmanager.com/ques...onfigs+work%3F

If you continue to have problems, please reproduce the problem and zip/attach your HM2Logs folder with a detailed description of what you were doing and what problems you were experiencing - http://hm2faq.holdemmanager.com/ques...ger+Support%3F