View Full Version : Duplicate Hands @PokerStars

02-16-2012, 02:57 PM
All of a sudden my HM has problem (auto)importing files
Some files are imported, some are declared as duplicate.

For example, I know for the fact that this session I've played 838 hands. This stats is shown in PokerStars client and in my TiltBreaker software as seen in pictures below:

But my HoldemManager shows only 632 hands:

Same info on my session tab, but the weirdest thing is that Reports tab shows 685 hands, instead of 632 (or 838 lol).
Stats for whole day are:
Actual hands: 1884
Session tab: 1541
Graphs tab: 1541
Reports tab: 1619

1. Yes, I am using 1.12.09 update.
2. 100% no filters are selected (clicked clear and everything)
3. Tried manually importing missing hands, moved to other folder and tried with "import from folder". Got 367 duplicate hands.
4. No problems till today.

Thank you for your help.

02-16-2012, 06:21 PM
Just playing a new session atm.
Half hour in and I already have +100 "duplicate" hands :(

02-17-2012, 02:02 AM
Check if there are handhistory files 'stuck' in your PS auto import folder and manually move them to the archive folder.

Create a new database: Options--> Database Management--> Connect--> Create New Database--> (set it as default)--> Start HoldemManager
And reimport all the hands into a new empty database.

02-17-2012, 04:47 AM
Those hands which stays in PS auto import folder are "duplicate" hands (which are not).
Like I said I tried importing them manually.
Moving them into archive folder won't fix the problem. I still want those hands to be imported obv :)

Starting a new database is just not the option. I have millions and millions of hands.

You saying that I should create a new database probably means I'm f***ed, right?

02-18-2012, 02:15 AM
Create a new database, just as a test.
Play 1 orbit of microstakes with an empty database.

Do you have the same issue in the new database?
If you don't... prepare for reimporting ALL your hands into the new database.

02-18-2012, 10:26 AM
It works fine with the new database :(

02-19-2012, 01:54 AM
When you've reimported all the hands--> backup the database in pgadminIII: http://faq.holdemmanager.com/questions/72/Backup%26RestoreDatabase
so next time you can 'restore a backup'.