Open Side Menu Go to the Top
Register
PokerTracker 3 PokerTracker 3

05-02-2008 , 05:02 PM
Quote:
Originally Posted by bacanef2007
i re-imported hand histories into new database, deleted old one and this fixed problem. However not all the histories where transferred, i lost like 10K from a 35K sample.

NEW PROBLEM: the poker tracker icon that appears on the tables is blocking the pot size amount in pokerstars. (just above the cashier)especially when i cascade the tables due to playing multiple talbes. i.e. 10+. so i have to put cursor over the pot chips graphic so that the pot amount will display. but this amount doesnt include bets. this is really slowing me down. could you look into this and fix it. (this wasnt an issue in previous betas)


i dont know what this means: attach PokerTracker.log file to a support ticket.
i aint that computer savy
I'm guessing not all the hand history files were imported. The PT icon can be moved, right click on the "handles" and drag to move. Save the layout to keep it in its new position. PT3 writes a log file, PokerTracker.log. It's located in the main PT3 directory (C:\Program Files\PokerTracker 3). Attach it to a support ticket.

Quote:
Originally Posted by frumpus
Wow I wish I had come here and read about the loss of tournament histories before doing this update. Is there going to be a way to get them into this version quickly or do we have to wait for the next update before re-exporting the old database?
I'll try to get this in the next beta, which I hope to have out early next week.

Quote:
Originally Posted by iSTRONG
I'm getting this message on a few of my imports:

2008/05/02 19:19:09: Unable to import hand. Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: numeric field overflow DETAIL: A field with precision 4, scale 2 must round to an absolute value less than 10^2. CONTEXT: COPY holdem_hand_summary, line 4, column amt_rake: "1985.00" )

Those hands imported fine in the previous beta.
If you can get me a copy of the hands causing this problem, that would be great. Having a rake of $1985 is definitely a problem.

Quote:
Originally Posted by insyder19
I get this error if I try to import my exported HH from pt2 or if I try to autoimport during the play

Looks like you didn't create a new database with beta 10.

Quote:
Originally Posted by gball
Converting PT2 db I get these a lot too:

Too many players in hand. 3243501 out of 3914898 (id: 3243501)
Strange. If you export, and import the exported files, do you get the same errors?

Quote:
Originally Posted by orentha
now it's peaking at 14.1 hands/sec, with 12 hrs remaining...
this can't be normal
Check your Task Manager. What's your CPU usage like?

Quote:
Originally Posted by Greg29
How do I completely delete my old databases from my PC ? Not only from PT3 but also from postgresql. Thanks
PT3's Database Management window offers a Delete option. It deletes the database from PostgreSQL.
05-02-2008 , 05:33 PM
Quote:
Check your Task Manager. What's your CPU usage like?
My CPU usage is 26,480K of memory
in the CPU column, it's at 00, and it sometimes jumps to 7-12 or so, but that's only for a split second, then goes back to 00
05-02-2008 , 05:38 PM
are we able to mark hands for review with the hud yet?
05-02-2008 , 05:52 PM
the hud stopped working, and yes i have made a new database and choosed it in hud options..
05-02-2008 , 05:56 PM
I am still having bad lag problems when using the HUD on beta 10 (8 tables). The choppiness and lag basically make it unusable. How do I fix this and are others having problems?
05-02-2008 , 06:24 PM
Quote:
Originally Posted by wildpike
I am still having bad lag problems when using the HUD on beta 10 (8 tables). The choppiness and lag basically make it unusable. How do I fix this and are others having problems?
Yep I'm having the same issues. I have put a ticket in so just waiting for a reply.
05-02-2008 , 06:33 PM
Quote:
Originally Posted by orentha
My CPU usage is 26,480K of memory
in the CPU column, it's at 00, and it sometimes jumps to 7-12 or so, but that's only for a split second, then goes back to 00
In the Task Manager, there's a performance tab. It shows the total CPU usage as a percentage. What is this percentage?

Quote:
Originally Posted by DerekJCEX
are we able to mark hands for review with the hud yet?
Not yet.

Quote:
Originally Posted by JimmyRare
the hud stopped working, and yes i have made a new database and choosed it in hud options..
What do you mean it stopped working? Is auto-import importing hands? Is there a PT icon on your tables?

