Not importing any hands after update today

[hundenapf]

PT4 does not import any hands any more, neither on Desktop nor on Laptop, both run Postgres 9.0.17 and have worked flawlessly since the release of PT4 until after the update today. The database update went fine without a hitch on both machines and whenever I try importing any hands be it live or from HH in a directory the program just freezes.

[kraada]

Please restart PT4 using the logging enabled link on your Start Menu, reproduce this problem and then report it via our support system with the log file - that will help us figure out what is going on here and get it fixed for you. You can find that file by clicking File --> Show User Data Folder in the main PT4 window - the file we need is the text file called PokerTracker4 that is in that folder. We'll need to see what's going on in the log before we can advise you how to proceed.

[hundenapf]

ok here you go:
https://www.pokertracker.com/contact/ti ... _id=152192

please advise what to do, can I revert to any of the old versions? It worked all so great for so long and now nothing is working at all, all of a sudden.

[kraada]

Your cache is not complete. Please rebuild it via Database -> Database Management -> Housekeeping -> Rebuild Cache.

[hundenapf]

ok I did and it interrupted with a long error notice window woth font in red color. I was not able to copy it because everything was frozen

[hundenapf]

I have just now created a completely fresh database to try and see if that works, it produced other errors such this error from the import log after starting HUD and live import for every hand. Considering this is a completely fresh database something else has to be going on there except the cache of the old database, especially since various errors and freezes at different stages are happening on both my PCs with different installs and different as well as completely fresh databases:

09:14:06 pm: Error: PokerStars: Unable to import hand (#116450503253). Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: missing FROM-clause entry for table "cash_blinds" LINE 1: ...atistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_blind... ^ QUERY: SELECT cash_hand_player_statistics.id_player, cash_hand_player_statistics.id_gametype, cash_hand_player_statistics.id_limit, cash_hand_summary.cnt_players,((case when( lookup_positions.flg_sb) then 0 else (case when( lookup_positions.flg_bb) then 1 else (case when( lookup_positions.flg_ep) then 2 else (case when( lookup_positions.flg_mp) then 3 else (case when( lookup_positions.flg_co) then 4 else 5 end) end) end) end) end)), (cash_hand_player_statistics.flg_f_has_position), (cash_hand_player_statistics.flg_t_has_position), (cash_hand_player_statistics.flg_r_has_position), (CAST ( ((date_part('year', timezone('UTC', cash_hand_player_statistics.date_played + INTERVAL '-5 HOURS')) * 100) + (EXTRACT (WEEK FROM timezone('UTC', cash_hand_player_statistics.date_played + INTERVAL '-5 HOURS')))) AS integer )), (sum(cast( cash_hand_player_statistics.flg_f_saw and cash_hand_player_combinations.flg_f_fullhouse and ((cash_hand_summary.card_1 - 1) % 13 != (cash_hand_summary.card_2 - 1) % 13 or (cash_hand_summary.card_1 - 1) % 13 != (cash_hand_summary.card_3 - 1) % 13) as int)) ), (sum(cast( cash_hand_player_statistics.flg_f_saw and cash_hand_player_combinations.flg_f_fouroak as int)) ), (sum(cast( (cash_hand_player_statistics.flg_f_saw and cash_hand_player_combinations.flg_f_threeoak and cash_hand_player_combinations.id_f_hand_strength in (4, 5, 6)) as int))), (sum((case when( cash_hand_player_statistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_blinds.amt_bb ) <> 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb )) ELSE 0 END) <= 8) then 1 else 0 end))), (sum((case when( cash_hand_player_statistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_blinds.amt_bb ) <> 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb )) ELSE 0 END) BETWEEN 7 AND 13) then 1 else 0 end))), (sum((case when( cash_hand_player_statistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_blinds.amt_bb ) <> 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb )) ELSE 0 END) BETWEEN 12 AND 18) then 1 else 0 end))), (sum((case when( cash_hand_player_statistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_blinds.amt_bb ) <> 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb )) ELSE 0 END) BETWEEN 17 AND 30) then 1 else 0 end))), (sum((case when( cash_hand_player_statistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_blinds.amt_bb ) <> 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb )) ELSE 0 END) >= 30) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) <= 8) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 7 and 13) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 12 and 18) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 17 and 30) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) >= 30) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND cash_hand_player_statistics.flg_p_face_raise AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 7 and 13) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND cash_hand_player_statistics.flg_p_face_raise AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 12 and 18) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND cash_hand_player_statistics.flg_p_face_raise AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 17 and 30) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND cash_hand_player_statistics.flg_p_face_raise AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) >= 30) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF' AND (CASE WHEN ( cash_blinds.amt_bb ) <> 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb )) ELSE 0 END) <= 13) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF' AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 7 and 13) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF' AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 12 and 18) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF' AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 17 and 30) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF' AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) >= 30) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'CR%' AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 7 and 13) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'CR%' AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 12 and 18) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'CR%' AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 17 and 30) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'CR%' AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) >= 30) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) <= 13 AND cash_hand_player_statistics.flg_showdown AND (cash_hand_player_statistics.id_holecard <= 34 OR cash_hand_player_statistics.id_holecard BETWEEN 49 AND 53 OR cash_hand_player_statistics.id_holecard = 70 OR cash_hand_player_statistics.id_holecard = 89 OR cash_hand_player_statistics.id_holecard = 106 OR cash_hand_player_statistics.id_holecard = 121 OR cash_hand_player_statistics.id_holecard = 134 OR cash_hand_player_statistics.id_holecard = 145 OR cash_hand_player_statistics.id_holecard = 154 OR cash_hand_player_statistics.id_holecard = 161 OR cash_hand_player_statistics.id_holecard = 166 OR cash_hand_player_statistics.id_holecard = 169)) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) <= 13 AND cash_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_first_raise AND (CASE WHEN ( cash_blinds.amt_bb ) <> 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb )) ELSE 0 END) <= 8 AND NOT cash_hand_player_statistics.flg_p_open_opp) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_first_raise AND (CASE WHEN ( cash_blinds.amt_bb ) <> 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb )) ELSE 0 END) BETWEEN 7 AND 13 AND NOT cash_hand_player_statistics.flg_p_open_opp) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_first_raise AND (CASE WHEN ( cash_blinds.amt_bb ) <> 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb )) ELSE 0 END) BETWEEN 12 AND 18 AND NOT cash_hand_player_statistics.flg_p_open_opp) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_first_raise AND (CASE WHEN ( cash_blinds.amt_bb ) <> 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb )) ELSE 0 END) BETWEEN 17 AND 30 AND NOT cash_hand_player_statistics.flg_p_open_opp) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_first_raise AND (CASE WHEN ( cash_blinds.amt_bb ) <> 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb )) ELSE 0 END) >= 30 AND NOT cash_hand_player_statistics.flg_p_open_opp) then 1 else 0 end))) FROM cash_hand_player_statistics LEFT OUTER JOIN cash_hand_player_combinations ON cash_hand_player_statistics.id_hand = cash_hand_player_combinations.id_hand AND cash_hand_player_statistics.id_player = cash_hand_player_combinations.id_player, cash_hand_summary, lookup_actions lookup_actions_p, lookup_positions WHERE (cash_hand_summary.id_hand = cash_hand_player_statistics.id_hand AND cash_hand_summary.id_limit = cash_hand_player_statistics.id_limit) AND (lookup_actions_p.id_action=cash_hand_player_statistics.id_action_p) AND (lookup_positions."position"=cash_hand_player_statistics."position" AND lookup_positions.cnt_players=cash_hand_player_statistics.cnt_players_lookup_position) AND ((cash_hand_player_statistics.id_hand > id_hand_start)) GROUP BY cash_hand_player_statistics.id_player, cash_hand_player_statistics.id_gametype, cash_hand_player_statistics.id_limit, cash_hand_summary.cnt_players, ((case when( lookup_positions.flg_sb) then 0 else (case when( lookup_positions.flg_bb) then 1 else (case when( lookup_positions.flg_ep) then 2 else (case when( lookup_positions.flg_mp) then 3 else (case when( lookup_positions.flg_co) then 4 else 5 end) end) end) end) end)), (cash_hand_player_statistics.flg_f_has_position), (cash_hand_player_statistics.flg_t_has_position), (cash_hand_player_statistics.flg_r_has_position), (CAST ( ((date_part('year', timezone('UTC', cash_hand_player_statistics.date_played + INTERVAL '-5 HOURS')) * 100) + (EXTRACT (WEEK FROM timezone('UTC', cash_hand_player_statistics.date_played + INTERVAL '-5 HOURS')))) AS integer )) CONTEXT: PL/pgSQL function "update_cash_custom_cache" line 17 at FOR over SELECT rows )
09:14:06 pm: PokerStars: Hand Imported (#116450503253) from Riviera VI
09:14:13 pm: Error: PokerStars: Unable to import hand (#116450555397). Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: missing FROM-clause entry for table "cash_blinds" LINE 1: ...atistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_blind... ^ QUERY: SELECT cash_hand_player_statistics.id_player, cash_hand_player_statistics.id_gametype, cash_hand_player_statistics.id_limit, cash_hand_summary.cnt_players,((case when( lookup_positions.flg_sb) then 0 else (case when( lookup_positions.flg_bb) then 1 else (case when( lookup_positions.flg_ep) then 2 else (case when( lookup_positions.flg_mp) then 3 else (case when( lookup_positions.flg_co) then 4 else 5 end) end) end) end) end)), (cash_hand_player_statistics.flg_f_has_position), (cash_hand_player_statistics.flg_t_has_position), (cash_hand_player_statistics.flg_r_has_position), (CAST ( ((date_part('year', timezone('UTC', cash_hand_player_statistics.date_played + INTERVAL '-5 HOURS')) * 100) + (EXTRACT (WEEK FROM timezone('UTC', cash_hand_player_statistics.date_played + INTERVAL '-5 HOURS')))) AS integer )), (sum(cast( cash_hand_player_statistics.flg_f_saw and cash_hand_player_combinations.flg_f_fullhouse and ((cash_hand_summary.card_1 - 1) % 13 != (cash_hand_summary.card_2 - 1) % 13 or (cash_hand_summary.card_1 - 1) % 13 != (cash_hand_summary.card_3 - 1) % 13) as int)) ), (sum(cast( cash_hand_player_statistics.flg_f_saw and cash_hand_player_combinations.flg_f_fouroak as int)) ), (sum(cast( (cash_hand_player_statistics.flg_f_saw and cash_hand_player_combinations.flg_f_threeoak and cash_hand_player_combinations.id_f_hand_strength in (4, 5, 6)) as int))), (sum((case when( cash_hand_player_statistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_blinds.amt_bb ) <> 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb )) ELSE 0 END) <= 8) then 1 else 0 end))), (sum((case when( cash_hand_player_statistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_blinds.amt_bb ) <> 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb )) ELSE 0 END) BETWEEN 7 AND 13) then 1 else 0 end))), (sum((case when( cash_hand_player_statistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_blinds.amt_bb ) <> 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb )) ELSE 0 END) BETWEEN 12 AND 18) then 1 else 0 end))), (sum((case when( cash_hand_player_statistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_blinds.amt_bb ) <> 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb )) ELSE 0 END) BETWEEN 17 AND 30) then 1 else 0 end))), (sum((case when( cash_hand_player_statistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_blinds.amt_bb ) <> 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb )) ELSE 0 END) >= 30) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) <= 8) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 7 and 13) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 12 and 18) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 17 and 30) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) >= 30) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND cash_hand_player_statistics.flg_p_face_raise AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 7 and 13) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND cash_hand_player_statistics.flg_p_face_raise AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 12 and 18) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND cash_hand_player_statistics.flg_p_face_raise AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 17 and 30) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND cash_hand_player_statistics.flg_p_face_raise AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) >= 30) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF' AND (CASE WHEN ( cash_blinds.amt_bb ) <> 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb )) ELSE 0 END) <= 13) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF' AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 7 and 13) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF' AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 12 and 18) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF' AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 17 and 30) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF' AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) >= 30) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'CR%' AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 7 and 13) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'CR%' AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 12 and 18) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'CR%' AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) BETWEEN 17 and 30) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'CR%' AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) >= 30) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) <= 13 AND cash_hand_player_statistics.flg_showdown AND (cash_hand_player_statistics.id_holecard <= 34 OR cash_hand_player_statistics.id_holecard BETWEEN 49 AND 53 OR cash_hand_player_statistics.id_holecard = 70 OR cash_hand_player_statistics.id_holecard = 89 OR cash_hand_player_statistics.id_holecard = 106 OR cash_hand_player_statistics.id_holecard = 121 OR cash_hand_player_statistics.id_holecard = 134 OR cash_hand_player_statistics.id_holecard = 145 OR cash_hand_player_statistics.id_holecard = 154 OR cash_hand_player_statistics.id_holecard = 161 OR cash_hand_player_statistics.id_holecard = 166 OR cash_hand_player_statistics.id_holecard = 169)) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND ( (CASE WHEN ( cash_blinds.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/(

[kraada]

You have some improper columns set to cache that use a database field that does not exist. Locate and edit whatever columns you have that use "cash_blinds" -- it simply isn't in our database. From the snippet you pasted, I believe you want "cash_limit" instead -- that's where amt_bb and amt_sb reside.

[hundenapf]

I´m sorry but I do not understand at all what that means. As I said this is a completely fresh database install.

[kraada]

You have custom columns in the Configure -> Statistics -> Columns area that use "cash_blinds" which does not exist. You need to locate and edit those to use "cash_limit" instead.

If you don't need any custom statistics and are willing to remove them all you can click File -> Show User Data Folder and go into Data and remove the StatsDefinitionsCustomized.pt4 file and restart PT4 and then the cache rebuild should complete.

[hundenapf]

These advice and the new update release have worked, the problems seem to be gone again now, thanks for the help with this.
Next time please check for problems before releasing an update, this was quite an irritating experience which reminded me of why I switched from Holdem Manager to Pokertracker some years ago