HUD does not work anymore

[P41N]

Hi, i´m using HM for a year and I never had any problems with it. Since a few days my HUD is not working anymore. Settings are all correct, the table manager shows all tables. Even table finder cant find any attached hands.
I already read the FAQ´s, but they dont really help in this case.
I installed avira10 a few days ago, could this may cause this problem?
Thx for any help.


Andreas

[Patvs]

If it started when you installed Avira, that's probably causing it.
Make sure you set axceptions to Avira for the HoldemManager and Postgres folder and for port 5432.



Which Operating System, Firewall?

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

For W7 and Vista you must set \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select properties... then select "Run as admin" from the compatibility tab. If you have Vista and the checkboxes are greyed out and you can't select it, please turn UAC on, reboot, and then set the files to run as administrator.

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily

[P41N]

Operation system is XP and i´m using Sygate firewall.

Avira was running already on my system before, I just updated to avira10.

Now I updated to the latest version of HM.
When I start the Auto-Import now, the table-manager opens and in the same second I get the system-message, that the HM-HUD hast to been stopped, cause a problem ocurred.
Finally I get the HUD started, but it shows only stats that I already have in my database. New hands will not be added. Also "reports" and "sessions" don´t show any new hands.
I tryed on ipoker and Ongame, both the same.
I never canged anything in the Import settings.

[netsrak]

Uninstall Avira 10 (disabling is not enough)
Delete all files in the handhistory folders of your pokerclients or move them to a different folder.
Reboot your computer and try again.

If it works now the problems are caused by Avira10.

Reinstall it and try to configure it correctly for Postgresql and Holdemmanager to work.
http://faq.holdemmanager.com/questio...%28Firewall%29

[P41N]

All done. HUD shows only elder stats.
I had a look on Import while playing some hands. It shows after a played hand: 1 hand imported / import errors: 1

[netsrak]

Please create a new database and test some hands.

If this works try a reindex of your old database via pgadminIII.

If that doesn't help your database seems to be corrupt.

[P41N]

Creating a new database worked, hands will be imported.
How can I reindex my old database? Is there anywhere an instruction for it? I´m not a PC-Specialist.

[fozzy71]

There is a Reindex option on the same Maintenance window of PGAdmin as the Vacuum/Analyze option.

FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database

[P41N]

Done. But didn´t help.

Here is the report:

NOTICE: table "pg_class" was reindexedNOTICE: table "sql_features" was reindexedNOTICE: table "sql_implementation_info" was reindexedNOTICE: table "pg_statistic" was reindexedNOTICE: table "sql_languages" was reindexedNOTICE: table "sql_packages" was reindexedNOTICE: table "sql_parts" was reindexedNOTICE: table "sql_sizing" was reindexedNOTICE: table "sql_sizing_profiles" was reindexedNOTICE: table "pg_ts_config" was reindexedNOTICE: table "pg_ts_config_map" was reindexedNOTICE: table "pg_ts_dict" was reindexedNOTICE: table "pg_ts_parser" was reindexedNOTICE: table "pg_ts_template" was reindexedNOTICE: table "pg_type" was reindexedNOTICE: table "pg_attribute" was reindexedNOTICE: table "pg_proc" was reindexedNOTICE: table "pg_autovacuum" was reindexedNOTICE: table "pg_attrdef" was reindexedNOTICE: table "pg_constraint" was reindexedNOTICE: table "pg_inherits" was reindexedNOTICE: table "pg_index" was reindexedNOTICE: table "pg_operator" was reindexedNOTICE: table "pg_opfamily" was reindexedNOTICE: table "pg_opclass" was reindexedNOTICE: table "pg_am" was reindexedNOTICE: table "pg_amop" was reindexedNOTICE: table "pg_amproc" was reindexedNOTICE: table "pg_language" was reindexedNOTICE: table "pg_largeobject" was reindexedNOTICE: table "pg_aggregate" was reindexedNOTICE: table "pg_rewrite" was reindexedNOTICE: table "pg_trigger" was reindexedNOTICE: table "pg_description" was reindexedNOTICE: table "pg_cast" was reindexedNOTICE: table "pg_enum" was reindexedNOTICE: table "pg_namespace" was reindexedNOTICE: table "pg_conversion" was reindexedNOTICE: table "pg_depend" was reindexedNOTICE: table "compiledplayerresults_month" was reindexedNOTICE: table "actiontypes" was reindexedNOTICE: table "pokersites" was reindexedNOTICE: table "handhistories" was reindexedNOTICE: table "playerhandstourneykeycolumns" was reindexedNOTICE: table "specialholecardactions" was reindexedNOTICE: table "importedfiles" was reindexedNOTICE: table "holecards" was reindexedNOTICE: table "playerhandscashkeycolumns" was reindexedNOTICE: table "compiledplayerresultspositionaction_month" was reindexedNOTICE: table "compiledresults_month" was reindexedNOTICE: table "allinsituations" was reindexedNOTICE: table "playerhandscashmisc" was reindexed
ERROR: invalid page header in block 1446 of relation "playerhandstourneymisc"

ERROR: invalid page header in block 1446 of relation "playerhandstourneymisc"

[Patvs]

Your old database is corrupt. And a reindex of the index "playerhandstourneymisc" didn't solve it. So you'll have to use a NEW database.