Error hand import

A special forum dedicated to our PT4 for Mac OS X users

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Error hand import

Postby woodshipper » Fri Sep 16, 2016 4:06 pm

For every hand I import I get 2 errors. When I try to import handhistory files with a lot of hands importing goes very slow and PT4 Freezes at some point.

This is the error I get: 03:52:21 pm: Winamax: Starting auto-import.
03:52:21 pm: Winamax: Found 1 files to monitor.
03:52:21 pm: Winamax: Loading hand history file: /Users/dawood_dawood/Documents/Winamax Poker/accounts/Woodshipper1/history/20160916_York 02_real_omaha_pot-limit.txt
03:52:28 pm: Error: Winamax: Unable to import hand (#9091332000619). 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(lookup_actions_p.action LIKE '%C' AND chps.flg_f_bet AND NOT (chps.flg_f_cbet_opp) AND NOT(chps.flg_f_has_position) AND chs.cnt_players_f = 2 AND char_length(chs.str_aggressors_p) = 2 ) then 1 else 0 end))), (sum((case when(lookup_actions_p.action LIKE '%C' AND chps.flg_f_bet AND NOT (chps.flg_f_cbet_opp) AND chps.val_p_raise_aggressor_pos < chps.position AND chs.cnt_players_f >= 3 AND char_length(chs.str_aggressors_p) = 2 ) then 1 else 0 end))), (sum((case when(lookup_actions_p.action LIKE '%C' AND chps.flg_f_open_opp AND NOT (chps.flg_f_cbet_opp) AND NOT(chps.flg_f_has_position) AND chs.cnt_players_f = 2 AND char_length(chs.str_aggressors_p) = 2 ) then 1 else 0 end))), (sum((case when(lookup_actions_p.action LIKE '%C' AND chps.flg_f_open_opp AND NOT (chps.flg_f_cbet_opp) AND chps.val_p_raise_aggressor_pos < chps.position AND chs.cnt_players_f >= 3 AND char_length(chs.str_aggressors_p) = 2 ) then 1 else 0 end))), (sum(case when chps.val_equity > 0 and (chps.enum_allin = 'F' or (chps.enum_face_allin ilike 'F' and ......

what can I do to solve this problem?
woodshipper
 
Posts: 4
Joined: Tue Sep 13, 2016 4:27 pm

Re: Error hand import

Postby Flag_Hippo » Mon Sep 19, 2016 6:06 am

This 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 disable your Premium HUD by disabling "Configure -> Options -> Download Premium Content" and then restarting PokerTracker 4.
Flag_Hippo
Moderator
 
Posts: 15201
Joined: Tue Jan 31, 2012 7:50 am


Return to PT4 for macOS

Who is online

Users browsing this forum: No registered users and 10 guests

cron