SQL Error after 4.15.24 update

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny

SQL Error after 4.15.24 update

Postby subhead » Tue Sep 15, 2020 9:14 am

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!
subhead
 
Posts: 5
Joined: Wed Jan 30, 2008 5:48 pm

Re: SQL Error after 4.15.24 update

Postby rivader » Tue Sep 15, 2020 9:35 am

I think i have the same error since last update (4.15.24)
All tabs using my datas are KO.
Attachments
screenshot.JPG
rivader
 
Posts: 2
Joined: Fri Jul 24, 2020 7:17 am

Re: SQL Error after 4.15.24 update

Postby apple_fresh » Tue Sep 15, 2020 11:52 am

Same problem.
apple_fresh
 
Posts: 5
Joined: Sat Aug 15, 2009 6:33 pm
Location: Moscow, Russia

Re: SQL Error after 4.15.24 update

Postby Flag_Hippo » Tue Sep 15, 2020 12:12 pm

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
Moderator
 
Posts: 9725
Joined: Tue Jan 31, 2012 7:50 am

Re: SQL Error after 4.15.24 update

Postby xicaitz » Tue Sep 15, 2020 1:18 pm

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
xicaitz
 
Posts: 1
Joined: Fri Jan 10, 2014 12:09 am

Re: SQL Error after 4.15.24 update

Postby 1testicle » Tue Sep 15, 2020 1:35 pm

i have the same issue, and it will not let me download the previous version.
1testicle
 
Posts: 3
Joined: Tue Sep 15, 2020 1:11 pm

Re: SQL Error after 4.15.24 update

Postby rivader » Tue Sep 15, 2020 1:50 pm

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.
rivader
 
Posts: 2
Joined: Fri Jul 24, 2020 7:17 am

Re: SQL Error after 4.15.24 update

Postby 1testicle » Tue Sep 15, 2020 2:00 pm

when i try to download 4.15.23 i get "error opening file for writing"
1testicle
 
Posts: 3
Joined: Tue Sep 15, 2020 1:11 pm

Re: SQL Error after 4.15.24 update

Postby swrillive » Tue Sep 15, 2020 2:26 pm

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 ;)
swrillive
 
Posts: 1
Joined: Mon Feb 07, 2011 5:59 pm

Re: SQL Error after 4.15.24 update

Postby 1testicle » Tue Sep 15, 2020 3:27 pm

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
1testicle
 
Posts: 3
Joined: Tue Sep 15, 2020 1:11 pm

Next

Return to PokerTracker 4

Who is online

Users browsing this forum: Google [Bot] and 13 guests

cron
highfalutin