vs hero stats do not work

[Woeggil]

The title says it. None of the vs hero stats work in the reports. Every field is shown na
Is there a procedure to make it work?

[udbrky]

Sometimes, if there are other players that have multiple hole cards showing can be read as the hero. This causes their hands to reset on the table, as if they were you. Note that editing the database could result in a corrupt database so only attempt this if you know what your doing. Please see these steps to reset the hero:

1) Please open PGAdminIII (Start - Postgres)

2) Enter your pw (default is postgrespass)

3) Open databases - expand DB name - expand schemas - expand public - expand Tables

4) Choose settings, right click - view data, show all rows

5) Clear the value in the second row (current player)

6) Restart HM2

PGAdmin info screen looks like this - http://www.holdemmanager.com/Downloads/null.png

[Woeggil]

Hey udbrky

Thanks for the reply. Sadly it did not work.
Some things i noticed: There are seemingly two servers viewable in postgres that have the same structure
you described. I deleted my nick out of both of them and saved which had also no effect on the stats. If
you need any more information please let me know.

[udbrky]

Please try to vacuum/analyze and reindex your database - Hold'Em Manager 2 FAQs - Poker Software :: Database Manager (Ribbon) (http://hm2faq.holdemmanager.com/questions/5/Database+Manager+%28Ribbon%29#maintenance)

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 (http://hm2faq.holdemmanager.com/questions/3091/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? (http://hm2faq.holdemmanager.com/questions/1471/How+does+Backup+and+Restore+Database%2C+Settings+a nd+HUD+configs+work%3F)

If none of that helps please zip and email the problem hand histories to us using the 'Contact Support' link here - https://support.holdemmanager.com/support/product/1

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.

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 'copy public link' and paste the download link directly into the support ticket email.