Quote:
Originally Posted by wildpike
I am still having bad lag problems when using the HUD on beta 10 (8 tables). The choppiness and lag basically make it unusable. How do I fix this and are others having problems?
Check your Task Manager and see what your CPU usage is. Then look and see what process is using most of the CPU usage. If it's PokerTracker.exe or postgres.exe, try going into the PT Icon -> Config. Stats. -> Hud Options and disable the option that retrieves session stats.
05-02-2008 , 06:41 PM
my CPU performance is at 29%, plus or minus 1-2%
05-02-2008 , 06:41 PM
is there way i can find out the exact color grading that was used for the original PAHUD stats? i hope i'm not coming off as being lazy about this. i'm just so used to the colors on the original. so if create them myself, they would probably be a little off and end up tilting me
05-02-2008 , 06:42 PM
I dont think PT3 is importing ipoker (Carlos) hands correctly.

Ive just played a session and PT3 says i had a profit of $850.48 but my actual cash profit was $736.46. When i imported the same hands into PT2 it agreed exactly.
05-02-2008 , 06:52 PM
EDIT: ok i fixed it. i am a moron
05-02-2008 , 06:54 PM
Quote:
Originally Posted by PokerAce
What do you mean it stopped working? Is auto-import importing hands? Is there a PT icon on your tables?
The PT icon is there, nothing else...
05-02-2008 , 06:58 PM
Quote:
Originally Posted by PokerAce
Quote:
Originally Posted by unzip
Is there a way to filter for blind vs blind hands (create filter where I'm in BB and facing steal by SB, also situations where I'm in BB and the stealer is BTN etc)? There are options for steal situations in 'Filters'->'Facing'->'Facing steal', but can I play with filters to analyze more specific steal situations?
I'm considering adding the position of the aggressor when facing a raise to the database.
I glanced over database schema and basically I was interested in hands where everybody whose position in specific hand is <8 have flg_p_fold=TRUE and player whos position is 8 (BB) is me and player whos position is 9 (SB) has flg_p_fold=FALSE (in holdem_hand_player_statistics table). I'm no sql expert, but if such queries are more or less easily doable for more experienced sql users then we can save holdem_hand_summary.id_hand list into a file using pgAdmin III. Have you considered having possibility in the future to import hand id's list from file so we can make queries beyond filters of PT3 directly in PostgreSQL and then analyze/overview selected hands later with PT3?
05-02-2008 , 07:02 PM
Quote:
Originally Posted by Schnuedel
Hi,
If I tell PT only to read from one Database everythings works fine with the HUD, but as soon as I switch on a 2nd Database there are no stats shown any more. Am I doing something wrong?
Of course I created new databases so this shouldnt be the problem.
PS: I play on Party

pokerace, same problem for me. i play on pstars. if I have multiple databases selected i the hud setup screen, the stats do not display on the table, however if i only select one database, the stats show up. by the way, the placement of the PT icon in pstars will need to change since it blocks part of the pot display.
05-02-2008 , 07:07 PM
Is it normal when running the HUD that the query execution times in the log file are somewhere around 30 seconds (for example: 35446.65977100 ms), or is my PC just trashed? It just takes like 10 minutes before any stats are shown on maybe 2 tables out of 12. Then I edit the HUD config and again 10 minute wait to see how it looks like.
05-02-2008 , 07:11 PM
Quote:
Originally Posted by PokerAce
What do you mean it stopped working? Is auto-import importing hands? Is there a PT icon on your tables?
Quote:
Originally Posted by JimmyRare
The PT icon is there, nothing else...
i'm having the same issue. the stats aren't being displayed. i tried hitting reset but that didnt work.
05-02-2008 , 07:18 PM
Quote:
Originally Posted by DerekJCEX
i'm having the same issue. the stats aren't being displayed. i tried hitting reset but that didnt work.
same here
05-02-2008 , 07:24 PM
Some observations on HUD.

