after the last update i cannot longer use Pokertracker because of sql errors appearing all over Pokertracker. When i enable debugging mode i can see such errors like:
- Code: Select all
2020/09/15 15:06:41.177 [00001]: [00003A6C][Query] Executing SQL (Thread): SELECT ic.position_type,(case when( ic.position_type=0) then 'SB' else (case when( ic.position_type=1) then 'BB' else (case when( ic.position_type=2) then 'EP' else (case when( ic.position_type=3) then 'MP' else (case when( ic.position_type=4) then 'CO' else 'BTN' end) end) end) end) end),sum(ic.amt_won_curr_conv),sum(ic.amt_won_inc_payout_curr_conv),sum(ic.amt_payout),sum(ic.cnt_hands),sum(ic.cnt_hands_won),sum(ic.amt_bb_won),sum(ic.amt_rake_attributed_curr_conv),sum(ic.amt_won) FROM (SELECT cash_cache.id_player,position_type,sum(amt_won_curr_conv) AS amt_won_curr_conv,sum(amt_won_inc_payout_curr_conv) AS amt_won_inc_payout_curr_conv,sum(amt_payout) AS amt_payout,sum(cnt_hands) AS cnt_hands,sum(cnt_hands_won) AS cnt_hands_won,sum(amt_bb_won) AS amt_bb_won,sum(amt_rake_attributed_curr_conv) AS amt_rake_attributed_curr_conv,sum(amt_won) AS amt_won FROM cash_cache WHERE cash_cache.id_player = (SELECT id_player FROM player WHERE player_name_search=E'hero' AND id_site='3200') AND ((cash_cache.id_gametype = 1)AND (cash_cache.id_gametype<>1 OR (cash_cache.id_limit IN (SELECT hlrl.id_limit FROM cash_limit hlrl WHERE (hlrl.flg_nlpl=false and (CASE WHEN hlrl.limit_currency='SEK' THEN (hlrl.amt_bb*0.15) ELSE (CASE WHEN hlrl.limit_currency='INR' THEN (hlrl.amt_bb*0.020) ELSE (CASE WHEN hlrl.limit_currency='CNY' THEN (hlrl.amt_bb*0.14) ELSE (CASE WHEN hlrl.limit_currency='XSC' THEN 0.0 ELSE (CASE WHEN hlrl.limit_currency='PLY' THEN 0.0 ELSE hlrl.amt_bb END) END) END) END)<=1.01) or (hlrl.flg_nlpl=true and (CASE WHEN hlrl.limit_currency='SEK' THEN (hlrl.amt_bb*0.15) ELSE (CASE WHEN hlrl.limit_currency='INR' THEN (hlrl.amt_bb*0.020) ELSE (CASE WHEN hlrl.limit_currency='CNY' THEN (hlrl.amt_bb*0.14) ELSE (CASE WHEN hlrl.limit_currency='XSC' THEN 0.0 ELSE (CASE WHEN hlrl.limit_currency='PLY' THEN 0.0 ELSE hlrl.amt_bb END) END) END) END)<=0.51))))) GROUP BY cash_cache.id_player,position_type) ic,player WHERE player.id_player=ic.id_player GROUP BY ic.position_type,(case when( ic.position_type=0) then 'SB' else (case when( ic.position_type=1) then 'BB' else (case when( ic.position_type=2) then 'EP' else (case when( ic.position_type=3) then 'MP' else (case when( ic.position_type=4) then 'CO' else 'BTN' end) end) end) end) end)
2020/09/15 15:06:41.177 [00000]: [00003A6C][PostgresConnection (Error)] Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: syntax error at or near ")" LINE 1: ...HEN 0.0 ELSE hlrl.amt_bb END) END) END) END)<=1.01) or (hlrl... ^ )
What can i do to fix this problem? Thanks for any help!