Preflop Cards and Hands tab not working properly

[Antidote]

The Preflop Cards tab is not working properly in my HEM. There are hands that should be color-coded as part of the Known Cards, but are not.

http://i209.photobucket.com/albums/bb240/witandcharm/preflopcards.png

As you can see in the above screenshot, not all of the cards that should be highlighted are highlighted. For example, I know that I 3-bet AK on the BTN and that it should have some sort of color notation. If I click on AK, all the hands still show up at the bottom.


For the Hands tab, no hands ever show up. No matter what filters I run or player I choose, no hands ever show up.

Edit: I am running HEM 1.09 Beta 30 and am using Windows 7.

[netsrak]

Please try creating a new database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146
and test with importing some of the hands.

[Antidote]

I created a new database and imported some hands. The Preflop Cards tab now works properly with this database. However, it does not work with my main database. Additionally, the hands tab still does not work with either database.

[fozzy71]

....... Additionally, the hands tab still does not work with either database.

What version of postgresql? Is it a relatively new installation? Is it a large DB?

More often than not, this ends up being solved by reinstalling postgresql.


For uninstalling SQL please follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete the Program Files\Postgresql folders
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) Install PostgreSQL again, with your firewall uninstalled or turned off if windows firewall, using postgresql 8.4.0-1 - http://www.enterprisedb.com/products/pgdownload.do#windows

[Antidote]

Postgres version is 8.3.7. I installed it in mid-June. The database contains several million hands. Should I still uninstall postgres and install the latest version?

[fozzy71]

Postgres version is 8.3.7. I installed it in mid-June. The database contains several million hands. Should I still uninstall postgres and install the latest version?

That's a lot of hands to export/import, so let's try and be sure before we do. The majority of the time I have seen this issue, of no hands appearing on hands tab, or other sub-windows, it was usually cured by a reinstall of postgresql. They all had much smaller DB's though.


..... Additionally, the hands tab still does not work with either database.

Is this still the case with the new DB? Can you see your general stats on the reports tab? But not the hands in the window below? Or is it only the hands tab? Can you post a screen shot?

I doubt this will help, but try downgrading to beta 29 and see if the hands tab starts working. This is relatively unlikely to work, but will only take a minute.

http://www.holdemmanager.com/downloads/HmUpdate1.09.29.exe


I would hate for you to have to import millions of hands, but that is the direction the wind seems to be blowing in this case. :(

[a.k.a.Also]

There's a similar prob in the thread about 92o.
Try filtering sites as I find the same problem with FT hands but not PS

[Antidote]

I downgraded to beta 29 and am still having the same issues.

Reports tab functions properly. Here is a screenshot:

http://i209.photobucket.com/albums/bb240/witandcharm/reportstab.png

The hands tab and preflop cards tab still are not working properly. Here is a screenshot of the hands tab. As you can see there are no hands showing up. It doesn't matter if I change the filters or make any other changes, no hands ever show up.

http://i209.photobucket.com/albums/bb240/witandcharm/handstab.png


I really don't want to have to export and then import all my hands. I hope there is another way to resolve this.

[netsrak]

You can try to do a reindex of your database via pgadmin -> maintenance (where the vacuum is done too).

[fabio]

You are using different aliases on both screenshots. Also, please don't use "All" when you have more than 100k hands in the database

[Antidote]

You are using different aliases on both screenshots.

I am aware that I used different aliases in the screenshots. No matter what alias I select, no hands show up in the hands tab.

[Antidote]

You can try to do a reindex of your database via pgadmin -> maintenance (where the vacuum is done too).

Ok, will do. Should I select either "FORCE" or "RECREATE" as part of the Reindex options?

[netsrak]

I checked the documentation:
FORCE is obsolete
and RECREATE should be inactive

so don't use them

[Antidote]

I completed the reindex and I also did a vacuum/analyze. The hands tab now works. However the preflop cards tab still does not work right. Any ideas?

[netsrak]

Only the new database...

[Antidote]

Only the new database...

I'm not sure what you mean by this, but I did all of the reindexing and vacuum/analyze on my default database, which has several million hands.

The Preflop Cards tab still does not work. Any suggestions?

[netsrak]

The only way i see is to create a new database and import all hands into this one as i posted in my first answer.

[Antidote]

I tried creating a new database and importing some hands. This did not work to fix the problem. So I have decided to follow fozzy's advice and uninstall postgres and then go ahead and install the latest version.



For uninstalling SQL please follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete the Program Files\Postgresql folders
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) Install PostgreSQL again, with your firewall uninstalled or turned off if windows firewall, using postgresql 8.4.0-1 - http://www.enterprisedb.com/products/pgdownload.do#windows

I have done a great deal to customize Holdem Manager: custom reports, HUDs, notes, and general settings. Will uninstalling and then reinstalling Postgres affect these in any way? I do not want to lose any of my data.

Before uninstalling Postgres, I plan on doing the following in Holdem Manager: (1) Export all of my hand histories (2) export all of my notes & (3) Backup my database.

Then once I have installed Postgres, should I just restore my database?

I want to make sure I do this whole process right as a lot of important data and settings are involved.

Thanks for any help.

[netsrak]

Sounds good for me, you should also save your settings: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=98