PDA

View Full Version : last 100 hands



Diceman
09-01-2009, 11:00 PM
i havent played poker in 3 months and rebuilt my computer in that time. i still had the database on a remote linux server.

i played today. hands are importing but i dont get any data in the "last 100" sections on any of the reports.

i updated to the latest beta before i start playing.

any thoughts?

Diceman
09-01-2009, 11:19 PM
so i filtered by all hands and then clicked all hands on the hands tab, HEM crashed. beta bugs imo.

netsrak
09-02-2009, 03:08 AM
Which version are you using?
I don't think this is a general bug.

Please try to create a new database and do some testing with it.

Diceman
09-02-2009, 08:48 AM
it worked fine before i upgraded to the beta yesterday. it is unacceptable for me to have to rebuild my entire database, again.

fozzy71
09-02-2009, 08:55 AM
so i filtered by all hands and then clicked all hands on the hands tab, HEM crashed. beta bugs imo.

I would never try to load my lifetime of 'all hands' to the hands tab. A month or 2 perhaps, but trying to load 100's of thousands of hands in that tab can be very CPU intensive.


it worked fine before i upgraded to the beta yesterday. it is unacceptable for me to have to rebuild my entire database, again.

DB's can become corrupt for no apparent reason sometimes. If you try a new DB, with a small portion of your archives, and the problem does not persist, you can be sure the problem is with your existing DB.


*Please make sure your Windows Auto Update is fully updated.
*Make sure you have Microsoft .Net Framework 3.5 SP1 installed.
*Try creating a new DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, then delete the old DB. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21

Diceman
09-02-2009, 11:39 AM
you know who you're talkin to right foz? ;-) i'll do the new database thing to test it, but i wont be happy about it.

i never got a message back from you via aim last night else the thread probly wouldnt have gotten posted.

fozzy71
09-02-2009, 01:27 PM
you know who you're talkin to right foz? ;-)


I was about 98% sure it was you, yes. Although there is at least one other 'diceman' on 2p2. ;)




i'll do the new database thing to test it, but i wont be happy about it.

I do it every few weeks just for the fun of it. :p


i never got a message back from you via aim last night else the thread probly wouldnt have gotten posted.

I am very sick right now and had taken Nyquil. I saw your AIM but was in no shape to talk about HM. :(

Diceman
09-02-2009, 10:48 PM
so i built a new database called test. imported about 400 hands into it and selected me as the player. no dice, no pun intended. it shows that i played hands, sees sessions, etc but the 100 hands, 500hands window does not populate.

btw this is running sql on a remote linux machine. getting ready to fresh install HEM on a different box and see if i can get it to work on that database.

ok, so i fire up an old version 1.05.09 and it works perfectly. i upgraded straight from 1.05.09 to 1.09 beta 30 on the broken pc. other than fresh install i dont know what else to try. thoughts?

fozzy71
09-02-2009, 11:12 PM
In case you want to try:


Before you uninstall HM:

I want to re-install Holdem Manger without losing all of my settings and preferences. Can this be done? - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=98

You want to make sure you backup your Processed/Archived hand histories, your entire \config folder, and your exportednotes file. http://www.holdemmanager.net/faq/?f=119. I usually just copy my entire \Holdem Manager directory.

I would also make sure you manually export the database to hand history text files:

HM > Options > Database Management > Connect > Export Hands

How do I export or import hands into and from Holdem Manager? - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173

Make sure you copy that folder as well as the other stuff I mentioned.

This helps to insure that if anything goes wrong with the backup/restore, you can manually import the exported files to rebuild.



If you have Vista, please verify that UAC is still off. - http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73. If it is on, please turn it off and reboot.

Turn off Windows Firewall for installing HM and PostgreSQL. You must also add exceptions to the Windows firewall, even if it is off. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

1) Make a backup of your C:\Program Files\RVG Software\Holdem Manager\Config folder, and any other important files mentioned earlier.
2) Uninstall HM with www.revouninstaller.com using the Deep setting.
3) If given the option, on the 2 following screens of Revo, choose the Select All > Delete buttons to remove any registry entries and leftover files.
4) Reboot your computer
5) Install the complete setup of HM: http://www.holdemmanager.com/downloads/holdemmanager.zip
6) Download the latest patch HM: http://www.holdemmanager.com/downloads/HmBetaUpdate.exe
7) Test if it for a while and see if it work
8) Close down Holdem Manager and rename the current, working \config folder to \config_original. Now copy your \config folder from step 1 and paste it to your C:\Program Files\RVG Software\Holdem Manager\ fodler, to replace the one you just renamed.
9) Test if it works again for a while
10) If your old config folder causes problems, you can paste the contents of the \config_original folder back in.
11) Now you can import any notes and hud configs.

fabio
09-03-2009, 04:24 AM
What PostgreSQL version are you running? 8.0?

Diceman
09-03-2009, 08:56 AM
What PostgreSQL version are you running? 8.0?

yes, 8.0.8_1 from FreeBSD Port.

Rvg72
09-05-2009, 11:35 PM
Hi, I have come across the same issue one time before with a person running a linux version of Postgresql and it is due to one of the programming languages not being installed by default.

We use plpgsql for some of our internal functions in the db so you need to make sure this is added to your HM database so you can use the CREATE LANGUAGE command in Postgresql to add it.

Roy

Diceman
09-06-2009, 10:06 PM
Hi, I have come across the same issue one time before with a person running a linux version of Postgresql and it is due to one of the programming languages not being installed by default.

We use plpgsql for some of our internal functions in the db so you need to make sure this is added to your HM database so you can use the CREATE LANGUAGE command in Postgresql to add it.

Roy

Mark that up to two times now. That has fixed my issue. Thanks for your help.