Open Side Menu Go to the Top
Register
Holdem Manager Support Holdem Manager Support

05-25-2008 , 07:40 AM
Quote:
Originally Posted by Baintz
Bumping this issue. I had a search on the HEM forums and it seems a few people were having this problem a couple of months ago, and that is was high priority on the fix list back then. Couldn't find any mention of a solution though.

The majority of my play is after midnight (GMT) so if there is a already a fix to this problem I''d love to know.
+1
Holdem Manager Support Quote
05-25-2008 , 09:30 AM
When trying to open HoldEm Manager, I get an errorbox "DBControlPanel.exe - Application Error" that says "The application failed to initialize properly (0xc0000007b). Click on OK to terminate the application." Any help would be appreciated!
Holdem Manager Support Quote
05-25-2008 , 09:42 AM
Anyone know if it is possible to export the Fish List report in CSV format or similar so i can import into SmartBuddy?
Holdem Manager Support Quote
05-25-2008 , 11:02 AM
Quote:
Originally Posted by Sandokan
Hi there,

one quick question. I have the same nick on both PS and FTP, and when grouping by player, there is no difference between them. Their stats appear combined.

Is there any form of preventing this? Kind regards, Sandokan!
Any solution to this? Thanks!
Holdem Manager Support Quote
05-25-2008 , 11:26 AM
Quote:
Originally Posted by effang
Ok, i have to go to sleep. knowing that my comp is screwed, and that HM isn't working (again, I only want to get the notes, everything else seems replaceable).

I will check tomorrow morning, but anything you can assist me I would be truly thankful and will Again testify to my friends how fantastic of a product/product support you guys offer.
If you go to Control Panel - Admin - Services do you see postgresql there? If so right click and hit start. If not then reinstall it and when you get to the part of the install that has a check box for "initialize cluster" uncheck that. You should then be able to reattach to the DB (hopefully)

Quote:
Bumping this issue. I had a search on the HEM forums and it seems a few people were having this problem a couple of months ago, and that is was high priority on the fix list back then. Couldn't find any mention of a solution though.

The majority of my play is after midnight (GMT) so if there is a already a fix to this problem I''d love to know.
Sorry, kept on getting bumped. Will get it in soon.

Quote:
It is still a lot of problems with Ongame.

I play at whitebet and i have installed the 1,05,08 B and using the ongame hand grabber.

The table autodetect does not work at all and when i use the Table finder i cant move the stats, i can only move the stats outside the pokertable...

What is wrong?

//Henke
For now you can use Table Finder in the Table Manager and we will get White bet added asap. We still need to add skins when supporting ongame site otherwise the Table Manager won't detect it properly.

Quote:
1) Everytime i open HM my anti virus scanner (kaspersky) gives a warning about the exe having changed - any idea why this is ?
The code gets scrambled to protect it and Kasperksy doesn't like it

Quote:
Just like to add another vote for making popup stats clickable, i cant ditch PT2 and PAHUD until this happens.
Yes, will be done

Quote:
When trying to open HoldEm Manager, I get an errorbox "DBControlPanel.exe - Application Error" that says "The application failed to initialize properly (0xc0000007b). Click on OK to terminate the application." Any help would be appreciated!
Make sure you installed the full install and also make sure you have .net 2.0 installed properly.

Quote:
Anyone know if it is possible to export the Fish List report in CSV format or similar so i can import into SmartBuddy?
Run Report, Ctrl-A to select the whole thing then Ctrl-C to copy, open up Excel and press Ctrl-V to paste then do whatever you like with it.

Quote:
Hi there,

one quick question. I have the same nick on both PS and FTP, and when grouping by player, there is no difference between them. Their stats appear combined.

Is there any form of preventing this? Kind regards, Sandokan!
Not yet but can probably get it in quickly since it is a fairly small thing.

Roy
Holdem Manager Support Quote
05-25-2008 , 01:08 PM
Quote:
Originally Posted by steel108
A great stat is how often someone folds their steal to a 3 bet
+2
Holdem Manager Support Quote
05-25-2008 , 01:34 PM
Roy, I read here that the mgr (rake) number in the report includes the BBJ contributions at Party. I need this number without it to track the unmentionable

I've written a sql statement to get the BBJ contribution so I can subtract it from the mgr. How can I run it as a custom report/stat and does it look correct?

Code:
SELECT SUM(50.0/numberofplayers)/100.0 AS bbj 
 FROM playerhandscashkeycolumns 
  WHERE player_id = 123456
   AND pokerhand_id IN 
    (SELECT pokerhand_id FROM pokerhands p, tables t
      WHERE p.table_id = t.table_id
       AND t.tablename LIKE 'Jackpot%'
       AND p.handtimestamp >= '2008-05-01 00:00:00'
       AND numberofplayers >= 4)
   AND rakeamount >= 100.0 / numberofplayers
Holdem Manager Support Quote
05-25-2008 , 02:05 PM
Quote:
Originally Posted by Dread Wings

