Custom stats not working anymore

[none888]

Hi,
I purchased today PT4, installed it and updated database and my custom stats not working anymore.
I think the problem is with columns as when I thy validate it shows: The statemant is not valid in sql.

Before it worked fine.
Here is columns I was using for custom stats.

Code: Select all

sum(if[tourney_hand_player_statistics.id_hand>0 AND lookup_positions.flg_sb AND (if[tourney_hand_summary.amt_p_effective_stack > 500, 1000 - tourney_hand_summary.amt_p_effective_stack, tourney_hand_summary.amt_p_effective_stack] / tourney_blinds.amt_bb) >= 9 AND (if[tourney_hand_summary.amt_p_effective_stack > 500, 1000 - tourney_hand_summary.amt_p_effective_stack, tourney_hand_summary.amt_p_effective_stack] / tourney_blinds.amt_bb) < 13, 1, 0])

and

Code: Select all

sum(if[tourney_hand_player_statistics.cnt_p_raise > 0 AND lookup_positions.flg_sb AND (if[tourney_hand_summary.amt_p_effective_stack > 500, 1000 - tourney_hand_summary.amt_p_effective_stack, tourney_hand_summary.amt_p_effective_stack] / tourney_blinds.amt_bb) >= 9 AND (if[tourney_hand_summary.amt_p_effective_stack > 500, 1000 - tourney_hand_summary.amt_p_effective_stack, tourney_hand_summary.amt_p_effective_stack] / tourney_blinds.amt_bb) < 13, 1, 0])

and stat

Code: Select all

(cnt_prf_9_12 / cnt_hands_sb_9_12) * 100

It shows preflop raise 9-12bb deep, so where could be the problem?

[kraada]

amt_p_effective_stack has moved - it is now in tourney_hand_player_statistics (and no longer in tourney_hand_summary). Changing that should get things working for you.

[none888]

ok so I replaced but still not working also Im now getting valid expression.
Here is example:

Code: Select all

sum(if[tourney_hand_player_statistics.cnt_p_raise > 0 AND lookup_positions.flg_sb AND (if[tourney_hand_player_statistics.amt_p_effective_stack > 500, 1000 - tourney_hand_player_statistics.amt_p_effective_stack, tourney_hand_player_statistics.amt_p_effective_stack] / tourney_blinds.amt_bb) >= 9 AND (if[tourney_hand_player_statistics.amt_p_effective_stack > 500, 1000 - tourney_hand_player_statistics.amt_p_effective_stack, tourney_hand_player_statistics.amt_p_effective_stack] / tourney_blinds.amt_bb) < 13, 1, 0])

[kraada]

That validates for me as well. What is it doing when you use it?

[none888]

That above should count hands opponent raises in sb at 9-12bb effective stacks and other column should counts hand at that depth, so I get raise % at 9-12bb eff stacks.

also i think here is this new statemant in red:

[kraada]

The lack of detailed descriptions and categories just means you haven't filled that data on the Details page for the stat. The stat should still work fine even without a description or categories.

[none888]

Today started playing and it working now, I guess restart was needed.
Thanks