Now HUD is working for me with new BETA and is pretty solid (maybe it is because of new database that doesn't have many hands in it).

Basically, it works perfect if I play up to 9 tables. It is just the nuts. But when increasing the number of tables from 12 to 20 there are some problems. I don't know how to explain this, but when the software switches action to warn you that you have to act on the other table (stars and I tile them), there is like a moment, not even half a second of a delay. Nothing big, I don't consider this lagging, it is just a bit annoying.

Black boxes around stats bother me a bit. I would prefer if it was like PT2, when it looked like the stats were on the table. Is there an option for this? The only time it lags a bit and there is a danger of timing out if you play more than 12 tables is when you click "tile tables". It takes some time. And with 12+ tables, I sometimes have to click fold button more times for the software to fold my hand because it doesn't apply layouts fast enough (don't know how to explain this, but you probably know what I am talking about). Another problem is that it is very easy to misclick popup stats instead of action button and then I have to click again for popup stats to close and once again action button. So it is more clicking than without HUD.

Just some of my insight. But as I said before, up to 9 tables works perfect and I had no problems playing 20 tables, it just wasn't perfect. It is a great product though. Keep doing the good work.
05-02-2008 , 07:29 PM


What this means? HUD shows stats from players that are not in the table, and mucked cards that do not correlate to hands played in that table. HUD+PT3 froze after I took the screenshot btw, dunno if it was coincidence or not.
05-02-2008 , 07:35 PM
For those of you having problems with stats not showing on the HUD, go into the HUID options tab of the config screen and make sure you only have ONE database selected. If you have more than one, the stats might now show. I had the same problem and by limiting the databases selected to one, it finally showed stats on my HUD
05-02-2008 , 07:40 PM
I have the same problem as Insyder19

Quote:
2008/05/02 18:24:10: PokerStars: Unable to import hand (#17156867742). Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: extra data after last expected column CONTEXT: COPY holdem_hand_summary, line 1: "123110 100 1 4456 17156867742 2008/05/02 23:21:58 2008/05/02 18:24:09 9 2 0 0 55.40 95.00 0.00 0.00 ..." )
2008/05/02 18:25:22: PokerStars: Unable to import hand (#17156897776). Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: extra data after last expected column CONTEXT: COPY holdem_hand_summary, line 1: "123111 100 1 4456 17156897776 2008/05/02 23:23:25 2008/05/02 18:25:22 9 2 2 2 55.40 100.35 100.35 10..." )
2008/05/02 18:25:35: PokerStars: Unable to import hand (#17156897776). Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: extra data after last expected column CONTEXT: COPY holdem_hand_summary, line 1: "123112 100 1 4456 17156897776 2008/05/02 23:23:25 2008/05/02 18:25:35 9 2 2 2 55.40 100.35 100.35 10..." )
2008/05/02 18:26:12: PokerStars: Unable to import hand (#17156925678). Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: extra data after last expected column CONTEXT: COPY holdem_hand_summary, line 1: "123113 100 1 4456 17156925678 2008/05/02 23:24:45 2008/05/02 18:26:12 9 0 0 0 55.40 0.00 0.00 0.00 2..." )
2008/05/02 18:26:56: PokerStars: Unable to import hand (#17156942088). Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: extra data after last expected column CONTEXT: COPY holdem_hand_summary, line 1: "123114 100 1 4456 17156942088 2008/05/02 23:25:32 2008/05/02 18:26:56 9 0 0 0 55.40 0.00 0.00 0.00 2..." )
2008/05/02 18:28:02: PokerStars: Unable to import hand (#17156957258). Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: extra data after last expected column CONTEXT: COPY holdem_hand_summary, line 1: "123115 100 1 4456 17156957258 2008/05/02 23:26:16 2008/05/02 18:28:02 9 0 0 0 55.40 0.00 0.00 0.00 2..." )
2008/05/02 18:29:01: PokerStars: Unable to import hand (#17156980108). Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: extra data after last expected column CONTEXT: COPY holdem_hand_summary, line 1: "123116 100 1 4456 17156980108 2008/05/02 23:27:22 2008/05/02 18:29:01 9 2 0 0 55.40 81.60 0.00 0.00 ..." )
2008/05/02 18:29:28: PokerStars: Stopping auto-import.
2008/05/02 18:29:28: Auto-Import stopped.
2008
It IS NOT because I have not created a NEW database. I imported the hands sucessfully using the "Import from Directory" in the Manual Import.

1) Created a new database
2) Imported hands from 2008 using Manual Import - Import from directory
3) Opened table and started Auto-Ipmort
4) This was the result
5) Opened my stats in Holdem Tab -- They were present and looked correct, except for the hands above
6) Imported problematic hands using Manual Import
7) Made this post

