Custom Stats no longer work?

[bodhisoma]

Running v4.01.24.

I made some custom columns and stats about a month ago, created a HUD with them, everything was working as expected.

Today I went to make a new HUD using those same stats, does not work; I can add the stats but they just read -.

Opened a hand replay, switched to my original HUD, the one that worked fine previously, same thing; they no longer work.

Went back to make sure everything still exists; columns are still there and correct, stats are still there and correct.

How can I go about trouble shooting?

Thanks!

[bodhisoma]

I should add that this HUD has some (2) custom stats that DO work and four that do not work.

The stats which do work did not require custom columns.

The stats which no longer work did require custom columns.

[bodhisoma]

Meh. Looks like TT posted a reply on 2+2 confirming that some stats/cols were renamed and this likely accounts for the breakage. Will attempt to re-engineer 'em once the final non-beta release happens and bump this thread if not resolved/resolvable.

[kraada]

Everything that was there before is still there now just a few things have been relocated. The most significant recent one was moving effective stack to the cash_hand_player_statistics table from the cash_hand_summary table, so you may need to update references to that. There should be nothing that you could create before that you can't create now (we wouldn't do that to you!).

[bodhisoma]

The good news is that I was able to correct the 75 custom columns (SQL parsed correctly).

The bad news is it still doesn't work. Not sure how to proceed.

Zip up the exported HUD Profile and open a ticket?

[bodhisoma]

Maybe a trouble ticket isn't required, I can just post all the columns and stats for one blind level, see if it's obvious.

COLUMNS

cnt_f_bet_0_to_8bb
sum(if[(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 0 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 8 AND tourney_hand_player_statistics.flg_f_bet, 1, 0])

cnt_f_call_0_to_8bb
sum(if[if[tourney_hand_player_statistics.cnt_f_call > 0] AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 0, 1, 0])

cnt_f_fold_0_to_8bb
sum(if[(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 0 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 8 AND tourney_hand_player_statistics.flg_f_fold, 1, 0])

cnt_f_raise_0_to_8bb
sum(if[if[tourney_hand_player_statistics.cnt_f_raise > 0] AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 0, 1, 0])

cnt_hands_0_to_8bb
sum(if[(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 0 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 8 AND tourney_hand_player_statistics.id_hand > 0, 1, 0])

cnt_r_bet_0_to_8bb
sum(if[(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 0 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 8 AND tourney_hand_player_statistics.flg_r_bet, 1, 0])

cnt_r_call_0_to_8bb
sum(if[if[tourney_hand_player_statistics.cnt_r_call > 0] AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 0, 1, 0])

cnt_r_fold_0_to_8bb
sum(if[(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 0 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 8 AND tourney_hand_player_statistics.flg_r_fold, 1, 0])

cnt_r_raise_0_to_8bb
sum(if[if[tourney_hand_player_statistics.cnt_r_raise > 0] AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 0, 1, 0])

cnt_t_bet_0_to_8bb
sum(if[(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 0 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 8 AND tourney_hand_player_statistics.flg_t_bet, 1, 0])

cnt_t_call_0_to_8bb
sum(if[if[tourney_hand_player_statistics.cnt_t_call > 0] AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 0, 1, 0])

cnt_t_fold_0_to_8bb
sum(if[(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 0 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 8 AND tourney_hand_player_statistics.flg_t_fold, 1, 0])

cnt_t_raise_0_to_8bb
sum(if[if[tourney_hand_player_statistics.cnt_t_raise > 0] AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 0, 1, 0])

cnt_vpip_0_to_8bb
sum(if[(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 0 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 8 AND tourney_hand_player_statistics.flg_vpip, 1, 0])

cnt_walks_0_to_8bb
sum(if[(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 0 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 8 AND lookup_actions_p.action = '', 1, 0])

STATISTICS

RAFq 0 to 8bb
format_number(((((cnt_f_bet_0_to_8bb + cnt_f_raise_0_to_8bb + cnt_t_bet_0_to_8bb + cnt_t_raise_0_to_8bb + cnt_r_bet_0_to_8bb + cnt_r_raise_0_to_8bb) / (cnt_f_call_0_to_8bb + cnt_f_fold_0_to_8bb + cnt_t_call_0_to_8bb + cnt_t_fold_0_to_8bb + cnt_r_call_0_to_8bb + cnt_r_fold_0_to_8bb + cnt_f_bet_0_to_8bb + cnt_f_raise_0_to_8bb + cnt_t_bet_0_to_8bb + cnt_t_raise_0_to_8bb + cnt_r_bet_0_to_8bb + cnt_r_raise_0_to_8bb)) * 100) * ((cnt_vpip_0_to_8bb / (cnt_hands_0_to_8bb - cnt_walks_0_to_8bb)) * 100)) / 1000, 0, false, false)

[bodhisoma]

Appeared to work, now it's not. (shoots self in face).

[kraada]

After making custom stat changes restarts can sometimes be required to force stats to reload completely. When in doubt after making and saving large numbers of stat changes a restart makes good sense.