Open Side Menu Go to the Top
Register
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread

07-10-2012 , 04:06 AM
Im assuming there is no way to do this, but I'm gonna ask anyway.

I can set up my HUD so that it shows HU stats when HU, 3 handed stats when 3 handed, etc.

But I'm wondering if there is a way for the HUD to show 3 handed stats when 3 handed but also allow me to revert to the 6 handed stats if I want to (maybe something similar to switching between session and lifetime stats?)
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-10-2012 , 05:18 AM
I scanned the last couple of pages but couldn't see anything that was relevant so apologies if it's been asked already, but;

I imported HEM database into PT4 and it appeared to have missed (what I suspected was) a fair few hands, is this common?

I then exported all my HEM HH into a folder and tried importing the files from that folder, however it never gets right the way through without crashing.. I think approx 2.2mil hands. Is there a solution to this?

Cheers
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-10-2012 , 08:01 AM
Please add in replayer possibility to display stacks, bets and pots in big blinds
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-10-2012 , 08:54 AM
Quote:
Originally Posted by PokerTracker
Custom stats should work fine directly on the table, although if you have a large database they will update a little slower than the built-in stats.

--WhiteRider
Ok, will try it out! Thank you!
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-10-2012 , 09:06 AM
Quote:
Originally Posted by PokerTracker
Sounds like you did not update your database when you were asked to by the warning message. To be safe:

1) Restart your computer
2) Start PT4
3) When the Update Database dialog appears, click ok to update your database

when this is complete, lets do some basic maintenance just to be safe

1) From the Database Menu select Database Management
2) Click Housekeeping, Select Vacuum & Analyze
3) When this is complete, click Housekeeping and select Reindex
4) Finally click Rebuild Cache

Whatever caused this issue should now be solved, and your database should be in great working order once again!

- TT
Hi TT,

When updating the database, the following message popped up:

Error updating database: PokerTracker 4 Database
Error:
Unable to execute query: ALTER TABLE cash_hand_summary DROP CONSTRAINT cash_hand_summary_primary_key;
ALTER TABLE cash_hand_summary ADD CONSTRAINT cash_hand_summary_primary_key PRIMARY KEY(id_hand, id_limit);
ALTER TABLE cash_hand_summary DROP CONSTRAINT "ohs-unique_hand_no";
ALTER TABLE cash_hand_summary ADD CONSTRAINT "ohs-unique_hand_no" UNIQUE(hand_no, id_site);
DROP INDEX "ohs:idx3-hand_no";
CREATE INDEX "chs:idx3-id_winner" ON cash_hand_summary USING btree (id_winner);
DROP INDEX "chps:idx4-id_limit";
CREATE INDEX "chps:idx4-id_limit" ON cash_hand_player_statistics USING btree (id_limit);
ALTER TABLE cash_hand_player_statistics CLUSTER ON "chps:idx2-id_player";
ALTER TABLE cash_table_session_summary CLUSTER ON cash_table_session_summary_primary_key;
DROP INDEX "chps:idx8-date_played_utc"
; Reason: Fatal Error (ERROR: out of memory DETAIL: Failed on request of size 268435456. )

What´s going on and what can I do?

Thanks,

Ben

EDIT:

Also, I just tried to do housekeeping / vaccum and analyze, and I now got this message:

Unable to execute query: VACUUM ANALYZE;; Reason: Fatal Error (ERROR: out of memory DETAIL: Failed on request of size 536870910. )


Last edited by boywonder; 07-10-2012 at 09:32 AM.
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-10-2012 , 11:37 AM
Quote:
Originally Posted by boywonder
Hi TT,

When updating the database, the following message popped up:

Error updating database: PokerTracker 4 Database
Error:
Unable to execute query: ALTER TABLE cash_hand_summary DROP CONSTRAINT cash_hand_summary_primary_key;
ALTER TABLE cash_hand_summary ADD CONSTRAINT cash_hand_summary_primary_key PRIMARY KEY(id_hand, id_limit);
ALTER TABLE cash_hand_summary DROP CONSTRAINT "ohs-unique_hand_no";
ALTER TABLE cash_hand_summary ADD CONSTRAINT "ohs-unique_hand_no" UNIQUE(hand_no, id_site);
DROP INDEX "ohs:idx3-hand_no";
CREATE INDEX "chs:idx3-id_winner" ON cash_hand_summary USING btree (id_winner);
DROP INDEX "chps:idx4-id_limit";
CREATE INDEX "chps:idx4-id_limit" ON cash_hand_player_statistics USING btree (id_limit);
ALTER TABLE cash_hand_player_statistics CLUSTER ON "chps:idx2-id_player";
ALTER TABLE cash_table_session_summary CLUSTER ON cash_table_session_summary_primary_key;
DROP INDEX "chps:idx8-date_played_utc"
; Reason: Fatal Error (ERROR: out of memory DETAIL: Failed on request of size 268435456. )