I did the same thing.
I'm glad I wasn't the only person to do this...
Holdem Manager Support Quote
05-25-2008 , 03:25 PM
Quote:
Make sure you installed the full install and also make sure you have .net 2.0 installed properly.
I initially installed .net 3.5 before realizing .net 2.0 was required. Is that an issue? I uninstalled .net 3.5 and downloaded .net 2.0 to install it, but during installation I get an error message saying this installation of .net is not compatible with a previous version. Please help!
Holdem Manager Support Quote
05-25-2008 , 03:41 PM
Quote:
Originally Posted by rvg72
If you go to Control Panel - Admin - Services do you see postgresql there? If so right click and hit start. If not then reinstall it and when you get to the part of the install that has a check box for "initialize cluster" uncheck that. You should then be able to reattach to the DB (hopefully)

Roy
Roy,

I did this. This prompt followed after completion...

"the postgreSQL database server 8.3 service on Local Computer started and then stopped Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."

i then proceeded to do what you told me before, see if i can access the server from pgAdmin III, but still no luck.

I am waiting on your word to reinstall...

http://wwwmaster.postgresql.org/down...ql-8.3.0-1.zip

Edit:

i downloaded this version, and installed it. but no luck, and i never got a "cluster" notice...is this the wrong version?

thanks

Last edited by effang; 05-25-2008 at 04:11 PM.
Holdem Manager Support Quote
05-25-2008 , 04:41 PM
Quote:
i downloaded this version, and installed it. but no luck, and i never got a "cluster" notice...is this the wrong version?
you need whatever version you were running prior to the crash.

I'm presuming you didn't do a postgresql backup (dump) recently? that would make things easy.
Holdem Manager Support Quote
05-25-2008 , 04:48 PM
I have been checking my stats for the last 5 months (120k hands) and it takes forever to refresh the stats. It easliy takes 5 minutes every time I make a change or refresh the filters. I just vacumed the DB and that was no help, and my comp is pretty decent 1.66 Intel Duo & 1.5gb ram. Is there something I'm doing wrong? Is there anything I can do to speed it up?

Thanks for a great product BTW!
Holdem Manager Support Quote
05-25-2008 , 05:00 PM
Quote:
Originally Posted by _dave_
you need whatever version you were running prior to the crash.

I'm presuming you didn't do a postgresql backup (dump) recently? that would make things easy.
nope...did not.

ok, i uninstalled, and tried reinstalling again.

regardless of what i'm trying to do, i can't get past the Service Configuration page...

I do not know why it isn't accepting my account password...i have tried every possible combination.

so...yeah stuck on that. would it be helpful/beneficial at all if i created a new account name instead of "postgres"?
Holdem Manager Support Quote
05-25-2008 , 05:25 PM
Quote:
Originally Posted by peyote
Roy, I read here that the mgr (rake) number in the report includes the BBJ contributions at Party. I need this number without it to track the unmentionable

I've written a sql statement to get the BBJ contribution so I can subtract it from the mgr. How can I run it as a custom report/stat and does it look correct?

Code:
SELECT SUM(50.0/numberofplayers)/100.0 AS bbj 
 FROM playerhandscashkeycolumns 
  WHERE player_id = 123456
   AND pokerhand_id IN 
    (SELECT pokerhand_id FROM pokerhands p, tables t
      WHERE p.table_id = t.table_id
       AND t.tablename LIKE 'Jackpot%'
       AND p.handtimestamp >= '2008-05-01 00:00:00'
       AND numberofplayers >= 4)
   AND rakeamount >= 100.0 / numberofplayers
I actually found a bug with rake calcs that I'll need to fix - your rake will be a little less than actual with the current formula when I import hands. Anyways, here are 2 custom stats, one for the fixed rake paid and one for fixed rake paid wo BBJ. Put these in your customstats.txt file

<Stat ColumnName="Fixed Rake" ValueExpressions="sum((PKH.rakeamount)/100.0/PKH.numberofplayers) as totalfixedrake" Evaluate="TotalFixedRake" ColumnHeader="Rake*" ColumnFormat="$0.00" ColumnWidth="60" Tooltip="Rake with bug fixed" />

<Stat ColumnName="Rake wo BBJ" ValueExpressions="sum((PKH.rakeamount - case when TABLES.Tablename like 'Jackpot%' and PKH.rakeamount >= 50 then 50 else 0 end)/100.0/PKH.numberofplayers) as totalrakewobbj" Evaluate="TotalRakewoBBJ" ColumnHeader="Rake wo BBJ" ColumnFormat="$0.00" ColumnWidth="60" Tooltip="Rake without BBJ" />

Quote:
I initially installed .net 3.5 before realizing .net 2.0 was required. Is that an issue? I uninstalled .net 3.5 and downloaded .net 2.0 to install it, but during installation I get an error message saying this installation of .net is not compatible with a previous version. Please help!
Try reinstalling 3.5 - I believe it should all be backwards compatible.

Quote:
nope...did not.

ok, i uninstalled, and tried reinstalling again.

regardless of what i'm trying to do, i can't get past the Service Configuration page...

