preflop stats for tourneys with certain buy-in
I can see my preflop stats in "Reports>Overall". But when I'm trying to use a filter to display stats for, say, 6.50$'s report comes back with "na" fields and if I'm clicking "Filter>Edit" again it shows an error message (unhandled exception has occurred in your application... Input string was not in correct format).
Professional HM 1.11.06b (Win7 32). PokerStars.
When I was using trial HM (prior version) I couldn't did this trick either. Maybe I'm just doing something wrong. Thanks.
Which filter are you using?
You get this error with ANY filter?
Which SQL version are you using?
Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.
If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here
I'm going to "Filter>Edit>Main Filters" and put buy-in size in tourney details (like from 6.50 to 6.50, tried from 0 to 6.50 also), then "Save and Close".
In general filters work ("hand values" and "more filters" for sure).
"Hole Cards (HE)" selection do nothing at all.
Most in "Main Filters" work, except for Buyin.
Psql 8.4, bundled.
About 40k hands in the DB.
Update SQL to 8.4.7 from PostgreSQL: The world's most advanced open source database
Set the date formatting of your computer to M/d/yyyy (so NOT to European standard d/M/dddd @ Windows-->control panel--> language & region settings)
And try to create a new database--> reimport the hands-->
run the filter again.
Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.
If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here
I manually removed psql user account and completely reinstall psql (v8.4.7-1), (wasn't able to update it, wrong password, "postgrespass" didn't do it).
My pc's date is in the US format already (M/d/yyyy).
I made a new DB and re-import all hands.
Nothing changed.
Last edited by eurotic; 03-20-2011 at 03:59 AM.
The filter crash already is an open bug which is in the developers queue
click on Start and go to Programs -> Accessories -> Command Prompt
* If you are on Vista, rightclick and choose "Run as Administrator".
A black box should appear. Type 'net user postgres /delete' (without the quotes) and press enter.
The user is now deleted and you can (re)install PostgreSQL. And it will accept "postgrespass" as password again.
Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.
If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here
As I said I managed to reinstall PostgreSQL.
Let's hope for the HEM update.
Posting Permissions
Reply With Quote