PDA

View Full Version : HM importing several hands double



K4sper
03-14-2010, 08:41 PM
I have the problem since some month.
From every 1000 hands something like 5 - 10 will get imported double. Its loosing and winning hands of amounts of all sizes and it is only happening in the reports section. In Sessions and graphs everything is alright, so its probable not importing double but just showing double in repots. If I delete one of the two identical hands in reports both hands are totally gone.
Please help

netsrak
03-15-2010, 06:20 AM
Sounds like your database is corrupt.

You should create a new one and reimport all your hands.

K4sper
03-15-2010, 10:42 AM
I really have to do this ;/ this will take forever with a big database right?

How exactly do I reimport all hands ?

fozzy71
03-15-2010, 01:38 PM
If you have a lot of hands you can break up the import into smaller groups, such that you can hopefully import them overnight. Then you could vacuum your DB the next day and play poker, etc, before you setup the next import batch that night.

*Try creating a new UTF DB - FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database (http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database)
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - FAQ - Hold'em Manager Poker Tracking Software :: How to Import & Export Hands (http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands)
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB.
*Make sure you export/backup everything before deleting the old DB

K4sper
03-16-2010, 01:52 PM
I did create a new database and imported the hands from the old one. This worked out with most hands, BUT
the same thing is happening as in the old database. Its showing hands double, Not many, but enough to give a totally wrong reports tab while sessions and graphs is alright

fozzy71
03-16-2010, 02:32 PM
What sites do you play? What version of PostgreSQL?

Please www.7zip.org the hands and email them to me at fozzy@holdemmanager.net, with a link to this thread.

K4sper
03-16-2010, 03:11 PM
postgres is version 8.3
I play on fulltilt,stars,partypoker,ipoker,entraction and ongame. I think its random hands from all sites, but not entirely sure.
The postet zipping site doesnt load for me. Can I take a different one? <-- there was a - missing, its www.7-zip.org
Sending some hands to you now, its just a random amount of hands

K4sper
03-19-2010, 11:13 AM
so, did you get my hands? I stil have the problem!

K4sper
03-21-2010, 06:55 PM
fozzy71,

Why do I get no replies from you???

fozzy71
03-21-2010, 10:31 PM
Yes, I got the hands. No, I had not yet had a chance to import them and test them.

I just imported them and I do not see any duplicate hands. The Reports, Sessions, and Graphs tab are all exact, down to the very penny. I would suggest you completely reinstall postgresql and start fresh.


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

1) Uninstall PostgreSQL from the Windows Control Panel.
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloads/Holdem_Manager_Setup.exe

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:
A) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator

net user postgres /delete
B) Reboot.
C) Try installing this version of PostgreSQL - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe