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

01-25-2008 , 03:21 AM
Quote:
Originally Posted by AllA-Vice
When i try and start this i get:

unable to create postgreSQL databas:PT3
Reason: Unable to execute query:--

**************************

Table-Holdem_hand_summary

#
id_hand bigint NOT NULL,

Then it says not null, default 0 or default the entire way down for all of the tags

any ideas anyone?
When you receive this error, please send us the PokerTracker.log file, located in your main PokerTracker 3 directory, via the PokerTracker Support system so that we can further troubleshoot the issue.

Best regards,

Derek
01-25-2008 , 03:24 AM
Quote:
Originally Posted by sublime
so this AHK HUD is what exactly?

i plan on waiting for the bug free PT3, should i not even worry about this AHK HUD in that case? will the new PAHUD have the same/better capabilities?
Dave was gracious enough to provide us with a temporary AHK HUD so that users can have a stat overlay while we work on the PT3 HUD. This is not the official HUD. The PT3 HUD will hopefully be released within the next few weeks.

Best regards,

Derek
01-25-2008 , 03:25 AM
Quote:
Originally Posted by Fat Nicky
are there eventually going to be more options to modify the database, such as:

purging specific hands/sessions
exporting hands/sessions
backing up from PT instead of havign to go into the PG Admin.

Also, I really think the Att to Steal stat needs to be fixed...there is a 12 % point difference after I imported my PT2 hands into PT3
Yes, we will have all of these features, if not more. We just have not had time to get them implemented yet.

-APerfect10
01-25-2008 , 03:42 AM
Quote:
Originally Posted by sublime
so this AHK HUD is what exactly?

i plan on waiting for the bug free PT3, should i not even worry about this AHK HUD in that case? will the new PAHUD have the same/better capabilities?

Quote:
Originally Posted by APerfect10
Dave was gracious enough to provide us with a temporary AHK HUD so that users can have a stat overlay while we work on the PT3 HUD. This is not the official HUD. The PT3 HUD will hopefully be released within the next few weeks.

Best regards,

Derek
Indeed.

It is a HUD I made with which to test the PT3 database in leu of PAHUD3. I expect PAHUD will be superior when ready.

In the meantime, if you can code SQL and read AHK, it is the most powerful extensible HUD available today by a long shot (thanks to the speed / information of the PT3 database).

If you can't code SQL or AHK - it is a workable PT3 decent HUD for Stars. (FTP & PTY support *very* soon, like < 24 hours).

dave.
01-25-2008 , 03:56 AM
after trying it again ... PT imported all of my hands and recognized the duplicates (crushed twice before it finally worked, only 100k hands)

didnt have much time to test it but ive noticed that THE HOURS PLAYED must be wrong ....

the graph is showing me 57 days played but the hours played are over 1000 ....

pt2 shows me something around 80 hours
01-25-2008 , 03:59 AM
Quote:
Originally Posted by iamonething
after trying it again ... PT imported all of my hands and recognized the duplicates (crushed twice before it finally worked, only 100k hands)

didnt have much time to test it but ive noticed that THE HOURS PLAYED must be wrong ....

the graph is showing me 57 days played but the hours played are over 1000 ....

pt2 shows me something around 80 hours
You haven't played 17+ hours a day for 57 straight days?

As you noted, something isn't right. What site are you playing on? Are the other stats matching up with PT2?

Best regards,

Derek
01-25-2008 , 04:15 AM
Is there plans for database conversion form PT2 where there is no hand history? I dont record the hand histories when I mine so ideally want to bring my stats across for the hud (once its released).

My main database seems to have converted for Stars and Party, just the FTP hands to go speeds have been good 150 h/s although its droppped as the import continued to about 110.
01-25-2008 , 04:40 AM
400K hands @ 210h/s, 0 errors
Application looks so cute...

Last edited by Herrigel; 01-25-2008 at 05:02 AM.
01-25-2008 , 04:58 AM
This looks very good so far. Great work.

I'm missing the Summary tab (wich will come soon as you said) and also the Preferences tab, so I can filter hands between dates/only view one day etc. I haven't found anywhere to do that atm.

