still prob with 0 hands imported

I can import hands from the import tab.

But everytime I click elsewhere, like getting a report and entering my player name, it gives me the error,

"Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately. ERROR: 42PO1: relation "players" does not exist"

I get a similar error 42PO1 whenever I try anything else with a different relation does not existing.

Does anybody here know how to fix this?

ditto

also, couldnt get it to work when i deleted DB and changed settings to US, either.....

After i deleted my database from within holdem manager. Then this comes up every time i try to start. So now i cant start holdem manager any more.

Re installing...

are you folks running vista?

I have the same problem. I'm running XP if that matters.

not me, XP

smae problems 0 hh's and I have xp also

Im on win2K.
And i got the pokerstars hhs to work now as i said.

What hhs are you guys importing?

Ok.

Dunno what happened last time when i deleted my database and nothing worked.

I tried it again now after reinstalling.And there was no problem at all.

the hands are stored in XML, you can easily pull them out with an sql query (and if you have a real need for xml, you should know how to do that)
Anyway, this is an example of an xml history.

<?xml version="1.0" encoding="utf-16"?><HandDetails SiteName="Party" GameNumber="6153235916" PokerGameType="x3f38e5caa5b2b829" BigBlindAmount="5" SmallBlindAmount="2" Ante="0" HandDate="Jul 15,2007 09:21:37" TableName="Jackpot #1304213 (6 max)" RealMoney="True" IsTourney="False" TourneyBuyin="0" TourneyEntryFee="0" TourneyNumber="" ButtonSeat="1">
<DetailLines>
<DetailLine PlayerName="diman81" Action="Seat" SeatNumber="1" StackSize="654.03"/>
<DetailLine PlayerName="INGEBLANK" Action="Seat" SeatNumber="2" StackSize="293.5"/>
<DetailLine PlayerName="AMHIL" Action="Seat" SeatNumber="3" StackSize="274.25"/>
<DetailLine PlayerName="vince577" Action="Seat" SeatNumber="4" StackSize="157.24"/>
<DetailLine PlayerName="zaika_6" Action="Seat" SeatNumber="5" StackSize="73"/>
<DetailLine PlayerName="Kittiewake" Action="Seat" SeatNumber="6" StackSize="308"/>
<DetailLine PlayerName="INGEBLANK" Action="PostedSB" Amount="2"/>
<DetailLine PlayerName="AMHIL" Action="PostedBB" Amount="5"/>
<DetailLine Action="DealingDownCards" />
<DetailLine PlayerName="vince577" Action="Folds" />
<DetailLine PlayerName="zaika_6" Action="Calls" Amount="5"/>
<DetailLine PlayerName="Kittiewake" Action="Raises" Amount="10"/>
<DetailLine PlayerName="diman81" Action="Folds" />
<DetailLine PlayerName="INGEBLANK" Action="Folds" />
<DetailLine PlayerName="AMHIL" Action="Folds" />
<DetailLine PlayerName="zaika_6" Action="Calls" Amount="5"/>
<DetailLine Action="DealingFlop" Cards="5sKd9h" />
<DetailLine PlayerName="zaika_6" Action="Checks"/>
<DetailLine PlayerName="Kittiewake" Action="Bets" Amount="5"/>
<DetailLine PlayerName="zaika_6" Action="Calls" Amount="5"/>
<DetailLine Action="DealingTurn" Cards="Kc" />
<DetailLine PlayerName="zaika_6" Action="Checks"/>
<DetailLine PlayerName="Kittiewake" Action="Bets" Amount="10"/>
<DetailLine PlayerName="zaika_6" Action="Calls" Amount="10"/>
<DetailLine Action="DealingRiver" Cards="Td" />
<DetailLine PlayerName="zaika_6" Action="Checks"/>
<DetailLine PlayerName="Kittiewake" Action="Bets" Amount="10"/>
<DetailLine PlayerName="zaika_6" Action="Calls" Amount="10"/>
<DetailLine PlayerName="Kittiewake" Action="Shows" Cards="QdJh"/>
<DetailLine PlayerName="zaika_6" Action="Mucks" Cards="Kh2c"/>
<DetailLine PlayerName="Kittiewake" Action="Wins" Amount="73.5"/>
</DetailLines></HandDetails>

rvg,

I just wanted to suggest to mention in the PostgreSQL Setup Guide, that Anti Virus Software should be turned off during install. Didn't work for me until I found that hint in this thread

P.S. Go iPoker!

I really wanted to get this 0 import thing fixed and it ended up taking a lot of time but now that it is fixed (hopefully) I can start fixing all of these other problems that will be much quicker to knock off.

In the handhistories tables you will see that one of the columns is the xml representatin of the hand (and one is the original hand history). If you know how to use pgadmin you could export them through that right now or you could just wait a bit for the automated way.

yup - proper hole card sorting is on the todo list

You will be able to choose exactly which columns you want in the hands tab soon and where they appear.

This is possible without using SQL - you can do it through filters although I haven't enabled all of the filters yet so right now you can't get this specific although you could make a filter right now like:

Position = Middle Position
Preflop Action = Unopened
Did PFR = True
Facing Three Bet = True
Called Three Bet = True
In Position on Flop = False
Saw Showdown = True

That would be pretty close.

Uggghhh. Did you delete your database first from Options - Database Management - Delete Database before trying again?

