after update to 4.11 PT4 doesn't work

[TOO2COO]

Too2Coo: From your log it looks like your cache is incomplete. Please rebuild it by going to Database -> Database Management -> Housekeeping -> Rebuild Cache.

Okie dokie thanks I will let you know how it works out

[kraada]

Thanks guys, we really appreciate you all working with us.

[ZakWray]

i keep getting this error whilst importing:

: Error: Full Tilt: Unable to import hand (#34248497933). Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: column tourney_hand_summary.amt_p_effective_stack does not exist LINE 1: ... (CASE WHEN ( tourney_blinds.amt_bb) <> 0 THEN ((tourney_ha... ^ QUERY: SELECT tourney_hand_player_statistics.id_player, tourney_hand_player_statistics.id_gametype, tourney_hand_player_statistics.id_blinds, tourney_hand_summary.cnt_players,((case when( lookup_positions.flg_sb) then 0 else (case when( lookup_positions.flg_bb) then 1 else (case when( lookup_positions.flg_ep) then 2 else

Support Ticket #152197

[kraada]

That's because tourney_hand_summary.amt_p_effective_stack is not a valid PT4 column at this point in time. You'll need to go through your custom columns in Configure -> Statistics -> T -> Columns and locate any instances of "tourney_hand_summary.amt_p_effective_stack" and replace them with "tourney_hand_player_statistics.amt_p_effective_stack" and then things will work properly.

[ZakWray]

That's because tourney_hand_summary.amt_p_effective_stack is not a valid PT4 column at this point in time. You'll need to go through your custom columns in Configure -> Statistics -> T -> Columns and locate any instances of "tourney_hand_summary.amt_p_effective_stack" and replace them with "tourney_hand_player_statistics.amt_p_effective_stack" and then things will work properly.

i dont know how to do that

[kraada]

Click Configure -> Statistics. On the bar at the top change to tournaments (T) and Columns. At the bottom left change the drop down box to Custom Columns so you see custom columns only (they'll be blue). Click on each one. You want to look for the text:
tourney_hand_summary.amt_p_effective_stack

each time you see it replace it with:
tourney_hand_player_statistics.amt_p_effective_stack

and save the column. Once you've gone through them all, rebuild the cache and you should be good to go.

[ZakWray]

That's because tourney_hand_summary.amt_p_effective_stack is not a valid PT4 column at this point in time. You'll need to go through your custom columns in Configure -> Statistics -> T -> Columns and locate any instances of "tourney_hand_summary.amt_p_effective_stack" and replace them with "tourney_hand_player_statistics.amt_p_effective_stack" and then things will work properly.

i dont know how to do that

in fact, i got a buddy to help me, and now it complains of something else (lolz?)

Error: PokerStars: Unable to import hand (#116458457133). Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: column "cnt_p_2bet_def_opp_vs_btn_open" does not exist LINE 1: ...t_def_opp::integer,cnt_p_2bet_def_opp_vs_btn_open=cnt_p_2bet... ^ QUERY: UPDATE tourney_cache SET amt_bb_won=amt_bb_won+playerdata.amt_bb_won::numeric(14,2),amt_blind=amt_blind+playerdata.amt_blind::numeric(14,2),amt_chips_won=amt_chips_won+playerdata.amt_chips_won::numeric(14,2),amt_expected_bb_won=amt_expected_bb_won+playerdata.amt_expected_bb_won::numeric(14,2),amt_expected_won=amt_expected_won+playerdata.amt_expected_won::numeric(14,2),amt_r_call=amt_r_call+playerdata.amt_r_call::numeric(14,2),amt_r_call_won=amt_r_call_won+playerdata.amt_r_call_won::numeric(14,2),cnt_blind=cnt_blind+playerdata.cnt_blind::integer,cnt_f_2bet_def_action_call=cnt_f_2bet_def_action_call+playerdata.cnt_f_2bet_def_action_call::integer,cnt_f_2bet_def_action_fold=cnt_f_2bet_def_action_fold+playerdata.cnt_f_2bet_def_action_fold::integer,cnt_f_3bet=cnt_f_3bet+playerdata.cnt_f_3bet::integer,cnt_f_3bet_def_action_call=cnt_f_3bet_def_action_call+playerdata.cnt_f_3bet_def_action_call::integer,cnt_f_3bet_def_action_fold=cnt_f_3bet_def_action_fold+playerdata.cnt_f_3bet_def_action_fold::integer,cnt_f_3bet_def_opp=cnt_f_3bet_def_opp+playerdata.cnt_f_3bet_def_opp::integer,cnt_f_3bet_opp=cnt_f_3bet_opp+playerdata.cnt_f_3bet_opp::integer,cnt_f_4bet=cnt_f_4bet+playerdata.cnt_f_4bet::integer,cnt_f_4bet_def_action_call=cnt_f_4bet_def_action_call+playerdata.cnt_f_4bet_def_action_call::integer,cnt_f_4bet_def_action_fold=cnt_f_4bet_def_action_fold+playerdata.cnt_f_4bet_def_action_fold::integer,cnt_f_4bet_def_opp=cnt_f_4bet_def_opp+playerdata.cnt_f_4bet_def_opp::integer,cnt_f_4bet_opp=cnt_f_4bet_opp+playerdata.cnt_f_4bet_opp::integer,cnt_f_allin=cnt_f_allin+playerdata.cnt_f_allin::integer,cnt_f_allin_valid=cnt_f_allin_valid+playerdata.cnt_f_allin_valid::integer,cnt_f_bet=cnt_f_bet+playerdata.cnt_f_bet::integer,cnt_f_bet_def_action_call=cnt_f_bet_def_action_call+playerdata.cnt_f_bet_def_action_call::integer,cnt_f_bet_def_action_fold=cnt_f_bet_def_action_fold+playerdata.cnt_f_bet_def_action_fold::integer,cnt_f_bet_def_action_raise=cnt_f_bet_def_action_raise+playerdata.cnt_f_bet_def_action_raise::integer,cnt_f_bet_def_opp=cnt_f_bet_def_opp+playerdata.cnt_f_bet_def_opp::integer,cnt_f_bet_limp_pot=cnt_f_bet_limp_pot+playerdata.cnt_f_bet_limp_pot::integer,cnt_f_call=cnt_f_call+playerdata.cnt_f_call::integer,cnt_f_cbet=cnt_f_cbet+playerdata.cnt_f_cbet::integer,cnt_f_cbet_3bet_pot=cnt_f_cbet_3bet_pot+playerdata.cnt_f_cbet_3bet_pot::integer,cnt_f_cbet_def_action_call=cnt_f_cbet_def_action_call+playerdata.cnt_f_cbet_def_action_call::integer,cnt_f_cbet_def_action_call_in_pos=cnt_f_cbet_def_action_call_in_pos+playerdata.cnt_f_cbet_def_action_call_in_pos::integer,cnt_f_cbet_def_action_call_out_of_pos=cnt_f_cbet_def_action_call_out_of_pos+playerdata.cnt_f_cbet_def_action_call_out_of_pos::integer,cnt_f_cbet_def_action_fold=cnt_f_cbet_def_action_fold+playerdata.cnt_f_cbet_def_action_fold::integer,cnt_f_cbet_def_action_fold_in_pos=cnt_f_cbet_def_action_fold_in_pos+playerdata.cnt_f_cbet_def_action_fold_in_pos::integer,cnt_f_cbet_def_action_fold_out_of_pos=cnt_f_cbet_def_action_fold_out_of_pos+playerdata.cnt_f_cbet_def_action_fold_out_of_pos::integer,cnt_f_cbet_def_action_raise=cnt_f_cbet_def_action_raise+playerdata.cnt_f_cbet_def_action_raise::integer,cnt_f_cbet_def_action_raise_in_pos=cnt_f_cbet_def_action_raise_in_pos+playerdata.cnt_f_cbet_def_action_raise_in_pos::integer,cnt_f_cbet_def_action_raise_out_of_pos=cnt_f_cbet_def_action_raise_out_of_pos+playerdata.cnt_f_cbet_def_action_raise_out_of_pos::integer,cnt_f_cbet_def_opp=cnt_f_cbet_def_opp+playerdata.cnt_f_cbet_def_opp::integer,cnt_f_cbet_face_raise=cnt_f_cbet_face_raise+playerdata.cnt_f_cbet_face_raise::integer,cnt_f_cbet_face_raise_3bet_pot=cnt_f_cbet_face_raise_3bet_pot+playerdata.cnt_f_cbet_face_raise_3bet_pot::integer,cnt_f_cbet_fold_to_raise=cnt_f_cbet_fold_to_raise+playerdata.cnt_f_cbet_fold_to_raise::integer,cnt_f_cbet_fold_to_raise_3bet_pot=cnt_f_cbet_fold_to_raise_3bet_pot+playerdata.cnt_f_cbet_fold_to_raise_3bet_pot::integer,cnt_f_cbet_opp=cnt_f_cbet_opp+playerdata.cnt_f_cbet_opp::integer,cnt_f_cbet_opp_3bet_pot=cnt_f_cbet_opp_3bet_pot+playerdata.cnt_f_cbet_opp_3bet_pot::integer,cnt_f_cbet_success=cnt_f_cbet_success+playerdata.cnt_f_cbet_success::integer,cnt_f_check=cnt_f_check+playerdata.cnt_f_check::integer,cnt_f_check_raise=cnt_f_check_raise+playerdata.cnt_f_check_raise::integer,cnt_f_check_raise_opp=cnt_f_check_raise_opp+playerdata.cnt_f_check_raise_opp::integer,cnt_f_donk=cnt_f_donk+playerdata.cnt_f_donk::integer,cnt_f_donk_3bet_pot=cnt_f_donk_3bet_pot+playerdata.cnt_f_donk_3bet_pot::integer,cnt_f_donk_def_opp=cnt_f_donk_def_opp+playerdata.cnt_f_donk_def_opp::integer,cnt_f_donk_def_opp_3bet_pot=cnt_f_donk_def_opp_3bet_pot+playerdata.cnt_f_donk_def_opp_3bet_pot::integer,cnt_f_donk_def_opp_action_call=cnt_f_donk_def_opp_action_call+playerdata.cnt_f_donk_def_opp_action_call::integer,cnt_f_donk_def_opp_action_fold=cnt_f_donk_def_opp_action_fold+playerdata.cnt_f_donk_def_opp_action_fold::integer,cnt_f_donk_def_opp_action_fold_3bet_pot=cnt_f_donk_def_opp_action_fold_3bet_pot+playerdata.cnt_f_donk_def_opp_action_fold_3bet_pot::integer,cnt_f_donk_def_opp_action_raise=cnt_f_donk_def_opp_action_raise+playerdata.cnt_f_donk_def_opp_action_raise::integer,cnt_f_donk_def_opp_action_raise_3bet_pot=cnt_f_donk_def_opp_action_raise_3bet_pot+playerdata.cnt_f_donk_def_opp_action_raise_3bet_pot::integer,cnt_f_donk_face_raise=cnt_f_donk_face_raise+playerdata.cnt_f_donk_face_raise::integer,cnt_f_donk_fold=cnt_f_donk_fold+playerdata.cnt_f_donk_fold::integer,cnt_f_donk_opp=cnt_f_donk_opp+playerdata.cnt_f_donk_opp::integer,cnt_f_donk_opp_3bet_pot=cnt_f_donk_opp_3bet_pot+playerdata.cnt_f_donk_opp_3bet_pot::integer,cnt_f_face_xr=cnt_f_face_xr+playerdata.cnt_f_face_xr::integer,cnt_f_face_xr_call=cnt_f_face_xr_call+playerdata.cnt_f_face_xr_call::integer,cnt_f_face_xr_fold=cnt_f_face_xr_fold+playerdata.cnt_f_face_xr_fold::integer,cnt_f_face_xr_raise=cnt_f_face_xr_raise+playerdata.cnt_f_face_xr_raise::integer,cnt_f_float=cnt_f_float+playerdata.cnt_f_float::integer,cnt_f_float_3bet_pot=cnt_f_float_3bet_pot+playerdata.cnt_f_float_3bet_pot::integer,cnt_f_float_def_opp=cnt_f_float_def_opp+playerdata.cnt_f_float_def_opp::integer,cnt_f_float_def_opp_action_call=cnt_f_float_def_opp_action_call+playerdata.cnt_f_float_def_opp_action_call::integer,cnt_f_float_def_opp_action_fold=cnt_f_float_def_opp_action_fold+playerdata.cnt_f_float_def_opp_action_fold::integer,cnt_f_float_def_opp_action_raise=cnt_f_float_def_opp_action_raise+playerdata.cnt_f_float_def_opp_action_raise::integer,cnt_f_float_face_raise=cnt_f_float_face_raise+playerdata.cnt_f_float_face_raise::integer,cnt_f_float_fold=cnt_f_float_fold+playerdata.cnt_f_float_fold::integer,cnt_f_float_opp=cnt_f_float_opp+playerdata.cnt_f_float_opp::integer,cnt_f_float_opp_3bet_pot=cnt_f_float_opp_3bet_pot+playerdata.cnt_f_float_opp_3bet_pot::integer,cnt_f_fold=cnt_f_fold+playerdata.cnt_f_fold::integer,cnt_f_open_opp_limp_pot=cnt_f_open_opp_limp_pot+playerdata.cnt_f_open_opp_limp_pot::integer,cnt_f_raise=cnt_f_raise+playerdata.cnt_f_raise::integer,cnt_f_raise_def_opp=cnt_f_raise_def_opp+playerdata.cnt_f_raise_def_opp::integer,cnt_f_saw=cnt_f_saw+playerdata.cnt_f_saw::integer,cnt_f_saw_won=cnt_f_saw_won+playerdata.cnt_f_saw_won::integer,cnt_hands=cnt_hands+playerdata.cnt_hands::integer,cnt_hands_won=cnt_hands_won+playerdata.cnt_hands_won::integer,cnt_p_2bet_def_action_call=cnt_p_2bet_def_action_call+playerdata.cnt_p_2bet_def_action_call::integer,cnt_p_2bet_def_action_fold=cnt_p_2bet_def_action_fold+playerdata.cnt_p_2bet_def_action_fold::integer,cnt_p_2bet_def_opp=cnt_p_2bet_def_opp+playerdata.cnt_p_2bet_def_opp::integer,cnt_p_2bet_def_opp_vs_btn_open=cnt_p_2bet_def_opp_vs_btn_open+playerdata.cnt_p_2bet_def_opp_vs_btn_open::integer,cnt_p_2bet_def_opp_vs_co_open=cnt_p_2bet_def_opp_vs_co_open+playerdata.cnt_p_2bet_def_opp_vs_co_open::integer,cnt_p_3bet=cnt_p_3bet+playerdata.cnt_p_3bet::integer,cnt_p_3bet_def_action_call=cnt_p_3bet_def_action_call+playerdata.cnt_p_3bet_def_action_call::integer,cnt_p_3bet_def_action_call_after_2b=cnt_p_3bet_def_action_call_after_2b+playerdata.cnt_p_3bet_def_action_call_after_2b::integer,cnt_p_3bet_def_action_fold=cnt_p_3bet_def_action_fold+playerdata.cnt_p_3bet_def_action_fold::integer,cnt_p_3bet_def_action_fold_when_open_raised=cnt_p_3bet_def_action_fold_when_open_raised+playerdata.cnt_p_3bet_def_action_fold_when_open_raised::integer,cnt_p_3bet_def_action_fold_when_open_raised_ip=cnt_p_3bet_def_action_fold_when_open_raised_ip+playerdata.cnt_p_3bet_def_action_fold_when_open_raised_ip::integer,cnt_p_3bet_def_action_fold_when_open_raised_oop=cnt_p_3bet_def_action_fold_when_open_raised_oop+playerdata.cnt_p_3bet_def_action_fold_when_open_raised_oop::integer,cnt_p_3bet_def_opp=cnt_p_3bet_def_opp+playerdata.cnt_p_3bet_def_opp::integer,cnt_p_3bet_def_opp_after_2b=cnt_p_3bet_def_opp_after_2b+playerdata.cnt_p_3bet_def_opp_after_2b::integer,cnt_p_3bet_def_opp_when_open_raised=cnt_p_3bet_def_opp_when_open_raised+playerdata.cnt_p_3bet_def_opp_when_open_raised::integer,cnt_p_3bet_def_opp_when_open_raised_ip=cnt_p_3bet_def_opp_when_open_raised_ip+playerdata.cnt_p_3bet_def_opp_when_open_raised_ip::integer,cnt_p_3bet_def_opp_when_open_raised_oop=cnt_p_3bet_def_opp_when_open_raised_oop+playerdata.cnt_p_3bet_def_opp_when_open_raised_oop::integer,cnt_p_3bet_f_cbet_def_action_call=cnt_p_3bet_f_cbet_def_action_call+playerdata.cnt_p_3bet_f_cbet_def_action_call::integer,cnt_p_3bet_f_cbet_def_action_fold=cnt_p_3bet_f_cbet_def_action_fold+playerdata.cnt_p_3bet_f_cbet_def_action_fold::integer,cnt_p_3bet_f_cbet_def_action_raise=cnt_p_3bet_f_cbet_def_action_raise+playerdata.cnt_p_3bet_f_cbet_def_action_raise::integer,cnt_p_3bet_f_cbet_def_opp=cnt_p_3bet_f_cbet_def_opp+playerdata.cnt_p_3bet_f_cbet_def_opp::integer,cnt_p_3bet_opp=cnt_p_3bet_opp+playerdata.cnt_p_3bet_opp::integer,cnt_p_3bet_opp_vs_bb_2bet=cnt_p_3bet_opp_vs_bb_2bet+playerdata.cnt_p_3bet_opp_vs_bb_2bet::integer,cnt_p_3bet_opp_vs_btn_2bet=cnt_p_3bet_opp_vs_btn_2bet+playerdata.cnt_p_3bet_opp_vs_btn_2bet::integer,cnt_p_3bet_opp_vs_btn_open=cnt_p_3bet_opp_vs_btn_open+playerdata.cnt_p_3bet_opp_vs_btn_open::integer,cnt_p_3bet_opp_vs_co_2bet=cnt_p_3bet_opp_vs_co_2bet+playerdata.cnt_p_3bet_opp_vs_co_2bet::integer,cnt_p_3bet_opp_vs_co_open=cnt_p_3bet_opp_vs_co_open+playerdata.cnt_p_3bet_opp_vs_co_open::integer,cnt_p_3bet_opp_vs_ep_2bet=cnt_p_3bet_opp_vs_ep_2bet+playerdata.cnt_p_3bet_opp_vs_ep_2bet::integer,cnt_p_3bet_opp_vs_mp_2bet=cnt_p_3bet_opp_vs_mp_2bet+playerdata.cnt_p_3bet_opp_vs_mp_2bet::integer,cnt_p_3bet_opp_vs_sb_2bet=cnt_p_3bet_opp_vs_sb_2bet+playerdata.cnt_p_3bet_opp_vs_sb_2bet::integer,cnt_p_3bet_r_cbet_def_action_call=cnt_p_3bet_r_cbet_def_action_call+playerdata.cnt_p_3bet_r_cbet_def_action_call::integer,cnt_p_3bet_r_cbet_def_action_fold=cnt_p_3bet_r_cbet_def_action_fold+playerdata.cnt_p_3bet_r_cbet_def_action_fold::integer,cnt_p_3bet_r_cbet_def_action_raise=cnt_p_3bet_r_cbet_def_action_raise+playerdata.cnt_p_3bet_r_cbet_def_action_raise::integer,cnt_p_3bet_r_cbet_def_opp=cnt_p_3bet_r_cbet_def_opp+playerdata.cnt_p_3bet_r_cbet_def_opp::integer,cnt_p_3bet_success=cnt_p_3bet_success+playerdata.cnt_p_3bet_success::integer,cnt_p_3bet_t_cbet_def_action_call=cnt_p_3bet_t_cbet_def_action_call+playerdata.cnt_p_3bet_t_cbet_def_action_call::integer,cnt_p_3bet_t_cbet_def_action_fold=cnt_p_3bet_t_cbet_def_action_fold+playerdata.cnt_p_3bet_t_cbet_def_action_fold::integer,cnt_p_3bet_t_cbet_def_action_raise=cnt_p_3bet_t_cbet_def_action_raise+playerdata.cnt_p_3bet_t_cbet_def_action_raise::integer,cnt_p_3bet_t_cbet_def_opp=cnt_p_3bet_t_cbet_def_opp+playerdata.cnt_p_3bet_t_cbet_def_opp::integer,cnt_p_3bet_vs_bb_2bet=cnt_p_3bet_vs_bb_2bet+playerdata.cnt_p_3bet_vs_bb_2bet::integer,cnt_p_3bet_vs_btn_2bet=cnt_p_3bet_vs_btn_2bet+playerdata.cnt_p_3bet_vs_btn_2bet::integer,cnt_p_3bet_vs_btn_open=cnt_p_3bet_vs_btn_open+playerdata.cnt_p_3bet_vs_btn_open::integer,cnt_p_3bet_vs_co_2bet=cnt_p_3bet_vs_co_2bet+playerdata.cnt_p_3bet_vs_co_2bet::integer,cnt_p_3bet_vs_co_open=cnt_p_3bet_vs_co_open+playerdata.cnt_p_3bet_vs_co_open::integer,cnt_p_3bet_vs_ep_2bet=cnt_p_3bet_vs_ep_2bet+playerdata.cnt_p_3bet_vs_ep_2bet::integer,cnt_p_3bet_vs_mp_2bet=cnt_p_3bet_vs_mp_2bet+playerdata.cnt_p_3bet_vs_mp_2bet::integer,cnt_p_3bet_vs_sb_2bet=cnt_p_3bet_vs_sb_2bet+playerdata.cnt_p_3bet_vs_sb_2bet::integer,cnt_p_4bet=cnt_p_4bet+playerdata.cnt_p_4bet::integer,cnt_p_4bet_after_raising=cnt_p_4bet_after_raising+playerdata.cnt_p_4bet_after_raising::integer,cnt_p_4bet_def_action_call=cnt_p_4bet_def_action_call+playerdata.cnt_p_4bet_def_action_call::integer,cnt_p_4bet_def_action_fold=cnt_p_4bet_def_action_fold+playerdata.cnt_p_4bet_def_action_fold::integer,cnt_p_4bet_def_action_fold_after_3b=cnt_p_4bet_def_action_fold_after_3b+playerdata.cnt_p_4bet_def_action_fold_after_3b::integer,cnt_p_4bet_def_opp=cnt_p_4bet_def_opp+playerdata.cnt_p_4bet_def_opp::integer,cnt_p_4bet_def_opp_after_3b=cnt_p_4bet_def_opp_after_3b+playerdata.cnt_p_4bet_def_opp_after_3b::integer,cnt_p_4bet_opp=cnt_p_4bet_opp+playerdata.cnt_p_4bet_opp::integer,cnt_p_4bet_opp_when_open_raised=cnt_p_4bet_opp_when_open_raised+playerdata.cnt_p_4bet_opp_when_open_raised::integer,cnt_p_5bet=cnt_p_5bet+playerdata.cnt_p_5bet::integer,cnt_p_5bet_def_action_fold=cnt_p_5bet_def_action_fold+playerdata.cnt_p_5bet_def_action_fold::integer,cnt_p_5bet_def_opp=cnt_p_5bet_def_opp+playerdata.cnt_p_5bet_def_opp::integer,cnt_p_5bet_opp=cnt_p_5bet_opp+playerdata.cnt_p_5bet_opp::integer,cnt_p_allin=cnt_p_allin+playerdata.cnt_p_allin::integer,cnt_p_allin_valid=cnt_p_allin_valid+playerdata.cnt_p_allin_valid::integer,cnt_p_bb_v_sb_3bet=cnt_p_bb_v_sb_3bet+playerdata.cnt_p_bb_v_sb_3bet::integer,cnt_p_bb_v_sb_3bet_opp=cnt_p_bb_v_sb_3bet_opp+playerdata.cnt_p_bb_v_sb_3bet_opp::integer,cnt_p_bb_v_sb_call=cnt_p_bb_v_sb_call+playerdata.cnt_p_bb_v_sb_call::integer,cnt_p_bb_v_sb_fold=cnt_p_bb_v_sb_fold+playerdata.cnt_p_bb_v_sb_fold::integer,cnt_p_call=cnt_p_call+playerdata.cnt_p_call::integer,cnt_p_call_vs_btn_open=cnt_p_call_vs_btn_open+playerdata.cnt_p_call_vs_btn_open::integer,cnt_p_call_vs_co_open=cnt_p_call_vs_co_open+playerdata.cnt_p_call_vs_co_open::integer,cnt_p_ccall=cnt_p_ccall+playerdata.cnt_p_ccall::integer,cnt_p_ccall_3bet=cnt_p_ccall_3bet+playerdata.cnt_p_ccall_3bet::integer,cnt_p_ccall_3bet_opp=cnt_p_ccall_3bet_opp+playerdata.cnt_p_ccall_3bet_opp::integer,cnt_p_ccall_opp=cnt_p_ccall_opp+playerdata.cnt_p_ccall_opp::integer,cnt_p_facing_limpers=cnt_p_facing_limpers+playerdata.cnt_p_facing_limpers::integer,cnt_p_fold=cnt_p_fold+playerdata.cnt_p_fold::integer,cnt_p_fold_vs_btn_open=cnt_p_fold_vs_btn_open+playerdata.cnt_p_fold_vs_btn_open::integer,cnt_p_fold_vs_co_open=cnt_p_fold_vs_co_open+playerdata.cnt_p_fold_vs_co_open::integer,cnt_p_limp=cnt_p_limp+playerdata.cnt_p_limp::integer,cnt_p_limp_call=cnt_p_limp_call+playerdata.cnt_p_limp_call::integer,cnt_p_limp_faceraise=cnt_p_limp_faceraise+playerdata.cnt_p_limp_faceraise::integer,cnt_p_limp_fold=cnt_p_limp_fold+playerdata.cnt_p_limp_fold::integer,cnt_p_limp_opp=cnt_p_limp_opp+playerdata.cnt_p_limp_opp::integer,cnt_p_limp_raise=cnt_p_limp_raise+playerdata.cnt_p_limp_raise::integer,cnt_p_open_opp=cnt_p_open_opp+playerdata.cnt_p_open_opp::integer,cnt_p_open_opp_btn=cnt_p_open_opp_btn+playerdata.cnt_p_open_opp_btn::integer,cnt_p_open_opp_ep=cnt_p_open_opp_ep+playerdata.cnt_p_open_opp_ep::integer,cnt_p_raise=cnt_p_raise+playerdata.cnt_p_raise::integer,cnt_p_raise_3bet=cnt_p_raise_3bet+playerdata.cnt_p_raise_3bet::integer,cnt_p_raise_first_in=cnt_p_raise_first_in+playerdata.cnt_p_raise_first_in::integer,cnt_p_raise_limpers=cnt_p_raise_limpers+playerdata.cnt_p_raise_limpers::integer,cnt_p_rfi_btn=cnt_p_rfi_btn+playerdata.cnt_p_rfi_btn::integer,cnt_p_rfi_ep=cnt_p_rfi_ep+playerdata.cnt_p_rfi_ep::integer,cnt_p_squeeze=cnt_p_squeeze+playerdata.cnt_p_squeeze::integer,cnt_p_squeeze_def_call=cnt_p_squeeze_def_call+playerdata.cnt_p_squeeze_def_call::integer,cnt_p_squeeze_def_fold=cnt_p_squeeze_def_fold+playerdata.cnt_p_squeeze_def_fold::integer,cnt_p_squeeze_def_opp=cnt_p_squeeze_def_opp+playerdata.cnt_p_squeeze_def_opp::integer,cnt_p_squeeze_def_raise=cnt_p_squeeze_def_raise+playerdata.cnt_p_squeeze_def_raise::integer,cnt_p_squeeze_opp=cnt_p_squeeze_opp+playerdata.cnt_p_squeeze_opp::integer,cnt_pfr=cnt_pfr+playerdata.cnt_pfr::integer,cnt_pfr_opp=cnt_pfr_opp+playerdata.cnt_pfr_opp::integer,cnt_prev_callers_limp=cnt_prev_callers_limp+playerdata.cnt_prev_callers_limp::integer,cnt_r_2bet_def_action_call=cnt_r_2bet_def_action_call+playerdata.cnt_r_2bet_def_action_call::integer,cnt_r_2bet_def_action_fold=cnt_r_2bet_def_action_fold+playerdata.cnt_r_2bet_def_action_fold::integer,cnt_r_3bet=cnt_r_3bet+playerdata.cnt_r_3bet::integer,cnt_r_3bet_def_action_call=cnt_r_3bet_def_action_call+playerdata.cnt_r_3bet_def_action_call::integer,cnt_r_3bet_def_action_fold=cnt_r_3bet_def_action_fold+playerdata.cnt_r_3bet_def_action_fold::integer,cnt_r_3bet_def_opp=cnt_r_3bet_def_opp+playerdata.cnt_r_3bet_def_opp::integer,cnt_r_3bet_opp=cnt_r_3bet_opp+playerdata.cnt_r_3bet_opp::integer,cnt_r_4bet=cnt_r_4bet+playerdata.cnt_r_4bet::integer,cnt_r_4bet_def_action_call=cnt_r_4bet_def_action_call+playerdata.cnt_r_4bet_def_action_call::integer,cnt_r_4bet_def_action_fold=cnt_r_4bet_def_action_fold+playerdata.cnt_r_4bet_def_action_fold::integer,cnt_r_4bet_def_opp=cnt_r_4bet_def_opp+playerdata.cnt_r_4bet_def_opp::integer,cnt_r_4bet_opp=cnt_r_4bet_opp+playerdata.cnt_r_4bet_opp::integer,cnt_r_allin=cnt_r_allin+playerdata.cnt_r_allin::integer,cnt_r_allin_valid=cnt_r_allin_valid+playerdata.cnt_r_allin_valid::integer,cnt_r_bet=cnt_r_bet+playerdata.cnt_r_bet::integer,cnt_r_bet_def_action_call=cnt_r_bet_def_action_call+playerdata.cnt_r_bet_def_action_call::integer,cnt_r_bet_def_action_fold=cnt_r_bet_def_action_fold+playerdata.cnt_r_bet_def_action_fold::integer,cnt_r_bet_def_action_raise=cnt_r_bet_def_action_raise+playerdata.cnt_r_bet_def_action_raise::integer,cnt_r_bet_def_opp=cnt_r_bet_def_opp+playerdata.cnt_r_bet_def_opp::integer,cnt_r_call=cnt_r_call+playerdata.cnt_r_call::integer,cnt_r_call_hands=cnt_r_call_hands+playerdata.cnt_r_call_hands::integer,cnt_r_cbet=cnt_r_cbet+playerdata.cnt_r_cbet::integer,cnt_r_cbet_3bet_pot=cnt_r_cbet_3bet_pot+playerdata.cnt_r_cbet_3bet_pot::integer,cnt_r_cbet_def_action_call=cnt_r_cbet_def_action_call+playerdata.cnt_r_cbet_def_action_call::integer,cnt_r_cbet_def_action_fold=cnt_r_cbet_def_action_fold+playerdata.cnt_r_cbet_def_action_fold::integer,cnt_r_cbet_def_action_raise=cnt_r_cbet_def_action_raise+playerdata.cnt_r_cbet_def_action_raise::integer,cnt_r_cbet_def_opp=cnt_r_cbet_def_opp+playerdata.cnt_r_cbet_def_opp::integer,cnt_r_cbet_face_raise=cnt_r_cbet_face_raise+playerdata.cnt_r_cbet_face_raise::integer,cnt_r_cbet_face_raise_3bet_pot=cnt_r_cbet_face_raise_3bet_pot+playerdata.cnt_r_cbet_face_raise_3bet_pot::integer,cnt_r_cbet_fold_to_raise=cnt_r_cbet_fold_to_raise+playerdata.cnt_r_cbet_fold_to_raise::integer,cnt_r_cbet_fold_to_raise_3bet_pot=cnt_r_cbet_fold_to_raise_3bet_pot+playerdata.cnt_r_cbet_fold_to_raise_3bet_pot::integer,cnt_r_cbet_opp=cnt_r_cbet_opp+playerdata.cnt_r_cbet_opp::integer,cnt_r_cbet_opp_3bet_pot=cnt_r_cbet_opp_3bet_pot+playerdata.cnt_r_cbet_opp_3bet_pot::integer,cnt_r_cbet_success=cnt_r_cbet_success+playerdata.cnt_r_cbet_success::integer,cnt_r_check=cnt_r_check+playerdata.cnt_r_check::integer,cnt_r_check_raise=cnt_r_check_raise+playerdata.cnt_r_check_raise::integer,cnt_r_check_raise_opp=cnt_r_check_raise_opp+playerdata.cnt_r_check_raise_opp::integer,cnt_r_donk=cnt_r_donk+playerdata.cnt_r_donk::integer,cnt_r_donk_3bet_pot=cnt_r_donk_3bet_pot+playerdata.cnt_r_donk_3bet_pot::integer,cnt_r_donk_def_action_call=cnt_r_donk_def_action_call+playerdata.cnt_r_donk_def_action_call::integer,cnt_r_donk_def_action_fold=cnt_r_donk_def_action_fold+playerdata.cnt_r_donk_def_action_fold::integer,cnt_r_donk_def_action_fold_3bet_pot=cnt_r_donk_def_action_fold_3bet_pot+playerdata.cnt_r_donk_def_action_fold_3bet_pot::integer,cnt_r_donk_def_action_raise=cnt_r_donk_def_action_raise+playerdata.cnt_r_donk_def_action_raise::integer,cnt_r_donk_def_opp=cnt_r_donk_def_opp+playerdata.cnt_r_donk_def_opp::integer,cnt_r_donk_def_opp_3bet_pot=cnt_r_donk_def_opp_3bet_pot+playerdata.cnt_r_donk_def_opp_3bet_pot::integer,cnt_r_donk_face_raise=cnt_r_donk_face_raise+playerdata.cnt_r_donk_face_raise::integer,cnt_r_donk_fold=cnt_r_donk_fold+playerdata.cnt_r_donk_fold::integer,cnt_r_donk_opp=cnt_r_donk_opp+playerdata.cnt_r_donk_opp::integer,cnt_r_donk_opp_3bet_pot=cnt_r_donk_opp_3bet_pot+playerdata.cnt_r_donk_opp_3bet_pot::integer,cnt_r_face_xr=cnt_r_face_xr+playerdata.cnt_r_face_xr::integer,cnt_r_face_xr_call=cnt_r_face_xr_call+playerdata.cnt_r_face_xr_call::integer,cnt_r_face_xr_fold=cnt_r_face_xr_fold+playerdata.cnt_r_face_xr_fold::integer,cnt_r_face_xr_raise=cnt_r_face_xr_raise+playerdata.cnt_r_face_xr_raise::integer,cnt_r_float=cnt_r_float+playerdata.cnt_r_float::integer,cnt_r_float_3bet_pot=cnt_r_float_3bet_pot+playerdata.cnt_r_float_3bet_pot::integer,cnt_r_float_def_action_call=cnt_r_float_def_action_call+playerdata.cnt_r_float_def_action_call::integer,cnt_r_float_def_action_fold=cnt_r_float_def_action_fold+playerdata.cnt_r_float_def_action_fold::integer,cnt_r_float_def_action_raise=cnt_r_float_def_action_raise+playerdata.cnt_r_float_def_action_raise::integer,cnt_r_float_def_opp=cnt_r_float_def_opp+playerdata.cnt_r_float_def_opp::integer,cnt_r_float_face_raise=cnt_r_float_face_raise+playerdata.cnt_r_float_face_raise::integer,cnt_r_float_fold=cnt_r_float_fold+playerdata.cnt_r_float_fold::integer,cnt_r_float_opp=cnt_r_float_opp+playerdata.cnt_r_float_opp::integer,cnt_r_float_opp_3bet_pot=cnt_r_float_opp_3bet_pot+playerdata.cnt_r_float_opp_3bet_pot::integer,cnt_r_fold=cnt_r_fold+playerdata.cnt_r_fold::integer,cnt_r_probe=cnt_r_probe+playerdata.cnt_r_probe::integer,cnt_r_probe_3bet_pot=cnt_r_probe_3bet_pot+playerdata.cnt_r_probe_3bet_pot::integer,cnt_r_probe_def_action_call=cnt_r_probe_def_action_call+playerdata.cnt_r_probe_def_action_call::integer,cnt_r_probe_def_action_fold=cnt_r_probe_def_action_fold+playerdata.cnt_r_probe_def_action_fold::integer,cnt_r_probe_def_action_raise=cnt_r_probe_def_action_raise+playerdata.cnt_r_probe_def_action_raise::integer,cnt_r_probe_def_opp=cnt_r_probe_def_opp+playerdata.cnt_r_probe_def_opp::integer,cnt_r_probe_face_raise=cnt_r_probe_face_raise+playerdata.cnt_r_probe_face_raise::integer,cnt_r_probe_fold=cnt_r_probe_fold+playerdata.cnt_r_probe_fold::integer,cnt_r_probe_opp=cnt_r_probe_opp+playerdata.cnt_r_probe_opp::integer,cnt_r_probe_opp_3bet_pot=cnt_r_probe_opp_3bet_pot+playerdata.cnt_r_probe_opp_3bet_pot::integer,cnt_r_raise=cnt_r_raise+playerdata.cnt_r_raise::integer,cnt_r_raise_wtsd=cnt_r_raise_wtsd+playerdata.cnt_r_raise_wtsd::integer,cnt_r_raise_wtsd_won=cnt_r_raise_wtsd_won+playerdata.cnt_r_raise_wtsd_won::integer,cnt_r_saw=cnt_r_saw+playerdata.cnt_r_saw::integer,cnt_steal_3bet_def_action_fold=cnt_steal_3bet_def_action_fold+playerdata.cnt_steal_3bet_def_action_fold::integer,cnt_steal_3bet_def_opp=cnt_steal_3bet_def_opp+playerdata.cnt_steal_3bet_def_opp::integer,cnt_steal_att=cnt_steal_att+playerdata.cnt_steal_att::integer,cnt_steal_att_lp=cnt_steal_att_lp+playerdata.cnt_steal_att_lp::integer,cnt_steal_att_sb=cnt_steal_att_sb+playerdata.cnt_steal_att_sb::integer,cnt_steal_def_3bet_opp=cnt_steal_def_3bet_opp+playerdata.cnt_steal_def_3bet_opp::integer,cnt_steal_def_3bet_opp_vs_lp=cnt_steal_def_3bet_opp_vs_lp+playerdata.cnt_steal_def_3bet_opp_vs_lp::integer,cnt_steal_def_action_call=cnt_steal_def_action_call+playerdata.cnt_steal_def_action_call::integer,cnt_steal_def_action_call_vs_lp=cnt_steal_def_action_call_vs_lp+playerdata.cnt_steal_def_action_call_vs_lp::integer,cnt_steal_def_action_fold=cnt_steal_def_action_fold+playerdata.cnt_steal_def_action_fold::integer,cnt_steal_def_action_fold_vs_lp=cnt_steal_def_action_fold_vs_lp+playerdata.cnt_steal_def_action_fold_vs_lp::integer,cnt_steal_def_action_raise=cnt_steal_def_action_raise+playerdata.cnt_steal_def_action_raise::integer,cnt_steal_def_action_raise_vs_lp=cnt_steal_def_action_raise_vs_lp+playerdata.cnt_steal_def_action_raise_vs_lp::integer,cnt_steal_def_opp=cnt_steal_def_opp+playerdata.cnt_steal_def_opp::integer,cnt_steal_def_opp_vs_lp=cnt_steal_def_opp_vs_lp+playerdata.cnt_steal_def_opp_vs_lp::integer,cnt_steal_opp=cnt_steal_opp+playerdata.cnt_steal_opp::integer,cnt_steal_opp_lp=cnt_steal_opp_lp+playerdata.cnt_steal_opp_lp::integer,cnt_steal_opp_sb=cnt_steal_opp_sb+playerdata.cnt_steal_opp_sb::integer,cnt_steal_reraise_def_action_fold=cnt_steal_reraise_def_action_fold+playerdata.cnt_steal_reraise_def_action_fold::integer,cnt_steal_reraise_def_opp=cnt_steal_reraise_def_opp+playerdata.cnt_steal_reraise_def_opp::integer,cnt_steal_success=cnt_steal_success+playerdata.cnt_steal_success::integer,cnt_t_2bet_def_action_call=cnt_t_2bet_def_action_call+playerdata.cnt_t_2bet_def_action_call::integer,cnt_t_2bet_def_action_fold=cnt_t_2bet_def_action_fold+playerdata.cnt_t_2bet_def_action_fold::integer,cnt_t_3bet=cnt_t_3bet+playerdata.cnt_t_3bet::integer,cnt_t_3bet_def_action_call=cnt_t_3bet_def_action_call+playerdata.cnt_t_3bet_def_action_call::integer,cnt_t_3bet_def_action_fold=cnt_t_3bet_def_action_fold+playerdata.cnt_t_3bet_def_action_fold::integer,cnt_t_3bet_def_opp=cnt_t_3bet_def_opp+playerdata.cnt_t_3bet_def_opp::integer,cnt_t_3bet_opp=cnt_t_3bet_opp+playerdata.cnt_t_3bet_opp::integer,cnt_t_4bet=cnt_t_4bet+playerdata.cnt_t_4bet::integer,cnt_t_4bet_def_action_call=cnt_t_4bet_def_action_call+playerdata.cnt_t_4bet_def_action_call::integer,cnt_t_4bet_def_action_fold=cnt_t_4bet_def_action_fold+playerdata.cnt_t_4bet_def_action_fold::integer,cnt_t_4bet_def_opp=cnt_t_4bet_def_opp+playerdata.cnt_t_4bet_def_opp::integer,cnt_t_4bet_opp=cnt_t_4bet_opp+playerdata.cnt_t_4bet_opp::integer,cnt_t_allin=cnt_t_allin+playerdata.cnt_t_allin::integer,cnt_t_allin_showdown=cnt_t_allin_showdown+playerdata.cnt_t_allin_showdown::integer,cnt_t_allin_valid=cnt_t_allin_valid+playerdata.cnt_t_allin_valid::integer,cnt_t_bet=cnt_t_bet+playerdata.cnt_t_bet::integer,cnt_t_bet_def_action_call=cnt_t_bet_def_action_call+playerdata.cnt_t_bet_def_action_call::integer,cnt_t_bet_def_action_fold=cnt_t_bet_def_action_fold+playerdata.cnt_t_bet_def_action_fold::integer,cnt_t_bet_def_action_raise=cnt_t_bet_def_action_raise+playerdata.cnt_t_bet_def_action_raise::integer,cnt_t_bet_def_opp=cnt_t_bet_def_opp+playerdata.cnt_t_bet_def_opp::integer,cnt_t_call=cnt_t_call+playerdata.cnt_t_call::integer,cnt_t_cbet=cnt_t_cbet+playerdata.cnt_t_cbet::integer,cnt_t_cbet_3bet_pot=cnt_t_cbet_3bet_pot+playerdata.cnt_t_cbet_3bet_pot::integer,cnt_t_cbet_def_action_call=cnt_t_cbet_def_action_call+playerdata.cnt_t_cbet_def_action_call::integer,cnt_t_cbet_def_action_fold=cnt_t_cbet_def_action_fold+playerdata.cnt_t_cbet_def_action_fold::integer,cnt_t_cbet_def_action_raise=cnt_t_cbet_def_action_raise+playerdata.cnt_t_cbet_def_action_raise::integer,cnt_t_cbet_def_opp=cnt_t_cbet_def_opp+playerdata.cnt_t_cbet_def_opp::integer,cnt_t_cbet_face_raise=cnt_t_cbet_face_raise+playerdata.cnt_t_cbet_face_raise::integer,cnt_t_cbet_face_raise_3bet_pot=cnt_t_cbet_face_raise_3bet_pot+playerdata.cnt_t_cbet_face_raise_3bet_pot::integer,cnt_t_cbet_fold_to_raise=cnt_t_cbet_fold_to_raise+playerdata.cnt_t_cbet_fold_to_raise::integer,cnt_t_cbet_fold_to_raise_3bet_pot=cnt_t_cbet_fold_to_raise_3bet_pot+playerdata.cnt_t_cbet_fold_to_raise_3bet_pot::integer,cnt_t_cbet_opp=cnt_t_cbet_opp+playerdata.cnt_t_cbet_opp::integer,cnt_t_cbet_opp_3bet_pot=cnt_t_cbet_opp_3bet_pot+playerdata.cnt_t_cbet_opp_3bet_pot::integer,cnt_t_cbet_success=cnt_t_cbet_success+playerdata.cnt_t_cbet_success::integer,cnt_t_check=cnt_t_check+playerdata.cnt_t_check::integer,cnt_t_check_raise=cnt_t_check_raise+playerdata.cnt_t_check_raise::integer,cnt_t_check_raise_opp=cnt_t_check_raise_opp+playerdata.cnt_t_check_raise_opp::integer,cnt_t_donk=cnt_t_donk+playerdata.cnt_t_donk::integer,cnt_t_donk_3bet_pot=cnt_t_donk_3bet_pot+playerdata.cnt_t_donk_3bet_pot::integer,cnt_t_donk_def_action_call=cnt_t_donk_def_action_call+playerdata.cnt_t_donk_def_action_call::integer,cnt_t_donk_def_action_fold=cnt_t_donk_def_action_fold+playerdata.cnt_t_donk_def_action_fold::integer,cnt_t_donk_def_action_fold_3bet_pot=cnt_t_donk_def_action_fold_3bet_pot+playerdata.cnt_t_donk_def_action_fold_3bet_pot::integer,cnt_t_donk_def_action_raise=cnt_t_donk_def_action_raise+playerdata.cnt_t_donk_def_action_raise::integer,cnt_t_donk_def_opp=cnt_t_donk_def_opp+playerdata.cnt_t_donk_def_opp::integer,cnt_t_donk_def_opp_3bet_pot=cnt_t_donk_def_opp_3bet_pot+playerdata.cnt_t_donk_def_opp_3bet_pot::integer,cnt_t_donk_face_raise=cnt_t_donk_face_raise+playerdata.cnt_t_donk_face_raise::integer,cnt_t_donk_fold=cnt_t_donk_fold+playerdata.cnt_t_donk_fold::integer,cnt_t_donk_opp=cnt_t_donk_opp+playerdata.cnt_t_donk_opp::integer,cnt_t_donk_opp_3bet_pot=cnt_t_donk_opp_3bet_pot+playerdata.cnt_t_donk_opp_3bet_pot::integer,cnt_t_face_xr=cnt_t_face_xr+playerdata.cnt_t_face_xr::integer,cnt_t_face_xr_call=cnt_t_face_xr_call+playerdata.cnt_t_face_xr_call::integer,cnt_t_face_xr_fold=cnt_t_face_xr_fold+playerdata.cnt_t_face_xr_fold::integer,cnt_t_face_xr_raise=cnt_t_face_xr_raise+playerdata.cnt_t_face_xr_raise::integer,cnt_t_float=cnt_t_float+playerdata.cnt_t_float::integer,cnt_t_float_3bet_pot=cnt_t_float_3bet_pot+playerdata.cnt_t_float_3bet_pot::integer,cnt_t_float_def_action_call=cnt_t_float_def_action_call+playerdata.cnt_t_float_def_action_call::integer,cnt_t_float_def_action_fold=cnt_t_float_def_action_fold+playerdata.cnt_t_float_def_action_fold::integer,cnt_t_float_def_action_raise=cnt_t_float_def_action_raise+playerdata.cnt_t_float_def_action_raise::integer,cnt_t_float_def_opp=cnt_t_float_def_opp+playerdata.cnt_t_float_def_opp::integer,cnt_t_float_face_raise=cnt_t_float_face_raise+playerdata.cnt_t_float_face_raise::integer,cnt_t_float_fold=cnt_t_float_fold+playerdata.cnt_t_float_fold::integer,cnt_t_float_opp=cnt_t_float_opp+playerdata.cnt_t_float_opp::integer,cnt_t_float_opp_3bet_pot=cnt_t_float_opp_3bet_pot+playerdata.cnt_t_float_opp_3bet_pot::integer,cnt_t_fold=cnt_t_fold+playerdata.cnt_t_fold::integer,cnt_t_probe=cnt_t_probe+playerdata.cnt_t_probe::integer,cnt_t_probe_3bet_pot=cnt_t_probe_3bet_pot+playerdata.cnt_t_probe_3bet_pot::integer,cnt_t_probe_def_action_call=cnt_t_probe_def_action_call+playerdata.cnt_t_probe_def_action_call::integer,cnt_t_probe_def_action_fold=cnt_t_probe_def_action_fold+playerdata.cnt_t_probe_def_action_fold::integer,cnt_t_probe_def_action_raise=cnt_t_probe_def_action_raise+playerdata.cnt_t_probe_def_action_raise::integer,cnt_t_probe_def_opp=cnt_t_probe_def_opp+playerdata.cnt_t_probe_def_opp::integer,cnt_t_probe_face_raise=cnt_t_probe_face_raise+playerdata.cnt_t_probe_face_raise::integer,cnt_t_probe_fold=cnt_t_probe_fold+playerdata.cnt_t_probe_fold::integer,cnt_t_probe_opp=cnt_t_probe_opp+playerdata.cnt_t_probe_opp::integer,cnt_t_probe_opp_3bet_pot=cnt_t_probe_opp_3bet_pot+playerdata.cnt_t_probe_opp_3bet_pot::integer,cnt_t_raise=cnt_t_raise+playerdata.cnt_t_raise::integer,cnt_t_raise_wtsd=cnt_t_raise_wtsd+playerdata.cnt_t_raise_wtsd::integer,cnt_t_raise_wtsd_won=cnt_t_raise_wtsd_won+playerdata.cnt_t_raise_wtsd_won::integer,cnt_t_saw=cnt_t_saw+playerdata.cnt_t_saw::integer,cnt_vpip=cnt_vpip+playerdata.cnt_vpip::integer,cnt_vpip_sb=cnt_vpip_sb+playerdata.cnt_vpip_sb::integer,cnt_walks=cnt_walks+playerdata.cnt_walks::integer,cnt_won_hand=cnt_won_hand+playerdata.cnt_won_hand::integer,cnt_wtsd=cnt_wtsd+playerdata.cnt_wtsd::integer,cnt_wtsd_non_small=cnt_wtsd_non_small+playerdata.cnt_wtsd_non_small::integer,cnt_wtsd_won=cnt_wtsd_won+playerdata.cnt_wtsd_won::integer,cnt_wtsd_won_non_small=cnt_wtsd_won_non_small+playerdata.cnt_wtsd_won_non_small::integer,cnt_wtsd_won_when_r_call=cnt_wtsd_won_when_r_call+playerdata.cnt_wtsd_won_when_r_call::integer,val_equity=val_equity+playerdata.val_equity::numeric(14,2),val_f_equity=val_f_equity+playerdata.val_f_equity::numeric(14,2),val_p_equity=val_p_equity+playerdata.val_p_equity::numeric(14,2),val_r_equity=val_r_equity+playerdata.val_r_equity::numeric(14,2),val_t_equity=val_t_equity+playerdata.val_t_equity::numeric(14,2) WHERE id_player = playerdata.id_player AND id_gametype = playerdata.id_gametype AND id_blinds = playerdata.id_blinds AND cnt_players = playerdata.cnt_players AND position_type = playerdata.position_type AND flg_has_position_f = playerdata.flg_has_position_f AND flg_has_position_t = playerdata.flg_has_position_t AND flg_has_position_r = playerdata.flg_has_position_r AND date_played_year_week = playerdata.date_played_year_week CONTEXT: PL/pgSQL function "update_tourney_cache" line 25 at SQL statement )
10:38:34 pm: PokerStars: Hand Imported (#116458457133) from 912880264 1

think ill leave it at that wasted too much time already

[kraada]

It sounds like you may have some custom columns that refer directly to the column cnt_p_2bet_def_opp_vs_btn_open -- you can't refer to one column in another column; it won't work properly.

You'll need to locate the column in question and remove the reference.

[ZakWray]

It sounds like you may have some custom columns that refer directly to the column cnt_p_2bet_def_opp_vs_btn_open -- you can't refer to one column in another column; it won't work properly.

You'll need to locate the column in question and remove the reference.

appreciate that but i dont have a clue how the programming part of it works, i just play poker nothing else

[kraada]

The only other thing I can suggest is totally removing your custom stats. This is due to certain custom stats you imported and unfortunately I can't be more specific about how to fix them than that because we have no way of easily knowing which custom stats are causing the problem for you; It is easier to think of this situation as if the problem was caused by the developer of the custom stat.

To remove all custom statistics you may have click File -> Open User Data Folder and go into the Data folder and delete StatsDefinitionsCustomized.pt4. Restart PT4 and all of your custom stats will be removed and then the cache rebuild should complete. Note that this may affect your custom reports or your HUD layout as all custom stats will be removed and no longer function.