What´s going on and what can I do?

Thanks,

Ben

EDIT:

Also, I just tried to do housekeeping / vaccum and analyze, and I now got this message:

Unable to execute query: VACUUM ANALYZE;; Reason: Fatal Error (ERROR: out of memory DETAIL: Failed on request of size 536870910. )

Please contact us via our support system, we will need to work with you directly to solve your issue, it is unique to your system. You can follow the instructions in this link to contact our support team, we will need to see your logs - and one of our support staff members may ask to see your Postgres logs as well.

Good luck!

- TT
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-10-2012 , 11:45 AM
Quote:
Originally Posted by eggegg
I scanned the last couple of pages but couldn't see anything that was relevant so apologies if it's been asked already, but;

I imported HEM database into PT4 and it appeared to have missed (what I suspected was) a fair few hands, is this common?

I then exported all my HEM HH into a folder and tried importing the files from that folder, however it never gets right the way through without crashing.. I think approx 2.2mil hands. Is there a solution to this?

Cheers
PokerTracker cannot import malformed hands, this is by design to assure your database contains accurate data. HEM's import rules are not as strict as ours, therefore in the event a hand was imported that does not conform to standards, then the hand is not imported. The source of the problem tends to be the card room itself, so if you were importing hands where the card room had a period of bad data, this could be the cause. For example, we still see malformed pot sizes from Merge quite frequently, they are aware of this but a fix has not been incorporated by Merge yet. We fix these issues during the import stage whenever we possibly can.

We can help you determine this if you send us the logs from the import, along with the problem hands exported from HEM - if we can find a work around to salvage the hand history, we will add it into the PT4 import code. Often times the error is in something basic that we can fix like improper pot size, an incomplete hand, or a phantom blind that we can solve if we know about the issue.

You can follow the instructions in this link to contact our support team, we would be happy to help!


- TT
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-10-2012 , 11:50 AM
Quote:
Originally Posted by Adriance
Please add in replayer possibility to display stacks, bets and pots in big blinds
This is in our list of requests for future consideration, thank you for your input!

- TT
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-10-2012 , 11:56 AM
Quote:
Originally Posted by skraper
Im assuming there is no way to do this, but I'm gonna ask anyway.

I can set up my HUD so that it shows HU stats when HU, 3 handed stats when 3 handed, etc.

But I'm wondering if there is a way for the HUD to show 3 handed stats when 3 handed but also allow me to revert to the 6 handed stats if I want to (maybe something similar to switching between session and lifetime stats?)
In PT4 we automate the selection of HUD profiles by using the number of seats available at the table. We do not have the ability to do this based on the number of players at the table, there we also do not have the ability to change the HUD mid-session based on the number of players currently seated.

The exception to this rule would be on the rare remaining sites like iPoker where the number of seats available are not disclosed in the hand histories or in the table name. Most other sites have addressed this issue already, but when playing on iPoker you must use the "Treat Table As X Max" menu from the HUD to properly place seats in the HUD automatically.


You can however set up numerous HUD profiles which you can manually switch mid game, it is not automated but we have many players who use this method successfully - including myself.

- TT
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-10-2012 , 06:22 PM
Quote:
Originally Posted by PokerTracker
In PT4 we automate the selection of HUD profiles by using the number of seats available at the table. We do not have the ability to do this based on the number of players at the table, there we also do not have the ability to change the HUD mid-session based on the number of players currently seated.

The exception to this rule would be on the rare remaining sites like iPoker where the number of seats available are not disclosed in the hand histories or in the table name. Most other sites have addressed this issue already, but when playing on iPoker you must use the "Treat Table As X Max" menu from the HUD to properly place seats in the HUD automatically.


You can however set up numerous HUD profiles which you can manually switch mid game, it is not automated but we have many players who use this method successfully - including myself.

- TT
I'm not talking about changing the HUD profile. I do change HUD profiles for different situations. But I'm talking about the stat filtering.

In 'Edit HUD Options' you can edit the "Number of Players Filter". This allows you, when only 3 players are being dealt in, to only see stats from 3 handed play, should you set the filters that way.

Is there a way, to change this filter on the fly, in game?

I will illustrate an example of a scenario where it would be useful.