I do not know why it isn't accepting my account password...i have tried every possible combination.

so...yeah stuck on that. would it be helpful/beneficial at all if i created a new account name instead of "postgres"?
Dave might have a better answer but you should be able to change it from postgres to say postgresEffang and then continue with the installation.

Quote:
I have been checking my stats for the last 5 months (120k hands) and it takes forever to refresh the stats. It easliy takes 5 minutes every time I make a change or refresh the filters. I just vacumed the DB and that was no help, and my comp is pretty decent 1.66 Intel Duo & 1.5gb ram. Is there something I'm doing wrong? Is there anything I can do to speed it up?

Thanks for a great product BTW!
Can you try going into pgadmin and typing "analyze". This will analyze all the tables and hopefully get postgres using the right decision trees when grabbing info. I've heard of a few people with similar issues.

Also, some stats force joining of more tables which can definitely slow things down. Try just returning total amount won and see if that still take a few minutes or if it comes back immediately to help narrow down the issue.

Roy
Holdem Manager Support Quote
05-25-2008 , 05:30 PM
Still working on 1.05.08c but just about done so should be releasing tonight. Here is the change list so far

* (1.05.08c BUG) Fixed issue with FTP 9-max cash games appearing as 10-max in the hud and positioning would be off
* (1.05.08c NEW) Added Check Raise Flop as PFR, as 3bet, Check Raise raised flop
* (1.05.08c NEW) Added many default .popup files and assigned them to all of the stats
* (1.05.08c NEW) Rebuilt the HUD Popup form to make things easier to use and added all of the recent stats. Please note, Default popups can not be edited however they can now be cloned and the clone can be edited. This is because we will be updating the defaults with more stats in future releases and do not want to overwrite your changes.
* (1.05.08c NEW) Added the option to have multiple lines per panel when using multi panels
* (1.05.08c BUG) Fixed bug when using mouse over popups. When going from one stat to the next, if they had the same panel the second one would appear blank.
* (1.05.08c BUG) Fixed full ring in the replayer - in the last build the positions of everything is off.
Holdem Manager Support Quote
05-25-2008 , 05:33 PM
Quote:
I do not know why it isn't accepting my account password...i have tried every possible combination.
It is asking for a postgres password during postgres installation? or is this holdem manager?

What kind of crash did you have... I was assuming up until this point you had formatted / reinstalled windows - not so?
Holdem Manager Support Quote
05-25-2008 , 05:36 PM
default password possibilities = postgrespass , dbpass .
Holdem Manager Support Quote
05-25-2008 , 05:41 PM
Quote:
Originally Posted by fozzy71
default password possibilities = postgrespass , dbpass .
I think he's referring to the postgres setup screen where sometimes the postgres account already exists from a previous installation and it gets all goofy unless you change the username from postgres to something else.

Roy
Holdem Manager Support Quote
05-25-2008 , 05:43 PM
I C - I was multi-tasking while attempting to post that one sentence. And saw about 5 new posts afterwards, that taught me my reading comprehension needs some work.

Holdem Manager Support Quote
05-25-2008 , 05:44 PM
Quote:
Originally Posted by rvg72


Dave might have a better answer but you should be able to change it from postgres to say postgresEffang and then continue with the installation.

Roy
Ok, hell yes!!! i am not sure what i did, or what happened, but HM finally opened.

options, notes, exports notes...and i'm set?
i can now reformat, reinstall everything, and then import? no issues at all (no going back after this)...

Thanks!!!
Holdem Manager Support Quote
05-25-2008 , 05:47 PM
run

"pg_dumpall -U postgres > c:\backup.out"

from an administrator command line, make sure it backup.out contains plenty of SQL commands. This single file should be enough to rebuild all postgresql databases after formatting, using the pg_restore command. copy this file to safe places.

Just in case it is not - do a normal backup from HM however you do that, and also export HH files, notes etc too for safety
Holdem Manager Support Quote
05-25-2008 , 08:54 PM
Quote:
Try reinstalling 3.5 - I believe it should all be backwards compatible.
Reinstalled .net 3.5 framework, checked for any updates and found none, and I still have the same error when clicking on "Use Trial."

Just for reference the error is: "DBControlPanel.exe - Application Error" in the header followed by "The application fa iled to initialize properly (0xc000007b). Click on OK to terminate the application."
Holdem Manager Support Quote
05-25-2008 , 09:04 PM
run it as an administrator... try using search function on the forum
Holdem Manager Support Quote
05-25-2008 , 09:19 PM
I have only one account and it is administrator. wat?
Holdem Manager Support Quote
05-25-2008 , 09:39 PM
Quote:
Originally Posted by stupandaus
I have only one account and it is administrator. wat?
Vista?

Quote:
Try reinstalling 3.5 - I believe it should all be backwards compatible.
I'm not entirely sure that is the case... I had 2.0 installed for a while, but I remember having to download / install 1.1 for some random app I can't remember to actually work properly... may have just been my computer - but 1.1 and 2.0 are both present in add/remove programs to this day.
Holdem Manager Support Quote

      
m