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

07-18-2007 , 01:35 PM
rvg - is there any way that we can copy/paste a hand history from HM? I dislike that it comes up in a warning box because I like to share past HH with friends and stuff, but can't copy/paste it.
Holdem Manager Support Quote
07-18-2007 , 01:47 PM
Quote:

Hi, this is the code I'm using in DBDelete - hardcoded to avoid issues:


NpgsqlCommand CMD = new NpgsqlCommand("DROP DATABASE \"HoldemManagerBeta\"", CONN);

CMD.ExecuteNonQuery();

Not sure why the logging is saying something different? You seem to know quite a bit about Postgres so I'd be happy to provide any more info to get to the bottom of this.
I doubt I know enough to help but will just say that I open a terminal to monitor the log as I clicked "delete database" and what I pasted in is what showed up in the terminal. Repeated about a dozen times every 5s before hem posted its error 'can't delete db' dialog.

I will up logging a little to see what else it reveals but I don't think I'll see much more; it could be an issue with "^M" but I can't simulate that myself. I assume the other poster is running pgsql locally so there could be more than one issue w/the "delete" (or a single issue where the cmd/args are just plain wrong; really don't know. Mine is pgsql 8.2.3 if it matters).

TBH you seem like a very hard-working, conscientious and ambitious guy but I really only wanted to see what all the fuss was about w/hem and at this point will probably just wait until you go golden and take a look then.


Quote:

Edit: And I;ve found with a few people that not having a "postgres" user name seemed to cause issues with DB creation.
I do have a user postgres, just not local to xp. I run xp in vmware w/pgsql on linux and I doubt xp is calling him "postgres"; I'd guess something like "\localhostostgres" or something like that. But not being a windows user I don't really know; that's just that sort of thing I see when xp refers to remote discs.

Or the problem is that my xp login name has some appendage added to it by hem/xp such that linux pgsql doesn't recognize that xp user as a member of postgres group. Just a guess; but there is definitely a "postgres" user and a "postgres" group at the linux pgsql.
Holdem Manager Support Quote
07-18-2007 , 01:52 PM
Using .12b importing "fresh" files directly from FTP HH worked this time. 89 of 89 files/ 5765 hands/ 85 duplicate / 89 import errors 27.2 hands/s.

Release the HUD even if its crappy right now!

Thanks for all your hard work, I understand it's a product you are selling so you have incentive but you are doing a great job with support, keep it up.
Holdem Manager Support Quote
07-18-2007 , 02:45 PM
Am I missing something/forgot to do something or does it not move the hands after they are imported and read? Every minute it has to reread every HH in the folder?
Holdem Manager Support Quote
07-18-2007 , 02:55 PM
This is for the "delete db" problem.

I up'd verbosity to debug/error and parameters hoping to catch the actual cmd passed but it isn't showing up. The source file line number may or may not be of any use (this is 8.2.3 and linux in case compile defines make this misleading for a windows user).

<font class="small">Code:</font><hr /><pre>
pokertracker pokertracker 192.168.89.1(44936) 2007-07-18 14:20:29 EDTFATAL: 3D000: database "pokertracker" does not exist
pokertracker pokertracker 192.168.89.1(44936) 2007-07-18 14:20:29 EDTLOCATION: InitPostgres, postinit.c:318</pre><hr />

columns are:

username/database name/remote host/timestamp/debug msg

I created the hem db by using "pokertracker" as my db owner name, pw, host + port and that's it. "psql -l" lists "HoldemManagerBeta" db as existing and owned by "pokertracker" and as an SQL ASCII db.

I don't have pgadmin but IIRC "pokertracker" was the db server name and all my poker dbs are underneath (including hem's) so perhaps it's not looking for a "pokertracker" db but the pokertracker server without supplying the actual db name underneath that?

I'm sketchy on the nomenclature but this could explain why a remote and a local pgsql are both having the same problem deleting a specific db - something is stripping/leaving off the actual db name to be deleted. This is just a guess.

hth
Holdem Manager Support Quote
07-18-2007 , 02:58 PM
i wanna be able to see reports of multilpe players at the same time

currently, i search for a player, it displays their one line of stats. then i have to search for another, and the stats replace the other players ones

is there a way i can look at both at once?

also

are there definitions anywhere for what some of these 'new' stats mean? for example, turn cbet%. i assume thats the % of the time they double barrel after raising preflop?
Holdem Manager Support Quote
07-18-2007 , 03:08 PM
Quote:
Am I missing something/forgot to do something or does it not move the hands after they are imported and read? Every minute it has to reread every HH in the folder?
i dont want it to move hh files, id rather it just check if the file has be modified since the last import(like PT).
Holdem Manager Support Quote
07-18-2007 , 03:14 PM
Quote:
i wanna be able to see reports of multilpe players at the same time
It's coming