We are at a 6max table, but currently there are only 2 villains sitting with us. We have the "Number of Players Filtered" set to show 3 handed stats only when 3 handed. Villain A we have extensive history with including several hundred 3 handed hands so his stats are somewhat helpful. However, Villain B we have never played with 3 handed, but we do have a few hundred hands of 6 handed play with him. We could then switch the filter for Villain B to show us his stats from 6 handed play. While these stats wouldn't be accurate for 3 handed play, they would give some information on his tendencies and we could then extrapolate how he might change his play for 3 handed. But if we can only view 3 handed play, his stats will be entirely useless for several dozen hands.
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-10-2012 , 10:11 PM
Quote:
Originally Posted by skraper
I'm not talking about changing the HUD profile. I do change HUD profiles for different situations. But I'm talking about the stat filtering.

In 'Edit HUD Options' you can edit the "Number of Players Filter". This allows you, when only 3 players are being dealt in, to only see stats from 3 handed play, should you set the filters that way.

Is there a way, to change this filter on the fly, in game?

I will illustrate an example of a scenario where it would be useful.

We are at a 6max table, but currently there are only 2 villains sitting with us. We have the "Number of Players Filtered" set to show 3 handed stats only when 3 handed. Villain A we have extensive history with including several hundred 3 handed hands so his stats are somewhat helpful. However, Villain B we have never played with 3 handed, but we do have a few hundred hands of 6 handed play with him. We could then switch the filter for Villain B to show us his stats from 6 handed play. While these stats wouldn't be accurate for 3 handed play, they would give some information on his tendencies and we could then extrapolate how he might change his play for 3 handed. But if we can only view 3 handed play, his stats will be entirely useless for several dozen hands.
I see, yes I misunderstood you, thanks for the clarification.

PokerTracker 4 cannot change player count filters mid-way at the table, you must stop import, change the HUD filter, then restart import. But there is a solution that with a little planning, you might be able to use.

Take a look at the example below, notice that the ranges cross? The filter works from the top down, so PT4 looks to see if it can fill the 7 to 10 player range, if so then it stops there and ignores the filters below - if not, then the HUD filtering subsystem goes to the layer below to see if it can meet these requirements.

Now I know this doesn't represent the hand count issue you brought up, but it is a partial solution. Send us a PM if you would like to discuss a filtering strategy using this method that works, we cannot deliver what you asked for - but we can come close by meeting you part-way. I hope this compromise works!



- TT
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-10-2012 , 11:09 PM
Bug Report: Unable to restore database from backup via "Database Management -> Restore" interface to remote server, disk space check fails returning 0MB free and Restore is aborted automatically.

edit: minor PT3 bug report: just did the same with PT3, it asks if I want to continue anyway. but still fails to do the restore. seems it searches for "createdb.exe" hardcoded to c: I pointed it to the right location but then it failed again. The database was created just fine in an earlier step though. Trying to restore from the .backup file just gives a "file not found" error.

Last edited by _dave_; 07-10-2012 at 11:22 PM.
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-10-2012 , 11:45 PM
Quote:
Originally Posted by _dave_
Bug Report: Unable to restore database from backup via "Database Management -> Restore" interface to remote server, disk space check fails returning 0MB free and Restore is aborted automatically.

edit: minor PT3 bug report: just did the same with PT3, it asks if I want to continue anyway. but still fails to do the restore. seems it searches for "createdb.exe" hardcoded to c: I pointed it to the right location but then it failed again. The database was created just fine in an earlier step though. Trying to restore from the .backup file just gives a "file not found" error.
We do not support backup and restore of your database to remote servers unless you also have Postgres installed on both machines, this is because Postgres itself requires the pg_dump,exe to be installed on both machines. We have a Guide which provides solutions, you can either use the Postgres command line or the PGAdmin tool provided by Postgres - but you may need to do this from the server machine because Postgres does not support remote backup and restore unless the pg_dump.exe executable is available.

I cannot post the PT4 guide right now due to the location I am at, but here is a FAQ provided by Postgres for SQL server version 8.4 - http://www.postgresql.org/docs/8.4/s...pp-pgdump.html

if you need help, please contact our support team by submitting a support ticket, we have experience with helping users in a similar situation. It has become pretty rare, but there are still some users who have to manually backup the database due to having the SQL server on a different desktop - in fact I am one of those people because I run PT4 in a Windows virtual machine on a Mac OS X desktop,

For those of you who are wondering, I use Parallels on an iMac with 16 Gigs of ram with the Postgres SQL server manually installed in the OS X host . The VM has 2 gigs of ram and 3 CPUs assigned to it, I did not install Postgres on the VM. PokerTracker has been manually configured to point to the IP address of the OS X server host - this setup is virtually flawless for me, the only downside is that I must manually backup the databases using PG Admin inside of the OS X host.

- TT
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-11-2012 , 01:13 AM
Fair enough, tbh I didn't remember PT3 / 4 doesn't do remote backup/restore, since it looks like it does.

