Reinstalled postgresql and PT4 but HUD errors exist...

[dutch81]

When I ran a test in a cash game to see if all was OK, I see this error message after every hand:

Error: iPoker: Unable to import hand (#3578760406). Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: schema "pph" does not exist CONTEXT: SQL statement "SELECT chps.id_player, chps.id_gametype, chps.id_limit, chs.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)), (chps.flg_f_has_position), (chps.flg_t_has_position), (chps.flg_r_has_position), (CAST ( ((date_part('year', timezone('UTC', chps.date_played + INTERVAL '0 HOURS')) * 100) + (EXTRACT (WEEK FROM timezone('UTC', chps.date_played + INTERVAL '0 HOURS')))) AS integer )), (sum((case when(chps.flg_f_cbet AND chps.flg_f_3bet AND chps.flg_steal_att AND chps.position = 9 AND char_length(chs.str_aggressors_p) = 2 ) then 1 else 0 end))), (sum((case when(chps.flg_f_cbet AND chps.flg_f_3bet AND chs.str_aggressors_p = '808' AND chs.str_actors_p = '080' AND chps.position = 8 ) then 1 else 0 end))), (sum((case when(chps.flg_f_cbet AND chps.flg_f_3bet AND chs.str_aggressors_p = '809' AND chs.str_actors_p = '090' AND chps.position = 9 ) then 1 else 0 end))), (sum((case when(chps.flg_f_cbet AND chps.flg_f_3bet AND chs.cnt_players_f = 2 AND char_length(chs.str_aggressors_p) = 2 AND NOT(chps.flg_f_has_position) AND chps.position <= 3 ) then 1 else 0 end))), (sum((case when(chps.flg_f_cbet AND chps.flg_f_face_raise AND chps.amt_f_bet_facing < chps.amt_f_effective_stack AND chps.flg_steal_att AND chps.position = 9 AND char_length(chs.str_aggressors_p) = 2 ) then 1 else 0 end))), (sum((case when(chps.flg_f_cbet AND chps.flg_f_face_raise AND chps.amt_f_bet_facing < chps.amt_f_effective_stack AND chs.str_aggressors_p = '808' AND chs.str_actors_p = '080' AND chps.position = 8 ) then 1 else 0 end))), (sum((case when(chps.flg_f_cbet AND chps.flg_f_face_raise AND chps.amt_f_bet_facing < chps.amt_f_effective_stack AND chs.str_aggressors_p = '809' AND chs.str_actors_p = '090' AND chps.position = 9 ) then 1 else 0 end))), (sum((case when(chps.flg_f_cbet AND chps.flg_f_face_raise AND chps.amt_f_bet_facing < chps.amt_f_effective_stack AND chs.cnt_players_f = 2 AND char_length(chs.str_aggressors_p) = 2 AND NOT(chps.flg_f_has_position) AND chps.position <= 3 ) then 1 else 0 end))), (sum((case when(chps.flg_f_cbet AND chs.str_aggressors_p = '80' AND chs.str_actors_p = '08' AND chps.position = 0 ) then 1 else 0 end))), (sum((case when(chps.flg_f_cbet AND chps.flg_steal_att AND chps.position = 9 AND char_length(chs.str_aggressors_p) = 2 ) then 1 else 0 end))), (sum((case when(chps.flg_f_cbet AND lookup_actions_f.action LIKE 'BR%' AND char_length(chs.str_aggressors_p) = 3 AND chs.cnt_players_f = 2 ) then 1 else 0 end))), (sum((case when(chps.flg_f_cbet AND chs.str_aggressors_p = '808' AND chs.str_actors_p = '080' AND chps.position = 8 ) then 1 else 0 end))), (sum((case when(chps.flg_f_cbet AND chs.str_aggressors_p = '809' AND chs.str_actors_p = '090' AND chps.position = 9 ) then 1 else 0 end))), (sum((case when(chps.flg_f_cbet AND lookup_actions_f.action = 'BC' AND chps.flg_steal_att AND chps.position = 9 AND char_length(chs.str_aggressors_p) = 2 ) then 1 else 0 end))), (sum((case when(chps.flg_f_cbet AND lookup_actions_f.action = 'BC' AND chs.str_aggressors_p = '808' AND chs.str_actors_p = '080' AND chps.position = 8 ) then 1 else 0 end))), (sum((case when(chps.flg_f_cbet AND lookup_actions_f.action = 'BC' AND chs.str_aggressors_p = '809' AND chs.str_actors_p = '090' AND chps.position = 9 ) then 1 else 0 end))), (sum((case when(chps.flg_f_cbet AND lookup_actions_f.action = 'BC' AND chs.cnt_players_f = 2 AND char_length(chs.str_aggressors_p) = 2 AND NOT(chps.flg_f_has_position) AND chps.position <= 3 ) then 1 else 0 end))), (sum((case when(chps.flg_f_cbet AND lookup_actions_f.action LIKE 'BC%' AND chs.cnt_players_f = 2 AND char_length(chs.str_aggressors_p) = 3 ) then 1 else 0 end))), (sum((case when(chps.flg_f_cbet AND lookup_actions_f.action LIKE 'BC%' AND chs.cnt_players_f >= 3 AND char_length(chs.str_aggressors_p) = 2 AND NOT(chps.flg_f_has_position) AND chps.position <= 3 ) then 1 else 0 end))), (sum((case when(chps.enum_f_cbet_action = 'C' AND chs.str_aggressors_p = '80' AND chs.str_actors_p = '08' AND chps.position = 8 ) then 1 else 0 end))), (sum((case when(chps.enum_f_cbet_action = 'C' AND chs.str_aggressors_p = '89' AND chs.str_actors_p = '98' AND chps.position = 8 ) then 1 else 0 end))), (sum((case when(chps.enum_f_cbet_action='C' AND chs.str_aggressors_p = '808' AND chs.str_actors_p = '080' AND chps.position = 0 ) then 1 else 0 end))), (sum((case when(chps.enum_f_cbet_action='C' AND chs.str_aggressors_p = '809' AND chs.str_actors_p = '090' AND chps.position = 0 ) then 1 else 0 end))), (sum((case when(chps.enum_f_cbet_action='C' AND chs.cnt_players_f = 2 AND char_length(chs.str_aggressors_p) = 2 AND chps.flg_f_has_position AND chps.position < 8 ) then 1 else 0 end))), (sum((case when(chps.enum_f_cbet_action='C' AND chs.cnt_players_f = 2 AND char_length(chs.str_aggressors_p) = 2 AND NOT(chps.flg_f_has_position) AND chps.val_p_raise_aggressor_pos > 0 ) then 1 else 0 end))), (sum((case when(chps.enum_f_cbet_action = 'C' AND chs.cnt_players_f = 2 AND char_length(chs.str_aggressors_p) = 3 ) then 1 else 0 end))), (sum((case when(chs.cnt_players > 2 AND chps.position=9 AND chs.str_aggressors_p = '898' AND chs.str_actors_p = '989' AND chps.enum_f_cbet_action='C' AND chs.cnt_players_f = 2 ) then 1 else 0 end))), (sum((case when

This is shown under "view import status" and "status" after I click "get hands while playing".

Can someone please advise? I created a new database and don't have a need for the existing anymore.

[dutch81]

I just tested it on a HU SNG and it works fine after 5 hands. Every hand imports with no errors and quickly as well. I'm guessing this is a cash profile issue and not something that will affect MTT's but I could be wrong. I am mostly a MTT player but would like to get this resolved.

[Flag_Hippo]

That error means you have statistics which use additional tables which need to be added to the database outside of PokerTracker 4. You will need to contact support@propokerhuds.com to find out what you need to do to your database for those stats to work. In the meantime you can also turn off your Premium HUD by disabling the "Configure -> Options -> Download Premium Content" option and then restarting PokerTracker 4.

[dutch81]

I appreciate the fast response. Thanks so much!