Quote:
so perhaps it's not looking for a "pokertracker" db but the pokertracker server without supplying the actual db name underneath that?
OK, that makes sense. When deleting a DB you need to first connect to the server and connect to the template1 database which should exist. I can then drop the HoldemManager database. Something isn't quite working though for some people - I'm pretty sure if it was a fresh postgresql install using my instructions that there won't be any problem and it's just a matter of time before I fix these other issues with Postgresql.

Quote:
Am I missing something/forgot to do something or does it not move the hands after they are imported and read? Every minute it has to reread every HH in the folder?
Doesn't move yet - it's coming. It won't read files that have already been imported without error if the file date has not changed but still, will be changed soon.

Quote:
rvg - is there any way that we can copy/paste a hand history from HM? I dislike that it comes up in a warning box because I like to share past HH with friends and stuff, but can't copy/paste it.
This is very temporary but I'll probably at least make it a selectable text box. The Hands tab is VERY basic right now and will be changing a lot shortly including the addition of a replayer and more.

Quote:
here's a screenshot illustrating the problem. the first file is one that said 0 import, 0 duplicate when i imported the whole folder. the second file is one that worked. then i copied the first file to a new folder and it worked.
Thanks - will look into this.

Everyone that still has the 0 import problem, I'll have something soon. Tonight I think I'll have it taken care of - thought I got it last night but it does look like there was 2 different problems causing this.

rvg
Holdem Manager Support Quote
07-18-2007 , 03:31 PM
Any idea what this error means?

"unable to read data from the transport connection. an existing connection was closed by the remote host"

I installed postgreSQL the other day. It's working flawlessly with PT (I just converted my PT db the other day) + PAHUD + etc..

I installed HM and ran it. The initial dialog told me it made a successful connection and asked if I wanted to make a database because it didn't find one.

I chose no (because one of my less technical friends was having troubles figuring out how to make a new DB after NOT creating one initially) and then the above error popped up.

It kept popping up everytime I started HM. I tried to restart postgreSQL and it didn't help. I was going to reboot but decided not to and uninstalled HM for the time being with intentions to try it again after you clean up bugs.
Holdem Manager Support Quote
07-18-2007 , 03:31 PM
Quote:
I'm pretty sure if it was a fresh postgresql install using my instructions that there won't be any problem and it's just a matter of time before I fix these other issues with Postgresql.
LOLOL - I beg to disagree.
Holdem Manager Support Quote
07-18-2007 , 03:32 PM
I'm using 0.11, and I tried running the "by Position" report filtered on one hand, KQo, and the report came back blank. The table headers were there, but no results.
Holdem Manager Support Quote
07-18-2007 , 03:42 PM
Quote:
Any idea what this error means?

"unable to read data from the transport connection. an existing connection was closed by the remote host"

I installed postgreSQL the other day. It's working flawlessly with PT (I just converted my PT db the other day) + PAHUD + etc..

I installed HM and ran it. The initial dialog told me it made a successful connection and asked if I wanted to make a database because it didn't find one.

I chose no (because one of my less technical friends was having troubles figuring out how to make a new DB after NOT creating one initially) and then the above error popped up.

It kept popping up everytime I started HM. I tried to restart postgreSQL and it didn't help. I was going to reboot but decided not to and uninstalled HM for the time being with intentions to try it again after you clean up bugs.
Hi, could you close HM then open up your program files\rvg software\holdem manager\config\holdemmanager.config file and the section that has ConnectionString that will look something like:

&lt;setting name="ConnectionString"&gt;DATABASE=HoldemManagerB eta;SERVER=localhost;PORT=5432;UID=postgres;PWD=po stgrespass&lt;/setting&gt;

change it to

&lt;setting name="ConnectionString"&gt;&lt;/setting&gt;

and relaunch HM. It should prompt you again to setup the connection and then create the database.

Thanks,

rvg
Holdem Manager Support Quote
07-18-2007 , 03:43 PM
Quote:
I'm using 0.11, and I tried running the "by Position" report filtered on one hand, KQo, and the report came back blank. The table headers were there, but no results.
Can you try removing all filters using clear filters and then run the position report and see if anything comes up. If it does then try going in and re-selecting KQo and exit and run the report again.

Thanks,

