flg_f_cbet possible bug?

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

flg_f_cbet possible bug?

Postby SoundMan » Wed Feb 06, 2008 11:09 am

I'm trying to to get players cbet percentage.
This is the query I run:
[codezr9]SUM(case when (hhps.flg_f_cbet) then 1 else 0 end) || '/' || SUM(case when (hhps.flg_f_cbet_opp) then 1 else 0 end)[/codezr9]

hhps obviously being holdem_hand_player_statistics.

I get results like 78/12 which is clearly incorrect. Am I missing something or is this a bug?
SoundMan
 
Posts: 4
Joined: Fri Jan 25, 2008 12:17 pm

Re: flg_f_cbet possible bug?

Postby Josh » Wed Feb 06, 2008 11:54 am

What version of PT3 was used to import these hands?
Josh
Site Admin
 
Posts: 6222
Joined: Sat Dec 08, 2007 6:03 pm

Re: flg_f_cbet possible bug?

Postby SoundMan » Wed Feb 06, 2008 5:37 pm

I'm running beta 3 and I'm pretty sure I had to import my hands again after installing this beta.
Just to make sure, I decided to do create a new db and import the hands again, and now everything seems fine.
Running the query on the old db for a certain player returned a result of 135/4.
Running the query for the same player on the new db returns 135/170, which looks a whole lot better.
I guess the old db got corrupted somehow. I'm sorry to have bothered you with this. I should obviously have tried to reimport first.

Anyways, keep up the good work. I'm looking forward to the continued exploration of this great product. All these new stats has me drooling.
SoundMan
 
Posts: 4
Joined: Fri Jan 25, 2008 12:17 pm


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 5 guests