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.
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.