There is something wrong with the Auto-Import function, at least for us.

I will attach my log file to a PT3 support ticket and ID myself to relate to this post.
05-02-2008 , 07:41 PM
Quote:
Originally Posted by DerekJCEX
i'm having the same issue. the stats aren't being displayed. i tried hitting reset but that didnt work.
sigh... it was set to 25 minimum hands and i hadn't played that many. it works fine now
05-02-2008 , 07:44 PM
Quote:
Originally Posted by orentha
my CPU performance is at 29%, plus or minus 1-2%
That shouldn't be causing lag. You would need much closer to 100% to be causing lag. Is your video driver up to date? That might be causing problems.

Quote:
Originally Posted by InsideEdge
I dont think PT3 is importing ipoker (Carlos) hands correctly.

Ive just played a session and PT3 says i had a profit of $850.48 but my actual cash profit was $736.46. When i imported the same hands into PT2 it agreed exactly.
Please attach the xml for this session to a support ticket on our site. I'll get the problems fixed.

Quote:
Originally Posted by JimmyRare
The PT icon is there, nothing else...
Make sure in the Hud Options (PT Icon -> Config Stats -> Hud Options tab) that you only have one database highlighted. There's a bug that's preventing multiple databases from working. It will be fixed soon.

Quote:
Originally Posted by unzip
I glanced over database schema and basically I was interested in hands where everybody whose position in specific hand is <8 have flg_p_fold=TRUE and player whos position is 8 (BB) is me and player whos position is 9 (SB) has flg_p_fold=FALSE (in holdem_hand_player_statistics table). I'm no sql expert, but if such queries are more or less easily doable for more experienced sql users then we can save holdem_hand_summary.id_hand list into a file using pgAdmin III. Have you considered having possibility in the future to import hand id's list from file so we can make queries beyond filters of PT3 directly in PostgreSQL and then analyze/overview selected hands later with PT3?
You can do a "SELECT id_hand FROM holdem_hand_summary;" and export the results to file if you need a list of hand ids.

Quote:
Originally Posted by erdiesel
pokerace, same problem for me. i play on pstars. if I have multiple databases selected i the hud setup screen, the stats do not display on the table, however if i only select one database, the stats show up. by the way, the placement of the PT icon in pstars will need to change since it blocks part of the pot display.
This will be fixed soon.

Quote:
Originally Posted by gball
Is it normal when running the HUD that the query execution times in the log file are somewhere around 30 seconds (for example: 35446.65977100 ms), or is my PC just trashed? It just takes like 10 minutes before any stats are shown on maybe 2 tables out of 12. Then I edit the HUD config and again 10 minute wait to see how it looks like.
That is not normal. These queries should take milliseconds, not seconds. I think somehow it's retrieving your lifetime stats sometimes and that's what makes those queries take so long. You can test this by using a fresh database and see if you still have the long query times.

Quote:
Originally Posted by gball


What this means? HUD shows stats from players that are not in the table, and mucked cards that do not correlate to hands played in that table. HUD+PT3 froze after I took the screenshot btw, dunno if it was coincidence or not.
I'm guessing there were hand histories around from earlier in the session, or maybe even earlier sessions.
05-02-2008 , 07:46 PM
Quote:
Originally Posted by MuckinWinners
I have the same problem as Insyder19



It IS NOT because I have not created a NEW database. I imported the hands sucessfully using the "Import from Directory" in the Manual Import.

1) Created a new database
2) Imported hands from 2008 using Manual Import - Import from directory
3) Opened table and started Auto-Ipmort
4) This was the result
5) Opened my stats in Holdem Tab -- They were present and looked correct, except for the hands above
6) Imported problematic hands using Manual Import
7) Made this post

There is something wrong with the Auto-Import function, at least for us.

I will attach my log file to a PT3 support ticket and ID myself to relate to this post.
In the Auto-Import window, under the Preferences, make sure the database configured for Import Played Hands and Import Observed Hands is set to your new database.
05-02-2008 , 07:48 PM
Newbie question:

Trying to convert my old PT2 Databases. If I do not have all my saved hand histories how can I get my PT2 stuff over to PT3?

      
m