GGPoker Hands imported with incorrect time

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

GGPoker Hands imported with incorrect time

Postby cneuy3 » Tue Jan 03, 2023 4:48 am

Nothing changed on my end but when I import GGPoker hands into Pokertracker now they seem to be off now.
'
Here is an example of the hand history text in Pokertracker:

Poker Hand #TM1753468901: Tournament #72304461, Bounty Hunters Special $32.10 Hold'em No Limit - Level28(10,000/20,000) - 2023/01/02 17:14:53
Table '38' 9-max Seat #7 is the button
Seat 1: Hero (202,758 in chips)
Seat 2: 188433eb (822,893 in chips)
Seat 3: 5e310514 (180,846 in chips)
Seat 4: e5f0ee72 (705,221 in chips)
Seat 5: b199d24f (459,113 in chips)
Seat 6: 6727e438 (313,984 in chips)
Seat 7: 73e05dcd (1,185,185 in chips)
e5f0ee72: posts the ante 3,000
188433eb: posts the ante 3,000
73e05dcd: posts the ante 3,000
6727e438: posts the ante 3,000
b199d24f: posts the ante 3,000
5e310514: posts the ante 3,000
Hero: posts the ante 3,000
Hero: posts small blind 10,000
188433eb: posts big blind 20,000
*** HOLE CARDS ***
Dealt to Hero [Kc Jh]
Dealt to 188433eb
Dealt to 5e310514
Dealt to e5f0ee72
Dealt to b199d24f
Dealt to 6727e438
Dealt to 73e05dcd
5e310514: folds
e5f0ee72: folds
b199d24f: folds
6727e438: folds
73e05dcd: raises 20,000 to 40,000
Hero: raises 159,758 to 199,758 and is all-in
188433eb: raises 620,135 to 819,893 and is all-in
73e05dcd: folds
Uncalled bet (620,135) returned to 188433eb
188433eb: shows [As Ks]
Hero: shows [Kc Jh]
*** FLOP *** [Td 6h Th]
*** TURN *** [Td 6h Th] [Kh]
*** RIVER *** [Td 6h Th Kh] [7d]
*** SHOWDOWN ***
188433eb collected 460,516 from pot
*** SUMMARY ***
Total pot 460,516 | Rake 0 | Jackpot 0 | Bingo 0 | Fortune 0
Board [Td 6h Th Kh 7d]
Seat 1: Hero (small blind) showed [Kc Jh] and lost with Pair of Kings and Pair of Tens
Seat 2: 188433eb (big blind) showed [As Ks] and won (460,516) with Pair of Kings and Pair of Tens
Seat 3: 5e310514 folded before Flop
Seat 4: e5f0ee72 folded before Flop
Seat 5: b199d24f folded before Flop
Seat 6: 6727e438 folded before Flop
Seat 7: 73e05dcd (button) folded before Flop

........................................................

That is the correct time shown in this hand history text however it shows up as 2023/01/03 00:14:53 inside of pokertracker outside of what it shows in this hand history text.

This started happening a few days maybe a week ago. My timezone is UTC+7
cneuy3
 
Posts: 26
Joined: Sun Sep 16, 2012 8:01 pm

Re: GGPoker Hands imported with incorrect time

Postby Flag_Hippo » Tue Jan 03, 2023 12:54 pm

Please attach a sample of these hands to a Support Ticket along with your support bundle so we can check your logs:

Tutorial: Reporting A Problem
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: GGPoker Hands imported with incorrect time

Postby cneuy3 » Fri Jan 06, 2023 10:01 pm

They've responded to my support ticket and I'm waiting for them to produce a fix for it as it has to do with a change GGPoker made to the way they display their time in the hand history.

However I can sort of see what is happening now. GGPoker handhistories correctly show my local time now but then Pokertracker is adding +7 hours to the time in their hand history.

In My Postgreql configuration file I have a line set:

log_timezone = 'Asia/Bangkok'

This timezone is UTC+7 so is it possible that a workaround might be to remove this line or change it to UTC +0 when importing only GGPoker hands? Then changing it back to the above when I'm playing on other networks, etc.

I'm going to probably try it anyway if I don't see a response because it feels like this should work as a workaround until there is an update within pokertracker.
cneuy3
 
Posts: 26
Joined: Sun Sep 16, 2012 8:01 pm

Re: GGPoker Hands imported with incorrect time

Postby cneuy3 » Thu Jan 19, 2023 3:39 pm

So I'm still awaiting you to release and update that will fix this time discrepancy but as I posted above I have the following in the Postgresql CONF File......

log_timezone = 'Asia/Bangkok'

timezone = 'Asia/Bangkok'

I feel like since Pokertracker is importing the GGPoker hands +7 hours as the incorrect time that it's adding the 7 hours based on this setting in that file.
How would I change this to UTC time? What should I put in the ' ' instead of Asia/Bangkok?

I'm assuming if I do this correctly and then import GGPoker hands that they will import correctly and then I'll just have to change this back to 'Asia/Bangkok' post the imports so it doesn't break the time on other networks.

Am I correct in this assumption? Please clarify for me as I'd like to do this if it would work while I await the future update.

Thanks.
cneuy3
 
Posts: 26
Joined: Sun Sep 16, 2012 8:01 pm

Re: GGPoker Hands imported with incorrect time

Postby Flag_Hippo » Fri Jan 20, 2023 7:11 am

cneuy3 wrote:How would I change this to UTC time? What should I put in the ' ' instead of Asia/Bangkok?

To change the PostgreSQL timezone in the config file you can use:

Code: Select all
timezone = 'UTC'

Guide: Alter the Time Zone in postgresql.conf

List of tz database time zones
cneuy3 wrote:I'm assuming if I do this correctly and then import GGPoker hands that they will import correctly and then I'll just have to change this back to 'Asia/Bangkok' post the imports so it doesn't break the time on other networks.

Am I correct in this assumption?

Yes that should work and you would need to change things back if you are going to be importing hands from other sites. After making any changes to the postgresql.conf file you will need to either restart your PostgreSQL service manually or restart your computer for that to take effect.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: GGPoker Hands imported with incorrect time

Postby cneuy3 » Thu Feb 02, 2023 4:48 am

This hasn't really been working. Let me explain what happens when I make this change and restart and log back into PT4.

First I get a message saying the the PostgreSQL time does not match my computer's time which is fine because I made the change to 'UTC' in the PostgreSQL file.
Second I import the GGPoker hands and they import showing the correct time in the PT4 datatase; my local time.

However, do I have to just immediately get out of a pokertracker and change everything back to 'Asia/Bangkok'? Cause I'm not importing anything but I notice when I go and try to look at all the hands in my database that the other network hands now show seven hours before the GGPoker hands in the opposite direction.

I then close out PT4. Make the change in the PostgreSQL file back to 'Asia/Bangkok' and then restart my computer, log back into PT4 and now everything is the same as before with all the other networks showing the correct time and GGPoker seven hours ahead again.

Let me know what I might be doing wrong here. Thanks.
cneuy3
 
Posts: 26
Joined: Sun Sep 16, 2012 8:01 pm

Re: GGPoker Hands imported with incorrect time

Postby Flag_Hippo » Thu Feb 02, 2023 8:48 am

You are not doing anything wrong. The timezone for each hand in the database is set at import so changing PostgreSQL timezone post import will shift the times on existing hands in the direction of that change.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am


Return to PokerTracker 4

Who is online

Users browsing this forum: AdsBot [Google] and 71 guests

cron