Home / Community / Forum / Poker Forum / Poker Ausbildung /

PT3 houskeeping process problem

Alt
Question
PT3 houskeeping process problem - 06-05-2009, 23:34
(#1)
Benutzerbild von 4playaz
Since: Mar 2008
Posts: 10
Ich probier seit stunden PT3 zum laufen zu bekommen. hab jetzt auch verbindung und alles. jetzt zeigt der mir beim importieren folgendes an:


There were errors during the housekeeping process:
Unable to prepare query: INSERT INTO holdem_cache SELECT holdem_hand_player_statistics.id_player, holdem_hand_player_statistics.id_limit, holdem_hand_summary.cnt_players, ((case when( lookup_positions.flg_blinds) then 0 else (case when( lookup_positions.flg_ep) then 1 else (case when( lookup_positions.flg_mp) then 2 else 3 end) end) end)),
(sum( (CASE WHEN ( (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult)) 0 THEN ((holdem_hand_player_statistics.amt_won * 1.0 )/( (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult))) ELSE 0 END) )),
(sum(holdem_hand_player_detail.amt_blind)),
(sum(holdem_hand_summary.amt_mgr)),
(sum( (case when(holdem_hand_player_statistics.flg_won_hand) then holdem_hand_summary.amt_rake else 0 end) )),
(sum(holdem_hand_player_statistics.amt_won)),
(sum( (case when(holdem_hand_player_statistics.flg_blind_b and holdem_hand_player_statistics.flg_blind_s = false) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_bb_steal_fo ld) then 1 else 0 end))),
(sum((case when( holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s OR holdem_hand_player_statistics.flg_blind_db OR holdem_hand_player_statistics.flg_blind_ds) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_3bet) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_3bet_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_3bet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_3bet_act ion='R') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_3bet_def_ opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_3bet_opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_4bet) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_4bet_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_4bet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_4bet_act ion='R') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_4bet_def_ opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_4bet_opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))),
(sum((case when(holdem_hand_player_detail.amt_f_bet_facing > 0 AND holdem_hand_player_statistics.cnt_f_call > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_detail.amt_f_bet_facing > 0 AND holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))),
(sum((case when(holdem_hand_player_detail.amt_f_bet_facing > 0 AND holdem_hand_player_statistics.cnt_f_raise > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_detail.amt_f_bet_facing > 0) then 1 else 0 end))),
(sum((case when( (holdem_hand_player_statistics.flg_f_bet OR holdem_hand_player_statistics.cnt_f_raise > 0)) then 1 else 0 end))),
(sum(holdem_hand_player_statistics.cnt_f_call)),
(sum((case when(holdem_hand_player_statistics.cnt_f_call > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_cbet) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_cbet_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_cbet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_cbet_act ion='R') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_cbet_def_ opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_cbet_opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_check) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_check_rai se) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_check AND (holdem_hand_player_statistics.cnt_f_raise > 0 OR holdem_hand_player_statistics.cnt_f_call > 0 OR holdem_hand_player_statistics.flg_f_fold)) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))),
(sum(holdem_hand_player_statistics.cnt_f_raise)),
(sum((case when(holdem_hand_player_statistics.flg_f_face_rais e AND holdem_hand_player_statistics.cnt_f_call > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_face_rais e AND holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_face_rais e) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_won_hand AND holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_f_call)) + (sum((case when(holdem_hand_player_statistics.flg_f_check) then 1 else 0 end))) + (sum((case when(holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_f_raise)),
(sum( (case when(holdem_hand_player_statistics.flg_p_open AND holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))),
(sum( (case when( (holdem_hand_player_statistics.flg_f_bet OR holdem_hand_player_statistics.cnt_f_raise > 0) and NOT(holdem_hand_player_statistics.flg_won_hand) and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.cnt_f_call > 0 and NOT(holdem_hand_player_statistics.flg_won_hand) and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( (holdem_hand_player_statistics.cnt_p_raise > 0) and NOT(holdem_hand_player_statistics.flg_won_hand) and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.cnt_p_call > 0 and NOT(holdem_hand_player_statistics.flg_won_hand) and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( (holdem_hand_player_statistics.flg_r_bet OR holdem_hand_player_statistics.cnt_r_raise > 0) and NOT(holdem_hand_player_statistics.flg_won_hand) and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.cnt_r_call > 0 and NOT(holdem_hand_player_statistics.flg_won_hand) and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( (holdem_hand_player_statistics.flg_t_bet OR holdem_hand_player_statistics.cnt_t_raise > 0) and NOT(holdem_hand_player_statistics.flg_won_hand) and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.cnt_t_call > 0 and NOT(holdem_hand_player_statistics.flg_won_hand) and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_summary.amt_rake > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_summary.cnt_players_f > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_p_3bet_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_p_3bet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_p_3bet_act ion='R') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_3bet_def_ opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_4bet) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_p_4bet_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_p_4bet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_p_4bet_act ion='R') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_4bet_def_ opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_4bet_opp) then 1 else 0 end))),
(sum((case when(substring(lookup_actions_p.action from 1 for 1)='F' AND
holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_po s = 9 AND holdem_hand_player_statistics.flg_blind_def_opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_po s = 9 AND holdem_hand_player_statistics.flg_blind_def_opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))),
(sum(holdem_hand_player_statistics.cnt_p_call)),
(sum((case when(holdem_hand_player_statistics.cnt_p_call > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))),
(sum( (case when( NOT(NOT(holdem_hand_player_statistics.flg_p_face_r aise) OR (holdem_hand_player_statistics.flg_p_limp) OR (holdem_hand_player_statistics.flg_p_first_raise)) AND (holdem_hand_player_detail.amt_blind=0)) then 1 else 0 end) )),
(sum((case when(substring(lookup_actions_p.action from 1 for 1)='X') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_face_rais e) then 1 else 0 end))),
(sum( (case when( ((NOT holdem_hand_player_statistics.flg_p_face_raise) OR holdem_hand_player_statistics.flg_p_limp OR holdem_hand_player_statistics.flg_p_first_raise) AND NOT holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action '') then 1 else 0 end) )),
(sum( (case when(holdem_hand_player_statistics.flg_p_first_rai se) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))),
(sum( (case when( (NOT(holdem_hand_player_statistics.flg_p_face_rais e) OR (holdem_hand_player_statistics.flg_p_limp) OR (holdem_hand_player_statistics.flg_p_first_raise)) AND NOT(holdem_hand_player_statistics.flg_blind_b) AND NOT(holdem_hand_player_statistics.flg_p_open_opp)) then 1 else 0 end) )),
(sum((case when(holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_face_rais e AND holdem_hand_player_statistics.flg_p_fold = false AND holdem_hand_player_statistics.cnt_p_raise=0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_p_face_rais e) then 1 else 0 end))),
(sum(holdem_hand_player_statistics.cnt_p_raise)),
(sum( (case when(holdem_hand_player_statistics.flg_p_first_rai se AND holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ),
(sum( (case when( holdem_hand_player_statistics.flg_p_first_raise AND NOT holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end) )),
(sum(holdem_hand_player_statistics.cnt_p_call)) + (sum((case when(holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_p_raise)) + (sum((case when(substring(lookup_actions_p.action from 1 for 1)='X') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.flg_f_saw AND substring(lookup_actions_f.action from 1 for 1)='B') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.flg_f_saw AND substring(lookup_actions_f.action from 1 for 1)='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.flg_f_saw AND substring(lookup_actions_f.action from 1 for 1)='X') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.flg_f_saw AND substring(lookup_actions_f.action from 1 for 2)='XR') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.flg_f_saw AND substring(lookup_actions_f.action from 1 for 1)='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0 AND (NOT holdem_hand_player_statistics.flg_f_saw OR substring(lookup_actions_f.action from 1 for 1)='')) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.flg_f_saw AND substring(lookup_actions_f.action from 1 for 1)='R') then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.flg_p_limp = false AND holdem_hand_player_statistics.flg_p_ccall = false) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_3bet) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_3bet_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_3bet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_3bet_act ion='R') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_3bet_def_ opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_3bet_opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_4bet) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_4bet_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_4bet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_4bet_act ion='R') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_4bet_def_ opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_4bet_opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))),
(sum((case when(holdem_hand_player_detail.amt_r_bet_facing > 0 AND holdem_hand_player_statistics.cnt_r_call > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_detail.amt_r_bet_facing > 0 AND holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))),
(sum((case when(holdem_hand_player_detail.amt_r_bet_facing > 0 AND holdem_hand_player_statistics.cnt_r_raise > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_detail.amt_r_bet_facing > 0) then 1 else 0 end))),
(sum((case when( (holdem_hand_player_statistics.flg_r_bet OR holdem_hand_player_statistics.cnt_r_raise > 0)) then 1 else 0 end))),
(sum(holdem_hand_player_statistics.cnt_r_call)),
(sum((case when(holdem_hand_player_statistics.cnt_r_call > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_cbet) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_cbet_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_cbet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_cbet_act ion='R') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_cbet_def_ opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_cbet_opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_check) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_check_rai se) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_check AND (holdem_hand_player_statistics.cnt_r_raise > 0 OR holdem_hand_player_statistics.cnt_r_call > 0 OR holdem_hand_player_statistics.flg_r_fold)) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_donk) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_donk_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_donk_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_donk_act ion='R') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_donk_def_ opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_donk_opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_float) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_float_ac tion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_float_ac tion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_float_ac tion='R') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_float_def _opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_float_opp ) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))),
(sum(holdem_hand_player_statistics.cnt_r_raise)),
(sum((case when(holdem_hand_player_statistics.flg_r_face_rais e AND holdem_hand_player_statistics.cnt_r_call > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_face_rais e AND holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_face_rais e) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.cnt_r_raise > 0 AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.cnt_r_raise > 0 AND holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_saw) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_r_call)) + (sum((case when(holdem_hand_player_statistics.flg_r_check) then 1 else 0 end))) + (sum((case when(holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_r_raise)),
(sum( (case when(holdem_hand_player_statistics.flg_blind_b = false AND holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_sb_steal_fo ld) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))),
(count(distinct holdem_hand_player_statistics.id_session)),
(count( (SELECT (case when(sum(hhps_s.amt_won) > 0) then 1 else 0 end) FROM holdem_hand_player_statistics hhps_s WHERE id_session = holdem_hand_player_statistics.id_session) )),
(sum((case when(holdem_hand_player_statistics.flg_steal_att) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.enum_folded'N') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_steal_att AND NOT holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_blind_def_o pp AND holdem_hand_player_statistics.flg_blind_b) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_blind_def_o pp AND holdem_hand_player_statistics.flg_blind_b) then 1 else 0 end))) - (sum((case when(holdem_hand_player_statistics.flg_blind_def_o pp AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_blind_def_o pp AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_won_hand AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_blind_def_o pp AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_won_hand AND NOT holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_blind_def_o pp AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_blind_def_o pp AND holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_blind_def_o pp AND holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))) - (sum((case when(holdem_hand_player_statistics.flg_blind_def_o pp AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_blind_def_o pp AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_won_hand AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_blind_def_o pp AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_won_hand AND NOT holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_blind_def_o pp AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_steal_opp) then 1 else 0 end))),
(sum((case when( holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.flg_p_3bet_def_opp AND holdem_hand_player_statistics.enum_p_3bet_action=' F') then 1 else 0 end))),
(sum((case when( holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_steal_att AND NOT(holdem_hand_player_statistics.flg_f_saw) AND NOT(holdem_hand_player_statistics.flg_p_face_raise )) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.flg_won_hand AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_steal_att AND holdem_hand_player_statistics.flg_won_hand AND NOT holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_3bet) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_3bet_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_3bet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_3bet_act ion='R') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_3bet_def_ opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_3bet_opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_4bet) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_4bet_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_4bet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_4bet_act ion='R') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_4bet_def_ opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_4bet_opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))),
(sum((case when(holdem_hand_player_detail.amt_t_bet_facing > 0 AND holdem_hand_player_statistics.cnt_t_call > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_detail.amt_t_bet_facing > 0 AND holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))),
(sum((case when(holdem_hand_player_detail.amt_t_bet_facing > 0 AND holdem_hand_player_statistics.cnt_t_raise > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_detail.amt_t_bet_facing > 0) then 1 else 0 end))),
(sum((case when( (holdem_hand_player_statistics.flg_t_bet OR holdem_hand_player_statistics.cnt_t_raise > 0)) then 1 else 0 end))),
(sum(holdem_hand_player_statistics.cnt_t_call)),
(sum((case when(holdem_hand_player_statistics.cnt_t_call > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_cbet) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_cbet_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_cbet_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_cbet_act ion='R') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_cbet_def_ opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_cbet_opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_check) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_check_rai se) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_check AND (holdem_hand_player_statistics.cnt_t_raise > 0 OR holdem_hand_player_statistics.cnt_t_call > 0 OR holdem_hand_player_statistics.flg_t_fold)) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_donk) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_donk_act ion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_donk_act ion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_donk_act ion='R') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_donk_def_ opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_donk_opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_float) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_float_ac tion='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_float_ac tion='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_float_ac tion='R') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_float_def _opp) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_float_opp ) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))),
(sum(holdem_hand_player_statistics.cnt_t_raise)),
(sum((case when(holdem_hand_player_statistics.flg_t_face_rais e AND holdem_hand_player_statistics.cnt_t_call > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_face_rais e AND holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_face_rais e) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.cnt_t_raise > 0 AND holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.cnt_t_raise > 0 AND holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_saw) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_t_call)) + (sum((case when(holdem_hand_player_statistics.flg_t_check) then 1 else 0 end))) + (sum((case when(holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_t_raise)),
(sum(holdem_hand_player_statistics.cnt_p_call)) + (sum((case when(holdem_hand_player_statistics.flg_p_fold) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_p_raise)) + (sum((case when(substring(lookup_actions_p.action from 1 for 1)='X') then 1 else 0 end))) + (sum((case when(holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_f_call)) + (sum((case when(holdem_hand_player_statistics.flg_f_check) then 1 else 0 end))) + (sum((case when(holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_f_raise)) + (sum((case when(holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_t_call)) + (sum((case when(holdem_hand_player_statistics.flg_t_check) then 1 else 0 end))) + (sum((case when(holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_t_raise)) + (sum((case when(holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_r_call)) + (sum((case when(holdem_hand_player_statistics.flg_r_check) then 1 else 0 end))) + (sum((case when(holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))) + (sum(holdem_hand_player_statistics.cnt_r_raise)),
(sum((case when(holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_blind_b = false AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.flg_vpip) then 1 else 0 end) )),
(sum((case when(holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when((holdem_hand_player_statistics.flg_f_bet OR holdem_hand_player_statistics.cnt_f_raise > 0) and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.cnt_f_call > 0 and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.cnt_p_raise > 0 and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.cnt_p_call > 0 and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when((holdem_hand_player_statistics.flg_r_bet OR holdem_hand_player_statistics.cnt_r_raise > 0) and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.cnt_r_call > 0 and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when((holdem_hand_player_statistics.flg_t_bet OR holdem_hand_player_statistics.cnt_t_raise > 0) and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.cnt_t_call > 0 and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))),
(sum( (case when( (holdem_hand_player_statistics.flg_f_bet OR holdem_hand_player_statistics.cnt_f_raise > 0) and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.cnt_f_call > 0 and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.cnt_p_raise > 0 and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.cnt_p_call > 0 and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when( (holdem_hand_player_statistics.flg_r_bet OR holdem_hand_player_statistics.cnt_r_raise > 0) and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.cnt_r_call > 0 and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when( (holdem_hand_player_statistics.flg_t_bet OR holdem_hand_player_statistics.cnt_t_raise > 0) and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.cnt_t_call > 0 and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))),
(sum( (case when( (holdem_hand_player_statistics.flg_f_bet OR holdem_hand_player_statistics.cnt_f_raise > 0) and holdem_hand_player_statistics.flg_won_hand and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.cnt_f_call > 0 and holdem_hand_player_statistics.flg_won_hand and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.cnt_p_raise > 0 and holdem_hand_player_statistics.flg_won_hand and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.cnt_p_call > 0 and holdem_hand_player_statistics.flg_won_hand and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( (holdem_hand_player_statistics.flg_r_bet OR holdem_hand_player_statistics.cnt_r_raise > 0) and holdem_hand_player_statistics.flg_won_hand and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.cnt_r_call > 0 and holdem_hand_player_statistics.flg_won_hand and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( (holdem_hand_player_statistics.flg_t_bet OR holdem_hand_player_statistics.cnt_t_raise > 0) and holdem_hand_player_statistics.flg_won_hand and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end))),
(sum( (case when( holdem_hand_player_statistics.cnt_t_call > 0 and holdem_hand_player_statistics.flg_won_hand and NOT(holdem_hand_player_statistics.flg_showdown)) then 1 else 0 end)))
FROM holdem_hand_player_statistics ,
holdem_hand_player_detail,
holdem_hand_summary,
holdem_limit,
lookup_actions lookup_actions_p,
lookup_actions lookup_actions_f,
lookup_positions
WHERE (holdem_hand_player_statistics.id_hand = holdem_hand_player_detail.id_hand AND holdem_hand_player_statistics.id_player = holdem_hand_player_detail.id_player)
AND (holdem_hand_summary.id_hand = holdem_hand_player_statistics.id_hand)
AND (holdem_limit.id_limit = holdem_hand_player_statistics.id_limit)
AND (lookup_positions."position"=holdem_hand_player_st atistics."position" AND lookup_positions.cnt_players=holdem_hand_player_st atistics.cnt_players)
AND (holdem_hand_summary.id_hand = holdem_hand_player_detail.id_hand)
AND (lookup_actions_p.id_action=holdem_hand_player_det ail.id_action_p)
AND (lookup_actions_f.id_action=holdem_hand_player_det ail.id_action_f)
AND (holdem_limit.id_limit = holdem_hand_summary.id_limit)
AND (holdem_hand_player_statistics.id_player = $1)
GROUP BY holdem_hand_player_statistics.id_player, holdem_hand_player_statistics.id_limit, holdem_hand_summary.cnt_players, ((case when( lookup_positions.flg_blinds) then 0 else (case when( lookup_positions.flg_ep) then 1 else (case when( lookup_positions.flg_mp) then 2 else 3 end) end) end)) ; Reason: Fatal Error (ERROR: column holdem_hand_player_statistics.cnt_players does not exist LINE 270: ...stics."position" AND lookup_positions.cnt_players=holdem_han... ^ )







ZUDEM: wenn ich auto-import anmache kommt folgender satz:

Unable to begin feeder import process. Reason: PokerTracker is configured to import into an outdated database. This must be corrected before an import can succeed.





Was sagt mir das?
danke schonmal falls mir jmd helfen kann

Geändert von 4playaz (06-05-2009 um 23:39 Uhr).
 
Alt
Standard
07-05-2009, 00:08
(#2)
Benutzerbild von crowsen
Since: Sep 2007
Posts: 5.697
email an den support...

Mit genau dem Inhalt
 



Ähnliche Themen
Thema Autor Forum Antworten Letzter Beitrag
PT3 Hud FR/SH Problem PeterParka Poker Ausbildung 2 31-12-2008 14:12
Problem mit Pt bei s&g rasek Poker Ausbildung 0 05-11-2007 15:52