[Geschlossen] Cache Status nach manuellem import + housekeeping kleiner als zuvor

Mach mal Rebuild Cache.

Dauert zwar ein bißchen länger als das reine Update, sollte dein Problem aber lösen.

Zur Logfrage: Im Ordner PokerTracker 3 / Logs solltest du das finden.

Original von Ajezz
Mach mal Rebuild Cache.

Dauert zwar ein bißchen länger als das reine Update, sollte dein Problem aber lösen.

Zur Logfrage: Im Ordner PokerTracker 3 / Logs solltest du das finden.

ok, werds später mal ausprobieren... logs hab ich gefunden, jedoch sind die files im editor total unlesbar und durcheinander, wohl nur für die entwickler gedacht...

Wenn ich rebuild cache mache kommt direkt das:

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, 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, 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, pfr_bb_numerator integer, pfr_button_numerator integer, pfr_button_plus3_numerator_scm integer, pfr_co_numerator integer, pfr_hijack_numerator integer, pfr_sb_numerator integer, vpip_bb_denominator integer, vpip_button_plus3_denominator_scm integer, vpip_hijack_denominator integer, vpip_sb_denominator integer, vpip_button_denominator integer, vpip_from_co_demoninator integer, amt_avg_f_bet numeric(11,2), amt_avg_r_bet numeric(11,2), amt_avg_t_bet numeric(11,2), cnt_bb_steal_call_vs_bu integer, cnt_bb_steal_call_vs_co integer, cnt_bb_steal_call_vs_sb integer, cnt_f_cbet_ip integer, cnt_f_cbet_ip_def_action_raise integer, cnt_f_cbet_ip_def_opp integer, cnt_f_cbet_oop integer, cnt_f_cbet_oop_def_action_raise integer, cnt_f_cbet_oop_def_opp integer, cnt_f_cbet_opp_ip integer, cnt_f_cbet_opp_oop integer, cnt_f_cbetraise_def_action_fold integer, cnt_f_cbetraise_def_opp integer, cnt_f_donk_fold integer, cnt_f_donk_fold_opp integer, cnt_f_face_minraise integer, cnt_f_face_minraise_fold integer, cnt_f_face_minraise_raise integer, cnt_f_fold_to_donk integer, cnt_f_fold_to_donk_opp integer, cnt_f_minraise integer, cnt_f_probe_bet_raised_pot integer, cnt_f_probe_bet_raised_pot_def_opp integer, cnt_f_probe_bet_raised_pot_def_opp_action_fold integer, cnt_f_probe_bet_raised_pot_opp integer, cnt_hands_bu integer, cnt_hands_co integer, cnt_hands_hj integer, cnt_hands_utg integer, cnt_p_3bet_bb integer, cnt_p_3bet_bu integer, cnt_p_3bet_co integer, cnt_p_3bet_f_cbet integer, cnt_p_3bet_f_cbet_opp integer, cnt_p_3bet_hj 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_sb integer, cnt_p_3bet_t_cbet integer, cnt_p_3bet_t_cbet_def_action_call integer, cnt_p_3bet_t_cbet_def_action_fold integer, cnt_p_3bet_t_cbet_def_action_raise integer, cnt_p_3bet_t_cbet_def_opp integer, cnt_p_3bet_t_cbet_opp integer, cnt_p_3bet_utg integer, cnt_p_ccall_bu integer, cnt_p_ccall_co integer, cnt_p_ccall_hj integer, cnt_p_ccall_opp_bu integer, cnt_p_ccall_opp_co integer, cnt_p_ccall_opp_hj integer, cnt_p_ccall_opp_utg integer, cnt_p_ccall_utg integer, cnt_p_limp_call_f_face_cbet integer, cnt_p_limp_call_f_face_cbet_def_action_fold integer, cnt_p_limp_success integer, cnt_p_open_opp_bb integer, cnt_p_open_opp_bu integer, cnt_p_open_opp_co integer, cnt_p_open_opp_hj integer, cnt_p_open_opp_sb integer, cnt_p_open_opp_utg integer, cnt_p_pfr_call_bb integer, cnt_p_pfr_call_bu integer, cnt_p_pfr_call_co integer, cnt_p_pfr_call_hj integer, cnt_p_pfr_call_opp_bb integer, cnt_p_pfr_call_opp_bu integer, cnt_p_pfr_call_opp_co integer, cnt_p_pfr_call_opp_hj integer, cnt_p_pfr_call_opp_sb integer, cnt_p_pfr_call_opp_utg integer, cnt_p_pfr_call_sb integer, cnt_p_pfr_call_utg integer, cnt_p_raise_first_in_bb integer, cnt_p_raise_first_in_bu integer, cnt_p_raise_first_in_co integer, cnt_p_raise_first_in_hj integer, cnt_p_raise_first_in_sb integer, cnt_p_raise_first_in_utg integer, cnt_r_cbet_3b_pot integer, cnt_r_cbet_opp_3b_pot integer, cnt_r_cbetraise_def_action_fold integer, cnt_r_cbetraise_def_opp integer, cnt_r_donk_fold integer, cnt_r_donk_fold_opp integer, cnt_r_face_minraise integer, cnt_r_face_minraise_fold integer, cnt_r_face_minraise_raise integer, cnt_r_minraise integer, cnt_sb_limp_call integer, cnt_sb_limp_face_raise integer, cnt_sb_steal_call_vs_bu integer, cnt_sb_steal_call_vs_co integer, cnt_steal_att_bu integer, cnt_steal_att_co integer, cnt_steal_att_sb integer, cnt_steal_def_opp_bb_vs_bu integer, cnt_steal_def_opp_bb_vs_co integer, cnt_steal_def_opp_bb_vs_sb integer, cnt_steal_def_opp_sb_vs_bu integer, cnt_steal_def_opp_sb_vs_co integer, cnt_steal_opp_bu integer, cnt_steal_opp_co integer, cnt_steal_opp_sb integer, cnt_steal_unraised_pot integer, cnt_steal_unraised_pot_ip integer, cnt_steal_unraised_pot_ip_players_2 integer, cnt_steal_unraised_pot_opp integer, cnt_steal_unraised_pot_opp_ip integer, cnt_steal_unraised_pot_opp_ip_players_2 integer, cnt_steal_unraised_pot_opp_players_2 integer, cnt_steal_unraised_pot_players_2 integer, cnt_t_cbetraise_def_action_fold integer, cnt_t_cbetraise_def_opp integer, cnt_t_donk_fold integer, cnt_t_donk_fold_opp integer, cnt_t_face_minraise integer, cnt_t_face_minraise_fold integer, cnt_t_face_minraise_raise integer, cnt_t_minraise integer, cnt_vpip_bb integer, cnt_vpip_bu integer, cnt_vpip_co integer, cnt_vpip_hj integer, cnt_vpip_utg integer, js2002_cnt_f_probe_bet_3bet_pot integer, js2002_cnt_f_probe_bet_3bet_pot_def_opp integer, js2002_cnt_f_probe_bet_3bet_pot_def_opp_action_fold integer, js2002_cnt_f_probe_bet_3bet_pot_opp integer, js2002_cnt_p_3bet_def_action_fold_bb integer, js2002_cnt_p_3bet_def_action_fold_bu integer, js2002_cnt_p_3bet_def_action_fold_co integer, js2002_cnt_p_3bet_def_action_fold_hj integer, js2002_cnt_p_3bet_def_action_fold_sb integer, js2002_cnt_p_3bet_def_action_fold_utg integer, js2002_cnt_p_3bet_def_opp_bb integer, js2002_cnt_p_3bet_def_opp_bu integer, js2002_cnt_p_3bet_def_opp_co integer, js2002_cnt_p_3bet_def_opp_hj integer, js2002_cnt_p_3bet_def_opp_sb integer, js2002_cnt_p_3bet_def_opp_utg integer, js2002_cnt_p_3bet_f_cbet_and_allin_def_action_fold integer, js2002_cnt_p_3bet_f_cbet_and_allin_def_opp 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, js2002_cnt_p_4bet_def_action_fold integer, js2002_cnt_p_4bet_def_action_fold_bb integer, js2002_cnt_p_4bet_def_action_fold_bu integer, js2002_cnt_p_4bet_def_action_fold_co integer, js2002_cnt_p_4bet_def_action_fold_hj integer, js2002_cnt_p_4bet_def_action_fold_sb integer, js2002_cnt_p_4bet_def_action_fold_utg integer, js2002_cnt_p_4bet_def_opp integer, js2002_cnt_p_4bet_def_opp_bb integer, js2002_cnt_p_4bet_def_opp_bu integer, js2002_cnt_p_4bet_def_opp_co integer, js2002_cnt_p_4bet_def_opp_hj integer, js2002_cnt_p_4bet_def_opp_sb integer, js2002_cnt_p_4bet_def_opp_utg integer, js2002_cnt_p_bb_3bet_to_bu_steal integer, js2002_cnt_p_bb_3bet_to_co_steal integer, js2002_cnt_p_bb_3bet_to_sb_steal integer, js2002_cnt_p_bb_fold_to_bu integer, js2002_cnt_p_bb_fold_to_bu_opp integer, js2002_cnt_p_bb_fold_to_co integer, js2002_cnt_p_bb_fold_to_co_opp integer, js2002_cnt_p_bb_fold_to_sb_opp integer, js2002_cnt_p_sb_3bet_to_bu_steal integer, js2002_cnt_p_sb_3bet_to_co_steal integer, js2002_cnt_p_sb_fold_to_bu integer, js2002_cnt_p_sb_fold_to_bu_opp integer, js2002_cnt_p_sb_fold_to_co integer, js2002_cnt_p_sb_fold_to_co_opp integer, js2002_cnt_p_allin_def_action_fold integer, js2002_cnt_p_allin_def_opp integer, js2002_cnt_p_squeeze_def_action_fold integer, js2002_cnt_p_squeeze_def_opp integer, js2002_cnt_r_probebet_after_seeing_checkbehind_t integer, js2002_cnt_r_probebet_after_seeing_checkbehind_t_opp integer, js2002_cnt_t_probebet_after_seeing_checkbehind_f integer, js2002_cnt_t_probebet_after_seeing_checkbehind_f_opp integer);; Reason: Fatal Error (ERROR: column "cnt_steal_att_sb" specified more than once )

Bekannter Fehler. Du hast offenbar ein Custom Layout runtergeladen, bei dem es zu einem kleinen Problem kommt.

Lösung siehe in diesem Post: Nach Update auf 30.10 Fehlermeldung beim Housekeeping
Also einfach die Clums löschen und bei den Stats die Groß-/Kleinschreibung ändern.

seh ich das richtig, dass ich alle Stats ändern muss? der Fehler kommt nämlich immer noch und das sind echt viele...

Nein, natürlich nur die, wo die Column drin vorkommt. Da dies eh nur in Custom Stats ist, mußt du nur die blauen durchschauen.

Lösung in diesem Post: Nach Update auf 30.10 Fehlermeldung beim Housekeeping