by cneuy3 » Tue Jun 03, 2014 6:38 pm
4.11.6 completely screwed up my Pokertracker 4. I downgraded back to 4.11.2 which was the one I was using before and had been working OK for me and now I cannot even update my Cache on 4.11.2. Before I could play and do just fine on that one.
Unable to rebuild cache.
Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: missing FROM-clause entry for table "cash_blinds" LINE 1: ...h_hand_player_statistics.amt_p_effective_stack 0 AND cash_hand_player_statistics.amt_p_effective_stack 0 AND cash_hand_player_statistics.amt_p_effective_stack BETWEEN cash_blinds.amt_bb * 10 and cash_blinds.amt_bb * 20) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.id_hand > 0 AND cash_hand_player_statistics.amt_p_effective_stack BETWEEN cash_blinds.amt_bb * 20 and cash_blinds.amt_bb * 35) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.id_hand > 0 AND cash_hand_player_statistics.amt_p_effective_stack BETWEEN cash_blinds.amt_bb * 35 and cash_blinds.amt_bb * 55) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.id_hand > 0 AND cash_hand_player_statistics.amt_p_effective_stack >= cash_blinds.amt_bb * 55) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.id_hand > 0 AND cash_hand_player_statistics.amt_p_effective_stack BETWEEN cash_blinds.amt_bb * 5 and cash_blinds.amt_bb * 10) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_open_opp AND cash_hand_player_statistics.amt_p_effective_stack = cash_blinds.amt_bb * 55) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_open_opp AND cash_hand_player_statistics.amt_p_effective_stack BETWEEN cash_blinds.amt_bb * 5 and cash_blinds.amt_bb * 10) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_open_opp AND cash_hand_player_statistics.amt_p_effective_stack = cash_blinds.amt_bb * 55) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_open_opp AND cash_hand_player_statistics.amt_p_effective_stack BETWEEN cash_blinds.amt_bb * 5 and cash_blinds.amt_bb * 10) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.cnt_p_raise > 0 AND cash_hand_player_statistics.amt_p_effective_stack 0 AND cash_hand_player_statistics.amt_p_effective_stack BETWEEN cash_blinds.amt_bb * 10 and cash_blinds.amt_bb * 20) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.cnt_p_raise > 0 AND cash_hand_player_statistics.amt_p_effective_stack BETWEEN cash_blinds.amt_bb * 20 and cash_blinds.amt_bb * 35) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.cnt_p_raise > 0 AND cash_hand_player_statistics.amt_p_effective_stack BETWEEN cash_blinds.amt_bb * 35 and cash_blinds.amt_bb * 55) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.cnt_p_raise > 0 AND cash_hand_player_statistics.amt_p_effective_stack >= cash_blinds.amt_bb * 55) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.cnt_p_raise > 0 AND cash_hand_player_statistics.amt_p_effective_stack BETWEEN cash_blinds.amt_bb * 5 and cash_blinds.amt_bb * 10) then 1 else 0 end))), (sum((case when( lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND (cash_hand_player_statistics.amt_before > (cash_blinds.amt_bb + cash_hand_player_statistics.amt_ante)) AND (cash_hand_player_statistics.amt_p_raise_facing 0 OR cash_hand_player_statistics.flg_p_3bet_opp OR cash_hand_player_statistics.flg_p_4bet_opp) ) AND cash_hand_player_statistics.amt_p_effective_stack (cash_blinds.amt_bb + cash_hand_player_statistics.amt_ante)) AND (cash_hand_player_statistics.amt_p_raise_facing 0 OR cash_hand_player_statistics.flg_p_3bet_opp OR cash_hand_player_statistics.flg_p_4bet_opp) ) AND cash_hand_player_statistics.amt_p_effective_stack BETWEEN cash_blinds.amt_bb * 10 and cash_blinds.amt_bb * 20) then 1 else 0 end))), (sum((case when( lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND (cash_hand_player_statistics.amt_before > (cash_blinds.amt_bb + cash_hand_player_statistics.amt_ante)) AND (cash_hand_player_statistics.amt_p_raise_facing 0 OR cash_hand_player_statistics.flg_p_3bet_opp OR cash_hand_player_statistics.flg_p_4bet_opp) ) AND cash_hand_player_statistics.amt_p_effective_stack BETWEEN cash_blinds.amt_bb * 20 and cash_blinds.amt_bb * 35) then 1 else 0 end))), (sum((case