Also, where do I set my screenname as the default ("Mine")?
01-25-2008 , 05:01 AM
Falc,

Neither of these features are not available yet in this version.
01-25-2008 , 05:02 AM
Small thing; IMO, the Import from File(s) and Import from Directories should be the same button and the choice of which to be import be in the next window.
01-25-2008 , 05:04 AM
I believe the "Preferences" you want, to filter date ranges, etc is there. It doesnt have its own tab now - its on every tab, and affects all the other tabs. General Tab > Upper Right Corner > Filters.
01-25-2008 , 05:09 AM
ok, i got my importing speed fix, from 9h/s to 46h/s
now my next question is, how to import my datamine hand to datamine database?
also, does pt3 do datamine yet?
01-25-2008 , 05:09 AM
Quote:
Originally Posted by fozzy71
I believe the "Preferences" you want, to filter date ranges, etc is there. It doesnt have its own tab now - its on every tab, and affects all the other tabs. General Tab > Upper Right Corner > Filters.
Ah yes, I found it. Thanks.
01-25-2008 , 05:12 AM
In the "Winnings" tab, if you sort by amount won, and then try to go back sorting by "day" or "month" the report will show the "wrong order".
It will put
February, 18
February, 19
February, 2
February, 21

The same with months, putting the months in alphabetical order, maybe this is desired but I think it would be good to change this.
01-25-2008 , 05:13 AM
Quote:
Originally Posted by APerfect10
Dave was gracious enough to provide us with a temporary AHK HUD so that users can have a stat overlay while we work on the PT3 HUD. This is not the official HUD. The PT3 HUD will hopefully be released within the next few weeks.

Best regards,

Derek
thx for clarification.
01-25-2008 , 05:15 AM
nm

Last edited by Herrigel; 01-25-2008 at 05:36 AM.
01-25-2008 , 05:15 AM
Hey,

I just bought HM and I almost feel like an idiot for doing it. I just started playing around with it but I was wondering if you could save me some time and answer these questions:
1. Is the HUD for this just regular PAHUD, or is it built in?
2. Is there a way to export hands?
3. Either pokertracker3.com is laggy or there are some area's that don't exist yet, I click but I go no where, whats the deal.

tyvm
01-25-2008 , 06:52 AM
fees

1) It will be built in but it's not finished yet. The hud will basically be PAHUD's successor but it will be integrated into PT3 (as an optional extra I guess but I'm not sure)

2) PT3 will definitely have it in the commercial release but the beta version doesn't seem to have that functionality yet

3) This is just the beta version and many areas is likely to have bugs. If this is a problem please wait for the commercial release out soon

... or something


In other news: I just loaded 100k hands with no errors other than the usual 'partial hand' type ones. It's pretty damn quick! I also played around in the other areas while the import was running and it worked fine. Manual Import stops after about 64,000 files in one folder, and runs much faster if your HH files are larger but fewer.

One question: What is 'Cluster on completion'
01-25-2008 , 07:09 AM
In the future will we be able to convert pt2 databases into pt3 without having the HH's??
01-25-2008 , 07:20 AM
Quote:
Originally Posted by Devilboy666
One question: What is 'Cluster on completion'
It clusters your database basically to speed it up. Recommended to do every 50-100k hands.
01-25-2008 , 07:25 AM
i get the following error when trying to install postgreaql and yes i am installing the version that comes with pt3


URL=http://img143.imageshack.us/my.php?image=screenhunter04jan250607hn1.gif

Last edited by grumpy64; 01-25-2008 at 07:26 AM. Reason: typo
01-25-2008 , 07:28 AM
Ok i'm not sure what went wrong in my above post but the error is failed to init db
01-25-2008 , 08:09 AM
getting 500 Internal Server Error trying to access the website
mirror(s) please?

edit: got it to work after refreshing for a couple of billion times
01-25-2008 , 08:34 AM
Ok so I downloaded PT3 beta w/o PostgreSQL since I already have it & PT2.
When I try to run PokerTracker 3, nothing happens. I mean, I can see it in the processes in task manager, but that's it. So.... how do I use this thing again?

      
m