Reinstalled postgresql and PT4 but HUD errors exist...

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny

Reinstalled postgresql and PT4 but HUD errors exist...

Postby dutch81 » Mon Mar 12, 2018 9:56 am

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
 
Posts: 336
Joined: Wed May 29, 2013 12:33 pm

Re: Reinstalled postgresql and PT4 but HUD errors exist...

Postby dutch81 » Mon Mar 12, 2018 10:14 am

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.
dutch81
 
Posts: 336
Joined: Wed May 29, 2013 12:33 pm

Re: Reinstalled postgresql and PT4 but HUD errors exist...

Postby Flag_Hippo » Mon Mar 12, 2018 12:40 pm

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

Re: Reinstalled postgresql and PT4 but HUD errors exist...

Postby dutch81 » Mon Mar 12, 2018 3:36 pm

I appreciate the fast response. Thanks so much!
dutch81
 
Posts: 336
Joined: Wed May 29, 2013 12:33 pm


Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 10 guests

cron
highfalutin