Page 1 of 2

SQL Error after 4.15.24 update

PostPosted: Tue Sep 15, 2020 9:14 am
by subhead
Hello,
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!

Re: SQL Error after 4.15.24 update

PostPosted: Tue Sep 15, 2020 9:35 am
by rivader
I think i have the same error since last update (4.15.24)
All tabs using my datas are KO.

Re: SQL Error after 4.15.24 update

PostPosted: Tue Sep 15, 2020 11:52 am
by apple_fresh
Same problem.

Re: SQL Error after 4.15.24 update

PostPosted: Tue Sep 15, 2020 12:12 pm
by Flag_Hippo
Unfortunately there is an issue with the PokerTracker 4.15.24 release if you have a Small Stakes license. It is being investigated so in the meantime can anybody affected please revert to PokerTracker v4.15.23.

Re: SQL Error after 4.15.24 update

PostPosted: Tue Sep 15, 2020 1:18 pm
by xicaitz
Flag_Hippo wrote:Unfortunately there is an issue with the PokerTracker 4.15.24 release if you have a Small Stakes license. It is being investigated so in the meantime can anybody affected please revert to PokerTracker v4.15.23.

Flag_Hippo can you please send the .dmg link?(Already Solved)

Thank you

Re: SQL Error after 4.15.24 update

PostPosted: Tue Sep 15, 2020 1:35 pm
by 1testicle
i have the same issue, and it will not let me download the previous version.

Re: SQL Error after 4.15.24 update

PostPosted: Tue Sep 15, 2020 1:50 pm
by rivader
Flag_Hippo wrote:Unfortunately there is an issue with the PokerTracker 4.15.24 release if you have a Small Stakes license. It is being investigated so in the meantime can anybody affected please revert to PokerTracker v4.15.23.


Ok done. It works with v4.15.23.
https://www.ptrackupdate.com/releases/PT-Install-v4.15.23.exe

Please tell when the next version is fixed.

Re: SQL Error after 4.15.24 update

PostPosted: Tue Sep 15, 2020 2:00 pm
by 1testicle
when i try to download 4.15.23 i get "error opening file for writing"

Re: SQL Error after 4.15.24 update

PostPosted: Tue Sep 15, 2020 2:26 pm
by swrillive
1testicle wrote:when i try to download 4.15.23 i get "error opening file for writing"


Just had the same error, you have to close pokertracker before trying to install the previous version ;)

Re: SQL Error after 4.15.24 update

PostPosted: Tue Sep 15, 2020 3:27 pm
by 1testicle
swrillive wrote:
1testicle wrote:when i try to download 4.15.23 i get "error opening file for writing"


Just had the same error, you have to close pokertracker before trying to install the previous version ;)

top man thank you

highfalutin