ok... Looks like there was more than 1 problem with this 0 import thing. Fixed one now need to find the second one.

ok, let me know how the reinstall goes.

Thanks for letting me know.

Does this only happen while you are importing?

Just note that the xml format will change slightly at some point during the beta with some minor tweaks and some additions like currency, table size etc.

Thanks - will make sure I add that.

rvg

exports from PT, all various types.

For the people that still have this problem, is it all PT exports or do any of you have the problem with original hand histories? I assume it is both but if it isn;t it would save me some time trying to narrow this down.

rvg

Also, anyone who still has the problem please download:

http://www.rvgsoftware.com/hm/ImportTesting.zip

And let me know what comes up when you try importing a hand into it.

Thasks,

rvg

Just want to say that I'm looking forward to when all the improvements and documentation get's done. This will surly be a big step forward from PT2.

I am importing original PokerStars hands on Vista..

yes, neither "fresh" files from party or FT import.

When I use the import tester eveything works AOK, using exactly the same txt file.

also I get, "the database could not be deleted" when using DBDelete. Therefore, I have been manually deleting it through pgAdmin, not sure if this is relevant..... maybe I am being ******ed and doing something wrong? However, HM creates a new database at start up. I am using 0.12b.

I'm getting the zero hands problem with one hh file out of around 300 (the rest import fine) These are all PS hh's exported from PT. The problem file is recognised and read by your test program.

B.t.w. you get an error when you try to read a PS hh where a player has joined and posted an extra blind.

Steve

could you make it so the "_" minimizes Hold'em Manager to the taskbar? sometimes programs will disappear from the tray if they dont respond and then you cant restore them & have to kill them with taskmanager

im using xp. i imported a bunch of obs hh from pokerstars, most of them worked, but a few would say 0 import, 0 duplicate even though they had 100s of hands in them.
i put it in your ImportTesting.exe and it worked fine. let me know where to email it.

It isn't you. It would appear that for some reason hem is trying to delete the wrong database:

<font class="small">Code:</font><hr /><pre>
pokertracker 192.168.89.1(53216) 2007-07-18 12:17:20 EDTFATAL: database "pokertracker" does not exist
pokertracker 192.168.89.1(43073) 2007-07-18 12:17:25 EDTFATAL: database "pokertracker" does not exist
pokertracker 192.168.89.1(59995) 2007-07-18 12:17:30 EDTFATAL: database "pokertracker" does not exist
pokertracker 192.168.89.1(52279) 2007-07-18 12:17:35 EDTFATAL: database "pokertracker" does not exist</pre><hr />
"pokertracker" is my pgsql username and hem seems to be mixing up arguments. Guess it's a good thing I didn't have a "pokertracker" db because it would be gone now. This is a pretty scary flaw.

hem created its own db (which I was using the hem menu entry to try and delete above) but aren't sure it ever finished because I get some error that "not a user of role postgres" or somesuch. I use remote pgsql so if hem is supplying my entire windows username (\localhost\...) then of course that user doesn't have permissions for remote pgsql because that 'user' doesn't exist there. This may not be an issue, don't know.

But I'm also seeing a shitpile of "^M" (DOS EOL/LF characters) in the pgsql log so there could (also) be some basic inter-platform compatibility issue(s) with how cmds/data are sent/rec'd. IOW if remote pgsql isn't recognizing this DOS EOL/LF then it's getting one longass string as a cmd for which I'm guessing it has no idea what it is. The log has them correctly wrapped so maybe pgsql can interpret them but in using this setup for a very long time w/pt/pa I don't recall having seen this one before.

And lastly or because of, the db hem is creating seems utterly useless to it therefore (IMM) no hands can be imported:

<font class="small">Code:</font><hr /><pre>
HoldemManagerBeta 192.168.89.1(57255) 2007-07-18 12:23:30 EDTERROR: relation "players" does not exist
HoldemManagerBeta 192.168.89.1(57255) 2007-07-18 12:23:30 EDTSTATEMENT: select * from Players where player_ID = 0
HoldemManagerBeta 192.168.89.1(43259) 2007-07-18 12:23:58 EDTWARNING: nonstandard use of \\ in a string literal at character 61
HoldemManagerBeta 192.168.89.1(43259) 2007-07-18 12:23:58 EDTHINT: Use the escape string syntax for backslashes, e.g., E'\\'.
HoldemManagerBeta 192.168.89.1(43259) 2007-07-18 12:23:58 EDTERROR: relation "importedfiles" does not exist
</pre><hr />

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.

Edit: And I;ve found with a few people that not having a "postgres" user name seemed to cause issues with DB creation. Still working through that but when I provided them the DB Creation scripts they were able to create it through pgadmin and then use HM to access the DB. I'm pretty sure they would not be able to delete the DB properly.

Another Edit: Here is the actual code that runs the DBDelete Process:

System.Diagnostics.Process.Start(CommonFunctions.A pplicationPath() + "\\DBDelete.exe", Configuration.ConnectionString.Replace("DATABASE=H oldemManagerBeta;", "DATABASE=template1;"));

One last thing about DBDelete, running it from windows explorer will not work. I actually pass in the ConnectionString as a command line to the program from HM.

rvg

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.

I'm still having the problem with 12b with exported PS hands from PT, but with the download above, it finds the hands ok. "300 hand blocks found".

Tell me if you need anything else.