after update to 4.11 PT4 doesn't work

[musashi87]

you guys are awesome, how you have managed to fix all of this and still answered all our questions here is insane...
import, hud & cache rebuild working fine...
I do however keep on getting an error when I try to set my old db to default --> invalid database.

just highlight this database and rebuild cache after that you can easily set it as default

[Felllony]

Got this after rebuild cache for 4.11.6
What should I do?

Downgraded back to 4.11.5. Waiting for answer. Ticket #152910

[Ypsi]

hello,

cant rebuild cache too

Code: Select all

Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: missing FROM-clause entry for table "cash_blinds" LINE 1: ..._player_statistics.id_hand > 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 '0 HOURS')) * 100) + (EXTRACT (WEEK FROM timezone('UTC', cash_hand_player_statistics.date_played + INTERVAL '0 HOURS')))) AS integer )), (sum((case when(cash_hand_player_statistics.id_hand > 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) ) 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 10.5 AND 15.49) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.id_hand > 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 15.5 AND 20.49) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.id_hand > 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 20.5 AND 25) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.amt_p_2bet_facing > 0) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_3bet_def_opp AND cash_hand_player_statistics.flg_p_4bet_opp) then 1 else 0 end))), (sum((case when( cash_hand_player_statistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_limit.amt_bb ) 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_limit.amt_bb )) ELSE 0 END) BETWEEN 7 AND 10) then 1 else 0 end))), (sum((case when( cash_hand_player_statistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_limit.amt_bb ) 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_limit.amt_bb )) ELSE 0 END) BETWEEN 10 AND 13) then 1 else 0 end))), (sum((case when( cash_hand_player_statistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_limit.amt_bb ) 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_limit.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_limit.amt_bb ) 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_limit.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_limit.amt_bb ) 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_limit.amt_bb )) ELSE 0 END) 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) 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 10.5 AND 15.49) then 1 else 0 end))), (sum((case when( cash_hand_player_statistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_limit.amt_bb ) 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_limit.amt_bb )) ELSE 0 END) >= 150) 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 15.5 AND 20.49) 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 20.5 AND 25) then 1 else 0 end))), (sum((case when( cash_hand_player_statistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_limit.amt_bb ) 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_limit.amt_bb )) ELSE 0 END) >= 30) then 1 else 0 end))), (sum((case when( cash_hand_player_statistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_limit.amt_bb ) 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_limit.amt_bb )) ELSE 0 END) BETWEEN 30 AND 50) then 1 else 0 end))), (sum((case when( cash_hand_player_statistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_limit.amt_bb ) 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_limit.amt_bb )) ELSE 0 END) BETWEEN 50 AND 80) then 1 else 0 end))), (sum((case when( cash_hand_player_statistics.cnt_p_face_limpers > 0 AND (CASE WHEN ( cash_limit.amt_bb ) 0 THEN (( cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_limit.amt_bb )) ELSE 0 END) BETWEEN 80 AND 150) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND ( (CASE WHEN ( cash_limit.amt_bb) 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_limit.amt_bb)) ELSE 0 END) ) 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_blinds.amt_bb)) ELSE 0 END) ) 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_limit.amt_bb)) ELSE 0 END) ) BETWEEN 7 and 10) then 1 else 0 end))), (sum((case when(cash_hand_player_statistics.flg_p_limp AND ( (CASE WHEN ( cash_limit.amt_bb) 0 THEN ((cash_hand_player_statistics.amt_p_effective_stack * 1.0 )/( cash_limit.amt_bb))

ticket #152913

[kraada]

You have a column that references a cash_blinds table that does not exist. You'll need to track down that custom column and either set it to not cache or fix it to properly reference cash_limit (which contains the blinds information for cash games).

[BillGatesIII]

You have a column that references a cash_blinds table that does not exist. You'll need to track down that custom column and either set it to not cache or fix it to properly reference cash_limit (which contains the blinds information for cash games).

I respectfully disagree. There is a bug in the custom_cache update functions which causes an error for every column that has a construction like this example.

Code: Select all

cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb between 2.75 and 3.24

If you rewrite the code, the column can be cached.

Code: Select all

cash_hand_player_statistics.amt_p_raise_made between 2.75 * cash_limit.amt_bb and 3.24 * cash_limit.amt_bb

You can see in the log where PT4 makes the error.

Code: Select all

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

This should be.

Code: Select all

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

The (cash_blinds.amt_bb) <> 0 part is automatically added by PT4 to prevent divided by zero errors. In this case, the <> is missing, hence the custom cache update fails.

[kraada]

Can you please attach the stat to a support ticket and either post your ticket number here or PM it to me? I'll see what I can do about getting a fix expedited.

You did change terminology in your post though: notice you started talking about cash_limit.amt_bb and ended talking about cash_blinds.amt_bb. If what you say about our parsing is correct (and I have no doubt you're right) we want to fix that for sure. But there's still no cash_blinds table

Edit to add: Adding parentheses might also fix this -- does

Code: Select all

(cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb) between 2.75 and 3.24

work better for you?

[BillGatesIII]

First, I need another coffee to open my eyes so I can read instead of just look at error messages You are of course right, cash_blinds does not exist. Which makes me wonder how someone did get it in a cash column expression.

Second, I cannot reproduce the parsing error in 4.11.6 (and don't have a 4.11.1 install anymore) so that also seems ok.

[kraada]

No worries! I know the feeling

[Ypsi]

You have a column that references a cash_blinds table that does not exist. You'll need to track down that custom column and either set it to not cache or fix it to properly reference cash_limit (which contains the blinds information for cash games).

thanks, i deleted the columns, now it works

[themightyjim2k]

so I hadn't updated since the initial 4.11 since I was able to get it working after some cache rebuilding. But I have some time this evening and decided to update to 4.11v6. downloaded update, installed, it said I needed to update cache after which I would need to do a full rebuild. I clicked ok. and I got this error:



"Error verifying cache table indexes on database: 2013_03_28_DB1

Error:
Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: operator does not exist: integer = text LINE 1: ...e WHERE id_player =$1 AND date_played_year_week in ($2) ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. QUERY: DELETE FROM cash_cache WHERE id_player = $1 AND date+played_year_week in ($2) CONTEXT: PL/pgSQL function "update_cash_cache_date" line 8 at SQL statement)

help?

Please open a Support Ticket and attach the full log file and we'll work with you to find out what is going on here.

As a test, if you create a new database and import a few hands, can you rebuild the cache of the new database?
If not, please make a Backup of just the default Optional Files and attach that to your ticket too so that we can experiment with your files.

I misread your post originally. Please go to Database > Database Management and click Rebuild Cache > Full Cache Rebuild and that should correct it.

I actually did just that on my own last night thinking it might fix the problem (first I did the revert tuning, and then tuning) and the rebuild went fine. I played a short session last night without problem. I really didn't experience as many problems as other users, but import times are probably less of an issue for me since I rarely play more than 12 tables.