Housekeeping errors

[greenrider]

Hello

I've tried to add some custom stat. When I update the cache I get errors
There were errors during the housekeeping process:
Unable to execute query: CREATE TABLE holdem_cache (id_player integer NOT NULL, id_limit integer NOT NULL, cnt_players integer NOT NULL, position_type integer, amt_bb_won numeric(11,2), amt_blind numeric(11,2), amt_mgr numeric(11,2), amt_rake numeric(11,2), amt_won numeric(11,2), amt_won_curr_conv numeric(11,2), amt_won_curr_raw numeric(11,2), cnt_bb integer, cnt_bb_steal_call integer, cnt_bb_steal_fold integer, cnt_bb_steal_raise integer, cnt_blind integer, cnt_f_3bet integer, cnt_f_3bet_def_action_call integer, cnt_f_3bet_def_action_fold integer, cnt_f_3bet_def_action_raise integer, cnt_f_3bet_def_opp integer, cnt_f_3bet_opp integer, cnt_f_4bet integer, cnt_f_4bet_def_action_call integer, cnt_f_4bet_def_action_fold integer, cnt_f_4bet_def_action_raise integer, cnt_f_4bet_def_opp integer, cnt_f_4bet_opp integer, cnt_f_bet integer, cnt_f_bet_def_action_call integer, cnt_f_bet_def_action_fold integer, cnt_f_bet_def_action_raise integer, cnt_f_bet_def_opp integer, cnt_f_bet_raise_hands integer, cnt_f_call integer, cnt_f_call_hands integer, cnt_f_cbet integer, cnt_f_cbet_def_action_call integer, cnt_f_cbet_def_action_call_in_pos integer, cnt_f_cbet_def_action_call_out_of_pos integer, cnt_f_cbet_def_action_fold integer, cnt_f_cbet_def_action_fold_in_pos integer, cnt_f_cbet_def_action_fold_out_of_pos integer, cnt_f_cbet_def_action_raise integer, cnt_f_cbet_def_action_raise_in_pos integer, cnt_f_cbet_def_action_raise_out_of_pos integer, cnt_f_cbet_def_opp integer, cnt_f_cbet_face_raise integer, cnt_f_cbet_fold_to_raise integer, cnt_f_cbet_opp integer, cnt_f_cbet_success integer, cnt_f_check integer, cnt_f_check_raise integer, cnt_f_check_raise_opp integer, cnt_f_donk integer, cnt_f_donk_def_opp integer, cnt_f_donk_def_opp_action_call integer, cnt_f_donk_def_opp_action_fold integer, cnt_f_donk_def_opp_action_raise integer, cnt_f_donk_opp integer, cnt_f_face_xr integer, cnt_f_face_xr_call integer, cnt_f_face_xr_fold integer, cnt_f_face_xr_raise integer, cnt_f_float integer, cnt_f_float_def_opp integer, cnt_f_float_def_opp_action_call integer, cnt_f_float_def_opp_action_fold integer, cnt_f_float_def_opp_action_raise integer, cnt_f_float_opp integer, cnt_f_fold integer, cnt_f_raise integer,

[greenrider]

cnt_f_raise integer, cnt_f_raise_def_action_call integer, cnt_f_raise_def_action_fold integer, cnt_f_raise_def_opp integer, cnt_f_saw integer, cnt_f_saw_won integer, cnt_f_total_actions integer, cnt_first_limp integer, cnt_fold_when_f_bet_raise integer, cnt_fold_when_f_call integer, cnt_fold_when_p_bet_raise integer, cnt_fold_when_p_call integer, cnt_fold_when_r_bet_raise integer, cnt_fold_when_r_call integer, cnt_fold_when_t_bet_raise integer, cnt_fold_when_t_call integer, cnt_hands integer, cnt_hands_raked integer, cnt_hands_with_flop integer, cnt_hands_won integer, cnt_p_3b_face_4b integer, cnt_p_3bet integer, cnt_p_3bet_def_action_call integer, cnt_p_3bet_def_action_fold integer, cnt_p_3bet_def_action_fold_when_open_raised integer, cnt_p_3bet_def_action_raise integer, cnt_p_3bet_def_opp integer, cnt_p_3bet_def_opp_when_open_raised integer, cnt_p_3bet_f_cbet_def_action_call integer, cnt_p_3bet_f_cbet_def_action_fold integer, cnt_p_3bet_f_cbet_def_action_raise integer, cnt_p_3bet_f_cbet_def_opp integer, cnt_p_3bet_fold integer, cnt_p_3bet_opp integer, cnt_p_4bet integer, cnt_p_4bet_def_action_call integer, cnt_p_4bet_def_action_fold integer, cnt_p_4bet_def_action_raise integer, cnt_p_4bet_def_opp integer, cnt_p_4bet_opp integer, cnt_p_bb_fold_to_sb integer, cnt_p_bb_fold_to_sb_opp integer, cnt_p_bb_v_sb_steal_call integer, cnt_p_bb_v_sb_steal_fold integer, cnt_p_bb_v_sb_steal_raise integer, cnt_p_bet_raise_hands integer, cnt_p_call integer, cnt_p_call_hands integer, cnt_p_ccall integer, cnt_p_ccall_opp integer, cnt_p_check integer, cnt_p_face_raise integer, cnt_p_facing_limpers integer, cnt_p_first_raise integer, cnt_p_fold integer, cnt_p_limp integer, cnt_p_limp_after_limpers_opp integer, cnt_p_limp_call integer, cnt_p_limp_faceraise integer, cnt_p_limp_fold integer, cnt_p_limp_opp integer, cnt_p_limp_raise integer, cnt_p_open_opp integer, cnt_p_pfr_call integer, cnt_p_pfr_call_opp integer, cnt_p_raise integer, cnt_p_raise_first_in integer, cnt_p_raise_limpers integer, cnt_p_squeeze integer, cnt_p_squeeze_def_call integer, cnt_p_squeeze_def_fold integer, cnt_p_squeeze_def_opp integer, cnt_p_squeeze_def_raise integer, cnt_p_squeeze_opp integer, cnt_p_total_actions integer, cnt_pfr integer, cnt_pfr_f_bet integer, cnt_pfr_f_call integer, cnt_pfr_f_check integer, cnt_pfr_f_checkraise integer, cnt_pfr_f_fold integer, cnt_pfr_f_none integer, cnt_pfr_f_raise integer, cnt_prev_callers_limp integer, cnt_prev_callers_raise integer, cnt_r_3bet integer, cnt_r_3bet_def_action_call integer, cnt_r_3bet_def_action_fold integer, cnt_r_3bet_def_action_raise integer, cnt_r_3bet_def_opp integer, cnt_r_3bet_opp integer, cnt_r_4bet integer, cnt_r_4bet_def_action_call integer, cnt_r_4bet_def_action_fold integer, cnt_r_4bet_def_action_raise integer, cnt_r_4bet_def_opp integer, cnt_r_4bet_opp integer, cnt_r_bet integer, cnt_r_bet_def_action_call integer, cnt_r_bet_def_action_fold integer, cnt_r_bet_def_action_raise integer, cnt_r_bet_def_opp integer, cnt_r_bet_raise_hands integer, cnt_r_call integer, cnt_r_call_hands integer, cnt_r_cbet integer, cnt_r_cbet_def_action_call integer, cnt_r_cbet_def_action_fold integer, cnt_r_cbet_def_action_raise integer, cnt_r_cbet_def_opp integer, cnt_r_cbet_face_raise integer, cnt_r_cbet_fold_to_raise integer, cnt_r_cbet_opp integer, cnt_r_check integer, cnt_r_check_raise integer, cnt_r_check_raise_opp integer, cnt_r_donk integer, cnt_r_donk_def_action_call integer, cnt_r_donk_def_action_fold integer, cnt_r_donk_def_action_raise integer, cnt_r_donk_def_opp integer, cnt_r_donk_opp integer, cnt_r_face_xr integer, cnt_r_face_xr_call integer, cnt_r_face_xr_fold integer, cnt_r_face_xr_raise integer, cnt_r_float integer, cnt_r_float_def_action_call integer, cnt_r_float_def_action_fold integer, cnt_r_float_def_action_raise integer, cnt_r_float_def_opp integer, cnt_r_float_opp integer, cnt_r_fold integer, cnt_r_probe integer, cnt_r_probe_opp integer, cnt_r_raise integer, cnt_r_raise_def_action_call integer, cnt_r_raise_def_action_fold integer, cnt_r_raise_def_opp integer, cnt_r_raise_wtsd integer, cnt_r_raise_wtsd_won integer, cnt_r_saw integer, cnt_r_total_actions integer, cnt_sb integer, cnt_sb_steal_call integer, cnt_sb_steal_fold integer, cnt_sb_steal_raise integer, cnt_sessions integer, cnt_sessions_won integer, cnt_steal_att integer, cnt_steal_att_btn integer, cnt_steal_att_cutoff integer, cnt_steal_att_fold integer, cnt_steal_att_no_sd integer, cnt_steal_att_sb integer, cnt_steal_att_wtsd integer, cnt_steal_def_opp_bb integer, cnt_steal_def_opp_bb_nosd integer, cnt_steal_def_opp_bb_win_sd integer, cnt_steal_def_opp_bb_win_wo_sd integer, cnt_steal_def_opp_bb_wtsd integer, cnt_steal_def_opp_sb integer, cnt_steal_def_opp_sb_nosd integer, cnt_steal_def_opp_sb_win_sd integer, cnt_steal_def_opp_sb_win_wo_sd integer, cnt_steal_def_opp_sb_wtsd integer, cnt_steal_opp integer, cnt_steal_opp_btn integer, cnt_steal_opp_cutoff integer, cnt_steal_opp_sb integer, cnt_steal_reraise_def_action_fold integer, cnt_steal_reraise_def_opp integer, cnt_steal_success integer, cnt_steal_win_sd integer, cnt_steal_win_wo_sd integer, cnt_t_3bet integer, cnt_t_3bet_def_action_call integer, cnt_t_3bet_def_action_fold integer, cnt_t_3bet_def_action_raise integer, cnt_t_3bet_def_opp integer, cnt_t_3bet_opp integer, cnt_t_4bet integer, cnt_t_4bet_def_action_call integer, cnt_t_4bet_def_action_fold integer,

[greenrider]

cnt_t_4bet_def_action_raise integer, cnt_t_4bet_def_opp integer, cnt_t_4bet_opp integer, cnt_t_bet integer, cnt_t_bet_def_action_call integer, cnt_t_bet_def_action_fold integer, cnt_t_bet_def_action_raise integer, cnt_t_bet_def_opp integer, cnt_t_bet_raise_hands integer, cnt_t_call integer, cnt_t_call_hands integer, cnt_t_cbet integer, cnt_t_cbet_def_action_call integer, cnt_t_cbet_def_action_fold integer, cnt_t_cbet_def_action_raise integer, cnt_t_cbet_def_opp integer, cnt_t_cbet_face_raise integer, cnt_t_cbet_fold_to_raise integer, cnt_t_cbet_opp integer, cnt_t_check integer, cnt_t_check_raise integer, cnt_t_check_raise_opp integer, cnt_t_donk integer, cnt_t_donk_def_action_call integer, cnt_t_donk_def_action_fold integer, cnt_t_donk_def_action_raise integer, cnt_t_donk_def_opp integer, cnt_t_donk_opp integer, cnt_t_face_xr integer, cnt_t_face_xr_call integer, cnt_t_face_xr_fold integer, cnt_t_face_xr_raise integer, cnt_t_float integer, cnt_t_float_def_action_call integer, cnt_t_float_def_action_fold integer, cnt_t_float_def_action_raise integer, cnt_t_float_def_opp integer, cnt_t_float_opp integer, cnt_t_fold integer, cnt_t_probe integer, cnt_t_probe_opp integer, cnt_t_raise integer, cnt_t_raise_def_action_call integer, cnt_t_raise_def_action_fold integer, cnt_t_raise_def_opp integer, cnt_t_raise_wtsd integer, cnt_t_raise_wtsd_won integer, cnt_t_saw integer, cnt_t_total_actions integer, cnt_total_actions integer, cnt_vpip integer, cnt_vpip_sb integer, cnt_won_hand integer, cnt_won_showdown integer, cnt_wtsd integer, cnt_wtsd_when_f_bet_raise integer, cnt_wtsd_when_f_call integer, cnt_wtsd_when_p_bet_raise integer, cnt_wtsd_when_p_call integer, cnt_wtsd_when_r_bet_raise integer, cnt_wtsd_when_r_call integer, cnt_wtsd_when_t_bet_raise integer, cnt_wtsd_when_t_call integer, cnt_wtsd_won integer, cnt_wtsd_won_when_f_bet_raise integer, cnt_wtsd_won_when_f_call integer, cnt_wtsd_won_when_p_bet_raise integer, cnt_wtsd_won_when_p_call integer, cnt_wtsd_won_when_r_bet_raise integer, cnt_wtsd_won_when_r_call integer, cnt_wtsd_won_when_t_bet_raise integer, cnt_wtsd_won_when_t_call integer, cnt_wwosd_f_bet_raise integer, cnt_wwosd_f_call integer, cnt_wwosd_p_bet_raise integer, cnt_wwosd_p_call integer, cnt_wwosd_r_bet_raise integer, cnt_wwosd_r_call integer, cnt_wwosd_t_bet_raise integer, cnt_wwosd_t_call integer, amt_total_avg_f_bet numeric(11,2), amt_total_avg_r_bet numeric(11,2), amt_total_avg_t_bet numeric(11,2), amt_won_no_sd numeric(11,2), cnt_ccpf_btn integer, cnt_ccpf_btn_opp integer, cnt_ccpf_co integer, cnt_ccpf_co_opp integer, cnt_ccpf_hj integer, cnt_ccpf_hj_opp integer, cnt_ccpf_utg integer, cnt_ccpf_utg_opp integer, cnt_f_cbet_ip_def_action_raise integer, cnt_f_cbet_ip_def_opp integer, cnt_f_cbet_oop_def_action_raise integer, cnt_f_cbet_oop_def_opp integer, cnt_f_donk_fold integer, cnt_f_donk_fold_opp integer, cnt_hands_bb integer, cnt_hands_bu integer, cnt_hands_co integer, cnt_hands_custom integer, cnt_hands_hj integer, cnt_hands_mp integer, cnt_hands_sb integer, cnt_hands_utg integer, cnt_limp_face_raise integer, cnt_limp_fold integer, cnt_p_3bet_bb integer, cnt_p_3bet_btn integer, cnt_p_3bet_co integer, cnt_p_3bet_hj integer, cnt_p_3bet_sb integer, cnt_p_3bet_after_raise_btn integer, cnt_p_3bet_after_raise_co integer, cnt_p_3bet_after_raise_hj integer, cnt_p_3bet_after_raise_sb integer, cnt_p_3bet_after_raise_opp_btn integer, cnt_p_3bet_after_raise_opp_co integer, cnt_p_3bet_after_raise_opp_hj integer, cnt_p_3bet_after_raise_opp_sb integer, cnt_p_3bet_bb integer, cnt_p_3bet_bu integer, cnt_p_3bet_co integer, cnt_p_3bet_def_action_fold_when_raised_bb integer, cnt_p_3bet_def_action_fold_when_raised_bu integer, cnt_p_3bet_def_action_fold_when_raised_co integer, cnt_p_3bet_def_action_fold_when_raised_hj integer, cnt_p_3bet_def_action_fold_when_raised_sb integer, cnt_p_3bet_def_action_fold_when_raised_utg integer, cnt_p_3bet_def_opp_when_raised_bb integer, cnt_p_3bet_def_opp_when_raised_bu integer, cnt_p_3bet_def_opp_when_raised_co integer, cnt_p_3bet_def_opp_when_raised_hj integer, cnt_p_3bet_def_opp_when_raised_sb integer, cnt_p_3bet_def_opp_when_raised_utg integer, cnt_p_3bet_f_cbet integer, cnt_p_3bet_f_cbet_and_fold_to_raise integer, cnt_p_3bet_f_cbet_and_fold_to_raise_opp integer, cnt_p_3bet_f_cbet_barrel_turn integer, cnt_p_3bet_f_cbet_barrel_turn_opp integer, cnt_p_3bet_f_cbet_def_action_raise_custom integer, cnt_p_3bet_f_cbet_def_opp_custom integer, cnt_p_3bet_f_cbet_opp integer, cnt_p_3bet_fold_bb integer, cnt_p_3bet_fold_bu integer, cnt_p_3bet_fold_co integer, cnt_p_3bet_fold_hj integer, cnt_p_3bet_fold_sb integer, cnt_p_3bet_fold_utg integer, cnt_p_3bet_hj integer, cnt_p_3bet_opp_bb integer, cnt_p_3bet_opp_btn integer, cnt_p_3bet_opp_co integer, cnt_p_3bet_opp_hj integer, cnt_p_3bet_opp_sb integer, cnt_p_3bet_opp_bb integer, cnt_p_3bet_opp_bu integer, cnt_p_3bet_opp_co integer, cnt_p_3bet_opp_hj integer, cnt_p_3bet_opp_sb integer, cnt_p_3bet_opp_utg integer, cnt_p_3bet_pot_barrel_def_fold integer, cnt_p_3bet_pot_barrel_def_opp integer, cnt_p_3bet_sb integer, cnt_p_3bet_t_cbet integer, cnt_p_3bet_t_cbet_opp integer, cnt_p_3bet_utg integer, cnt_p_4bet_bb integer, cnt_p_4bet_bu integer, cnt_p_4bet_co integer, cnt_p_4bet_def_opp_bb integer, cnt_p_4bet_def_opp_bu integer, cnt_p_4bet_def_opp_co integer, cnt_p_4bet_def_opp_hj integer, cnt_p_4bet_def_opp_sb integer, cnt_p_4bet_def_opp_utg integer, cnt_p_4bet_hj integer, cnt_p_4bet_opp_bb integer, cnt_p_4bet_opp_bu integer, cnt_p_4bet_opp_co integer, cnt_p_4bet_opp_hj integer, cnt_p_4bet_opp_sb integer, cnt_p_4bet_opp_utg integer, cnt_p_4bet_sb integer, cnt_p_4bet_utg integer, cnt_p_facing_limpers_bb integer, cnt_p_facing_limpers_bu integer, cnt_p_facing_limpers_co integer, cnt_p_facing_limpers_hj integer, cnt_p_facing_limpers_sb integer, cnt_p_facing_limpers_utg integer, cnt_p_fold_to_4bet_after_3bet integer, cnt_p_fold_to_4bet_after_3bet_opp integer, cnt_p_limp_and_fold_bb integer, cnt_p_limp_and_fold_bu integer, cnt_p_limp_and_fold_co integer, cnt_p_limp_and_fold_hj integer, cnt_p_limp_and_fold_sb integer, cnt_p_limp_and_fold_utg integer, cnt_p_limp_faceraise_bb integer, cnt_p_limp_faceraise_bu integer, cnt_p_limp_faceraise_co integer, cnt_p_limp_faceraise_hj integer, cnt_p_limp_faceraise_sb integer, cnt_p_limp_faceraise_utg integer, cnt_p_raise_limpers_bb integer, cnt_p_raise_limpers_bu integer, cnt_p_raise_limpers_co integer, cnt_p_raise_limpers_hj integer, cnt_p_raise_limpers_sb integer, cnt_p_raise_limpers_utg integer, cnt_p_squeeze_ip integer, cnt_p_squeeze_ip_opp integer, cnt_p_squeeze_oop integer, cnt_p_squeeze_oop_opp integer, cnt_pfr_bb integer, cnt_pfr_bu integer, cnt_pfr_co integer, cnt_pfr_hj integer, cnt_pfr_sb integer, cnt_pfr_utg integer, cnt_prev_callers_limp_bu integer, cnt_prev_callers_limp_co integer, cnt_prev_callers_limp_hj integer, cnt_prev_callers_limp_sb integer, cnt_prev_callers_limp_utg integer, cnt_vpip_bb integer, cnt_vpip_bu integer, cnt_vpip_co integer, cnt_vpip_hj integer, cnt_vpip_mp integer, cnt_vpip_utg integer, js2002_cnt_p_3bet_f_cbet_def_action_raisecb integer, js2002_cnt_p_3bet_f_cbet_def_opp integer, js2002_cnt_p_3bet_f_cbet_raise_def_action_fold integer, js2002_cnt_p_3bet_f_cbet_raise_def_opp integer);; Reason: Fatal Error (ERROR: column "cnt_p_3bet_bb" specified more than once )

[kraada]

You imported some custom stats and as a result you have two custom columns that are the same but for the case - cnt_p_3bet_bb and likely cnt_p_3bet_BB - remove one of them and you should be good.

[greenrider]

Got it working!
Thanks for your help