rvg
Holdem Manager Support Quote
07-18-2007 , 03:55 PM
Quote:
It should prompt you again to setup the connection and then create the database.
The problem is I wanted to start the application without creating a database.

Somehow my friend managed to get into the app without creating a database so I wanted to replicate that.

Btw the app does work when I let it make one initially.
Holdem Manager Support Quote
07-18-2007 , 04:20 PM
People with 0 hand import problem, could you try closing HM and opening it back up and use Import File and select a hand history file you have definately never tried to import before and let me know if it has the same problem.

Got a couple of different theories I'm working on but unfortunately haven't been able to duplicate yet.

Thanks,

Roy
Holdem Manager Support Quote
07-18-2007 , 04:24 PM
Quote:
People with 0 hand import problem, could you try closing HM and opening it back up and use Import File and select a hand history file you have definately never tried to import before and let me know if it has the same problem.

Got a couple of different theories I'm working on but unfortunately haven't been able to duplicate yet.

Thanks,

Roy
rvg check your PMs, just sent u a message regarding this.
Holdem Manager Support Quote
07-18-2007 , 04:24 PM
Hold'em Manager is unable to import any hand histories here. It always returns: 0 imported, 0 duplicates, 0 errors for both PartyPoker and PokerStars Hand Histories.

Tried it with importing one file and auto import.

The Import Testing tool recognizes the hand histories and returns the correct number of hand blocks.
Holdem Manager Support Quote
07-18-2007 , 04:30 PM
Thanks for letting me know - I was pretty sure that this was the case but just wanted to make sure.

rvg
Holdem Manager Support Quote
07-18-2007 , 04:36 PM
Quote:
People with 0 hand import problem.....
I am only able to load observed hands but not otherwise.

FYI I am running Postgres 8.2.

random thought - is it due to disk limitation. My PT DB is already pretty large. Checked while typing - disk still has 6GB free space. So should not be a constraint. Is there any limitation on the DB size that Postgres could handle?
Holdem Manager Support Quote
07-18-2007 , 04:50 PM
Quote:

Is there any limitation on the DB size that Postgres could handle?
Only limited by available disk capacity according to this:

http://www.postgresql.org/docs/faqs.FAQ.html#item4.4
Holdem Manager Support Quote
07-18-2007 , 04:55 PM
Quote:
People with 0 hand import problem, could you try closing HM and opening it back up and use Import File and select a hand history file you have definately never tried to import before and let me know if it has the same problem.

Got a couple of different theories I'm working on but unfortunately haven't been able to duplicate yet.

Thanks,

Roy
i am unable to import any hand histories... no error message just doesnt work...
Holdem Manager Support Quote
07-18-2007 , 05:58 PM
I can almost guarantee it will be fixed tonight. Shipitkthx has given me his aim and will be helping me out with this and at lunch I just about finished a test version to narrow this down. If anyone else with this problem will be on aim at or after 9pm PST and you'd be willing to help out please pm me uyour aim just in case Shipit can't make it.

Thanks,

Roy
Holdem Manager Support Quote
07-18-2007 , 06:14 PM
Importing Hands from PokerOffice Guide
--------------------------------------

Start PO and select the database with you like to export.

Go to the Overview Tab an select the wished limit.

Click "Show all" in the "Game details" section at the bottom of the Overview tab.

Now mark all hands in the "Game details" section and double click a hand or click right on a hand and select "Hand History" (can't remember with was the correct way to open the Hand History window - its quite a wihile since i used PO and haven't it installed at the moment), than a after same time (depeinding on the number of hands and your pc power - on may laptop it takes for 8000 quite a while) a Hand History windows with ALL your selected hands should appear. Mark all the text, copy (strg+c) it and paste it to a empty .txt file.

Now you can import this .txt file with HM. I don't know if MH can handel HH files with a great deal of HHs, so perhaps you have to spilt the files into file with less HH in it (this is the case for PT). I tired it successfully files cotaining ~1000 Hands.

Repeat this for all levels and databases you like to export.
Holdem Manager Support Quote
07-18-2007 , 08:08 PM
rvg72-

I have tried several times to download HEM from your website, but the link will not work for me. I am uzing Mozilla and Norton Antivirus, but I can't remember having problems downloading anything before.

I just click on the link and the tab says "loading" and nothing ever happens.

~confused
john
Holdem Manager Support Quote
07-18-2007 , 08:24 PM
weird...

maybe try copying and pasting this into WIndows Explorer?

http://www.rvgsoftware.com/hm/holdem...rbetasetup.zip

Let me know if that works

rvg
Holdem Manager Support Quote

      
m