I was trying to recover data for another person who has only backups made from all three of PT3, PT4 and PT3Mac. PGAdmin didn't like the backup files created by PT for some reason, I hoped they were fine since they were .backup files inside the zips, but thankfully it is at least plain text so in the end I just did it with command line psql, and that went all well.
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-11-2012 , 05:29 AM
how can i see how many bountys in a s&g i have won?
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-11-2012 , 01:07 PM
Quote:
Originally Posted by manndl
how can i see how many bountys in a s&g i have won?
found it.
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-11-2012 , 01:20 PM
Quote:
Originally Posted by manndl
how can i see how many bountys in a s&g i have won?
The Overview: By Tournaments Advanced Report includes bounties by default, or you can add this stat to any tournament game report by right clicking the report, then selecting Configure Report. If you want to filter specifically to SNGs only, then use the Single Table Tournament simple filter on the right hand side.

- TT

Last edited by PokerTracker; 07-11-2012 at 01:21 PM. Reason: just noticed you found it - this text was written a while ago but I forgot to click post
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-11-2012 , 01:47 PM
I've been using the PT4 beta for several months now, frankly because I was so fed up with the HEM2 commercial release to which I had upgraded. My experience of PT4 was so good that I took up the offer of buying PT3 in May, by virtue of which I could get an equivalent
PT4 version free on release.

So, being invited today to purchase the commercial release on the PT4 community page today, I see that anyone who bought PT3 after 10th June will be getting a free upgrade, but people who bought before this will get a 70% discount.

Now I am no math-head, but free = 100% discount, does it not?


I would like to congratulate Pokertracker on a brilliant product and a very smooth transition to commercial release, but I trust you can clarify this issue for me?
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-11-2012 , 01:58 PM
Quote:
Originally Posted by SciMat
I've been using the PT4 beta for several months now, frankly because I was so fed up with the HEM2 commercial release to which I had upgraded. My experience of PT4 was so good that I took up the offer of buying PT3 in May, by virtue of which I could get an equivalent
PT4 version free on release.

So, being invited today to purchase the commercial release on the PT4 community page today, I see that anyone who bought PT3 after 10th June will be getting a free upgrade, but people who bought before this will get a 70% discount.

Now I am no math-head, but free = 100% discount, does it not?


I would like to congratulate Pokertracker on a brilliant product and a very smooth transition to commercial release, but I trust you can clarify this issue for me?
Anyone who purchased PokerTracker 3 after June 10th, 2011 will be getting a free upgrade to PokerTracker 4. Were you were confusing 2011 with 2012? You will need to complete the order for PokerTracker 4, but there will be no charge for the equivalent version upgrade to PT4.

Thanks for the good words, please tell your friends!
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-11-2012 , 02:01 PM
Quote:
Originally Posted by PokerTracker
Anyone who purchased PokerTracker 3 after June 10th, 2011 will be getting a free upgrade to PokerTracker 4. Were you were confusing 2011 with 2012?
eh, yea... that's right 2011... and this is... 2012.

sorry, guys.
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-11-2012 , 03:49 PM
Quote:
Originally Posted by SciMat
So, being invited today to purchase the commercial release on the PT4 community page today, I see that anyone who bought PT3 after 10th June will be getting a free upgrade, but people who bought before this will get a 70% discount.
Should everybody be getting a 70% discount? I hope 159.99 is not the discounted price.

Edit: found it when I use a internet browser and go order history.
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-11-2012 , 03:53 PM
Quote:
To apply your discount, please add the version of PokerTracker 4 you wish to purchase and proceed through checkout, the discount process will be automated for you based on the purchase date of your existing PokerTracker 3 license.
This just in from Community.

At which point should I notice the discount? I got through the process all the way to the PayPal site and didn't notice a drop in the price ($159.99 for the full version). I suppose that's not the 70% discounted price?
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-11-2012 , 04:36 PM
There appears to be a bug in our shopping cart where the upgrade discounts are not being applied. We are working on resolving this issue and will post again once fixed.

Best regards,

Derek
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-11-2012 , 04:59 PM
I apologize for the inconvenience. We have fixed the upgrade discount issue and your upgrade discounts should now be displayed in your shopping cart after immediately choosing your pre-order product. A few notes:
  1. You must pre-order through the PT4 Community page. This will allow you to keep your existing PT4 registration code so that you do not need to change it.
  2. In order to receive your upgrade discount, your PT3 purchase must be linked to your PokerTracker website account. You can confirm that your PT3 purchase is linked to your account via My Account -> My Orders. If it is not linked, you can link it from this page.
If you run into any trouble, please let us know by sending us a support message or posting here.

Best regards,

Derek
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote
07-11-2012 , 05:21 PM
Enet did an update and HUDs don't work anymore. Could you also do a preferred seating for enet?
PokerTracker 4 for Windows & Mac OS X - 2+2 Support Thread Quote

      
m