limp fold problem

[bugno84]

Hello, I've copied the stat limp-fold from the topic in How to...
Sometimes happens that this stat is not correct.
the stat is:
cnt_p_limp_fold: sum( if[ tourney_holdem_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF', 1, 0 ] )
cnt_p_limp_face_raise: sum( if[tourney_holdem_hand_player_statistics.flg_p_limp AND tourney_holdem_hand_player_statistics.flg_p_face_raise, 1, 0] )

Limp-Fold: cnt_p_limp_fold / cnt_p_limp_face_raise

I've seen these problems:

-when there is a raise but without the limp the count of limp+face raise increase
-when I first raise the count also increase
-when I face to a reraise the count of limp+face raise increase

I tried to modify to:

cnt_p_limp_face_raise: sum( if[tourney_holdem_hand_player_statistics.flg_p_limp AND tourney_holdem_hand_player_statistics.flg_p_face_raise AND (NOT tourney_holdem_hand_player_statistics.flg_p_first_raise, 1, 0] )

but the problem is still there.

Could you help me?

[kraada]

That sounds like a different problem - we believe it has something to do with custom statistics during the incremental cache update, so we added extra logging in this release.

Please open your C:\Program Files (x86)\PokerTracker 3\Data\Config\PokerTracker.cfg file, and under the [General] section, add the following: LogCacheUpdateQueries=Y

After you do that, restart PT3. Then go into Database > Housekeeping and Rebuild Cache (note: this is different than Update Cache and is only available in Beta 30.9). Once that's done, your stats will be repaired. The next time you notice this happening, send us the PokerTracker.log file.

[bugno84]

it seems that the problem is still there... (after the change in config file and rebuild)

[kraada]

Then please report the problem so that we can investigate further - those stats should be working as you would expect.