PDA

View Full Version : I get an error msg while trying to use HM



am8594
01-06-2011, 01:01 AM
This only happens on the cash games tab. Any option or tab I want to use I get this message. Tourney tabs work perfect and player info is showed as well.

I already tried vacumming and reindexing the database but still dont work:

http://img407.imageshack.us/img407/2129/errorhm.th.jpg (http://img407.imageshack.us/i/errorhm.jpg/)

What do would you advice with this?

Meh..I will write down the error message for you cause I cant figure how to make the pic larger..

The following error occurred when running this report: ERROR:42P01: missing FROM-clause entry for table "td"

netsrak
01-06-2011, 04:43 AM
Please try a reindex of your database via pgadminIII->maintenance.
If that doesn't help you should create a new database and reimport all your hands (+notes +summaries).

am8594
01-06-2011, 08:14 AM
I did this prior to writting this thread.

Via pgadmin I tried vacumming and reindexing...didnt work so tried creating a new db and importing my hands again but happened again in the new db.

Hands seem to be importing fine at both DBs since when I use the PLAYERS tab I can see all my hands imported. The problem is when I want to use any tab on the cash game section.

Any other advice?

netsrak
01-06-2011, 09:40 AM
Hard to identify anything on your screenshot. Are you using 1.11.05e?
If not please update: http://www.holdemmanager.com/Downloads/HmUpdate.exe

am8594
01-06-2011, 07:06 PM
Ok..Managed to get a larger image for you to see.

Ive done all these things already:


Vaccuming the DB
Reindexing the DB
I created a brand new DB and imported the hands again
I also installed 1.11.05e (I had 1.11.05)


Please let me know if you want me to send you files or logs or anything but please help me solve this asap...Seems that I cant live without this program working properly.

I repeat, All the features under the tournament tab work fine..the function that dont work are the ones under the CASH tab.

This message error pops up everytime I click on an option like "reports" or "sessions" , the only time I get a different error message is when I select "graph" . I atach here also that screenshot.

Thanks for looking

http://img695.imageshack.us/img695/3922/error2s.jpg (http://img695.imageshack.us/i/error2s.jpg/)

http://img600.imageshack.us/img600/1732/error3o.jpg (http://img600.imageshack.us/i/error3o.jpg/)

netsrak
01-07-2011, 06:04 AM
I think this is caused by some columns you removed from the reports.

I think you should do a fresh HM installation:
Please uninstall HEM using Revo Uninstaller: FAQ - Hold'em Manager Poker Tracking Software :: Using Revo Uninstaller (http://faq.holdemmanager.com/questions/126/Using+Revo+Uninstaller+)

After completion please reboot your computer and download and install the full installer from our homepage. Please make sure that the postgresql option is disabled during the installation.