preflop stats for tourneys with certain buy-in
Results 1 to 8 of 8
  1. #1
    Junior Member
    Join Date
    Mar 2011
    Posts
    8

    Default 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.

  2. #2
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    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

  3. #3
    Junior Member
    Join Date
    Mar 2011
    Posts
    8

    Default

    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.

  4. #4
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    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

  5. #5
    Junior Member
    Join Date
    Mar 2011
    Posts
    8

    Default

    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.

  6. #6
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,777

    Default

    The filter crash already is an open bug which is in the developers queue

  7. #7
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    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

  8. #8
    Junior Member
    Join Date
    Mar 2011
    Posts
    8

    Default

    As I said I managed to reinstall PostgreSQL.

    Let's hope for the HEM update.

Similar Threads

  1. Preflop stats for full ring.
    By oftalmolog in forum Manager General
    Replies: 3
    Last Post: 05-15-2009, 01:41 PM
  2. preflop all in ev stats + cpu usage
    By HMNoob in forum Manager General
    Replies: 1
    Last Post: 10-30-2008, 12:55 PM
  3. Question regarding HU preflop stats.
    By Arecal in forum Manager General
    Replies: 1
    Last Post: 10-06-2008, 12:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •