Error when manually importing hands windows 7

[knlmwq]

Hello,
I get this looong error message when attemting to import hands. The error doesnt happen until pokertracker starts doing the housekeeping. I have UAC turned off and I am running pokertracker as administrator. Thanks for any help you can give me. Here is the error message:

There were errors during the housekeeping process:
Unable to execute query: VACUUM holdem_table_session_summary;; Reason: Fatal Error (ERROR: relation "holdem_table_session_summary" does not exist )
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_fold) 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_action='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_3bet_action='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_3bet_action='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_action='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_4bet_action='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_4bet_action='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_action='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_cbet_action='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_f_cbet_action='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_raise) 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_raise AND holdem_hand_player_statistics.cnt_f_call > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_face_raise AND holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_f_face_raise) 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_action='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='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_action='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_p_4bet_action='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_p_4bet_action='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_pos = 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_pos = 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_raise) 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_raise) 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_raise) 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_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_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_raise 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_raise) then 1 else 0 end))),
(sum(holdem_hand_player_statistics.cnt_p_raise)),
(sum( (case when(holdem_hand_player_statistics.flg_p_first_raise 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_action='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_3bet_action='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_3bet_action='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_action='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_4bet_action='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_4bet_action='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_action='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_cbet_action='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_cbet_action='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_raise) 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_action='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_donk_action='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_donk_action='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_action='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_float_action='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_r_float_action='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_raise AND holdem_hand_player_statistics.cnt_r_call > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_face_raise AND holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_r_face_raise) 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_fold) 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_opp AND holdem_hand_player_statistics.flg_blind_b) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_b) then 1 else 0 end))) - (sum((case when(holdem_hand_player_statistics.flg_blind_def_opp 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_opp 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_opp 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_opp 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_opp AND holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))),
(sum( (case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_s) 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.flg_showdown) 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.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_opp 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_opp 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_action='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_3bet_action='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_3bet_action='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_action='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_4bet_action='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_4bet_action='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_action='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_cbet_action='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_cbet_action='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_raise) 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_action='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_donk_action='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_donk_action='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_action='C') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_float_action='F') then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.enum_t_float_action='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_raise AND holdem_hand_player_statistics.cnt_t_call > 0) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_face_raise AND holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))),
(sum((case when(holdem_hand_player_statistics.flg_t_face_raise) 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_statistics."position" AND lookup_positions.cnt_players=holdem_hand_player_statistics.cnt_players)
AND (holdem_hand_summary.id_hand = holdem_hand_player_detail.id_hand)
AND (lookup_actions_p.id_action=holdem_hand_player_detail.id_action_p)
AND (lookup_actions_f.id_action=holdem_hand_player_detail.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: relation "holdem_hand_player_statistics" does not exist LINE 260: FROM holdem_hand_player_statistics , ^ )

[knlmwq]

Other info.. I am running the trial pokertracker. Latest beta and postgres 8.4.1

[WhiteRider]

Please enable logging and run housekeeping then attach the PokerTracker.log file to a support ticket so that we can investigate.
Tutorial: Submitting a Bug Report