PostgresSQL problem: https://ibb.co/d0h6fMy

This is usually a firewall or windows update issue and the following guide gives a step by step guide:
http://hm2faq.holdemmanager.com/ques...rt+PostgreSQL+

If you continue to have problems:

Please duplicate the issue and send us log files with a detailed description of what you were doing and what problems you were experiencing:
- Open Windows Event Viewer's (Control Panel - System & Security - Administrative Tools or Start - Search - 'Event Viewer') - Windows Logs - Applications.
- Check for any errors and send the information (Save All Events As...).
- Please send your \HM2Logs folder files as well.

When sending any files please zip them (right-click - send to - compressed folder) before attaching them to an email. If the attachment is larger than 10MB please upload them to a file hosting site like dropbox, then right-click - 'copy dropbox link' and paste the download link directly into the support ticket email. If you have any problems with dropbox try using filedropper.com

Fozzy71
Customer Support

In the Steal category add the 'Fold vs Resteal' stat then go to the 'Item Properties' in the upper right and switch the 'Position' for that stat from 'All Positions' to 'Small Blind (SB)'


In the vsThreeBet category select 'Fold to 3Bet' then go to the 'Item Properties' in the upper right and switch the 'Position' for that stat from 'All Positions' to 'Small Blind (SB)'



Fozzy71
Customer Support

have to ask again because so many players using all-in cash out and the results in my holdem manager 2 are so skewed from reality..

when will hem2 be able to import hands with all-in cashout ?

Thank you for the reply. I have the new HM2 working.

But all database are empty. How do I get my original database back?

Or just my hand histories if that is ok.

If you have a backup* of the database you can restore it from that file to a new database in the HM2 Database Manager and then manually import hands from the archive that were played after the backup file was created. If you don't have a backup then you have to manually import the original hands from your archive folder to a new HM2 DB.

Here is a FAQ that explains how to create a new DB and import from the archive folder - http://hm2faq.holdemmanager.com/ques...y+played+hands

All original hands that are auto-imported get moved to an archive for performance reasons. Your \HM2Archive is in C:\HM2Archive by default, but you may have put it anywhere. The archive should be organized by \Month\DayOfMonth (example: D:\HM2Archive\2009\07\31) or if it was auto-imported with 7283+ it would be in \HM2Archive\SiteName\YYYY\MM\DD.* It is configured in the Site Setup - Auto Import Folders menu.

*This is why regular backups are a good idea. If your database becomes corrupt, or you have hardware problems, 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

Fozzy71
Customer Support

I am a beginner I don't think I ever have back-ups previously.

I imported hands from HM2achive, but only partial hands are imported successfully.

In my case, I have ~66000 hands originally, HM2achive there are only ~46000 hands available to import, and only successfully imported ~39000 hands.

Going back in review, it seem like from 2018.11 - 2019.04 HH are gone, around 2019.05 to now HH seems no problem.

What kind of problem would this be? Where else can I find the remaining hands? Thank you very much.

That should have any/all hands that HM2 auto imported to your previous database from live play. If you had previously manually imported hands to your old/deleted database those would not have been archived, they would be in the same location you imported from if you didn't delete them.

The only other thing I can suggest beyond searching your computer for similar types (*.txt, or *.xml, etc) of files in other folders on your computer is to request the hands from your site if you play at one of the few sites that can send them to you in the proper format. If you play a site like stars/ftp/party you can email their support and ask for all your old hand histories and tourney histories/results. None of the other sites we support can email hands in the proper format as far as I know.

Fozzy71
Customer Support

ETA on hem2 supporting cashouts?

We are starting testing of the first internal alpha version of cashout support for HM2. These changes should be available in the next gold beta release. While we do not have an exact date for the release, you will receive a prompt to update once available as long as you have enabled the Settings > General > [x] Prompt for Beta Updates.

Fozzy71
Customer Support

I found some XMLs, what should I do with these? Thank you!

If you believe they are hand history xml files (i.e. by the file name) use the Options - Hand Importing - Import Folder/File options to import them to your new database.

Fozzy71
Customer Support

I tried, doesnt work. File names are mostly "CheckRaiseDryFlop" or "4betRange" or "MissFlopCbetOOPFold" etc

Those are not hand history files. You can tell simply by the file name. Most sites name them with hand numbers, tourney numbers, table names, stakes, etc.

Look at the files in the \hm2archive folder you imported and look at those file names/types. Those are the types of files you would need to search your computer for. I have no way to know if you actually even have any other hands in any other folders or what types of files those would be (I have no clue what sites you play). I was just suggesting it as a possible reason for your archive not having all the hands you remember from the last database. It is also possible you might have had HM2 archiving them to a different folder at some point.

If you actually manually imported hands to the old database you could have possibly deleted the original hand history files after the import once they were in your database. Without a backup of the previous database, or a copy of the hands exported from the old database, there would be no way to get them back if that was the case.

THis is why database backups and copies of all hands you import is so important. I have HM2 and HM3 configured to archive my hands to a sub-folder of my google-drive account. I also have lots of older samples from HM1 days and database backups, etc on the google drive account that I also backup to my local external drive.

Fozzy71
Customer Support

Thanks again! I looked everywhere, only HM2achive has 99% of available hands. Originally I have ~66000 hands, HM2achive has ~39000 hands. So the HH that is missing, there is no way to find them back anymore right?

Only the ways I already explained. If you don't know where else the missing original hand history files could be (some other computer, flash drive, external drive, etc) and don't have a backup of the database (or a copy of the old databases exported hands) there is nothing else I can suggest other than email Stars for the hands if that is the site the missing hands were played on. I have instructions for that if you need it but I got the feeling you do not actuall play at Stars.

Fozzy71
Customer Support

Yes you are right, I don't play on PS.

Just one more question, if I want to migrate HM2 and database to a new laptop, what should I do?

A quick way I can think of is that just copy the HM2 backup file, and download new HM2 on the new laptop, and restore the backup?

Thank you again for the detailed response!

Yes, backup the db, transfer the file and restore it.

Please see this FAQ to transfer/backup data - http://hm2faq.holdemmanager.com/ques...dem+Manager%3F

This will ensure that you have your hand histories and HUD saved to import into a new computer, and as a backup to restore in case of an emergency. I recommend you do this at least once a month and keep the last 2 or 3 most recent backups (and your \HM2Archive folder) stored on an external drive and/or cloud storage site like dropbox or google drive.

Fozzy71
Customer Support

Using HM2 on new laptop, can I use the same license key?

Yes, of course. This is explained in another of our FAQ pages.

The same code can be used on 2 pc's you own at once and can be reset as often as needed. Please try using our site to retrieve and/or reset the code whenever necessary.

If you have any problems activating the software please see this FAQ for help in resolving licensing issues.

If you continue to have problems, please reproduce the problem and send your HM2Logs folder with a detailed description of what you were doing and what problems you were experiencing.

Fozzy71
Customer Support

Hi, when will HM3 be released?

We are currently testing a fix for the final release blocker. If all goes well it should be released soon. I don't have an actual new time estimate and probably wouldn't say at this point if I did as we are already 3 days late on the first estimate. I will be sure to post in this thread once it is live, as well as on our new HM3 sub-forums. You will know it is live when our main site/store is updated from HM2 to HM3.

Fozzy71
Customer Support

Thank you for your kind responses. Cheers!

It has been pushed back until next Monday so we can make sure everything with the new site/software is working as smoothly as possible before we go live.

Fozzy71
Customer Support