New Release: 4.01.22 BETA

[ooRSZABOoo]

After install the new update when i click "Get hands while playing" on PT4 it occurs an error on Pokerstars saying "PokerStars GUI DOENST WORK" and the pokerstars just close, can someone help me with that?

[kraada]

This is a known issue with Zoom in the latest beta - if you turn off Enable Zoom Hud in the PokerStars Configuration area things will work properly.

We are going to be releasing a fix later today for this issue and we apologize for any inconvenience that this may have caused.

[trylobit]

I wanted to update my database, but it ended up like this:


Error updating database: MAIN_PT4
Error:
Unable to execute query: INSERT INTO temp_cash_hand_player_statistics ( SELECT id_hand, id_gametype, id_player, id_player_real, id_holecard, id_limit, id_session, date_played, position, cnt_players, cnt_players_lookup_position, cnt_p_raise, flg_p_first_raise, cnt_p_call, flg_p_limp, flg_p_fold, flg_p_ccall, cnt_p_face_limpers, flg_vpip, flg_f_bet, cnt_f_raise, flg_f_first_raise, cnt_f_call, flg_f_check, flg_f_check_raise, flg_f_fold, flg_f_saw, flg_t_bet, cnt_t_raise, flg_t_first_raise, cnt_t_call, flg_t_check, flg_t_check_raise, flg_t_fold, flg_t_saw, flg_r_bet, cnt_r_raise, flg_r_first_raise, cnt_r_call, flg_r_check, flg_r_check_raise, flg_r_fold, flg_r_saw, enum_allin, enum_face_allin, enum_face_allin_action, flg_blind_s, flg_blind_b, flg_blind_ds, flg_blind_db, flg_sb_steal_fold, flg_bb_steal_fold, flg_blind_def_opp, flg_steal_att, flg_steal_opp, flg_blind_k, flg_showdown, flg_won_hand, amt_won, amt_expected_won, val_equity, id_final_hand, id_final_hand_lo, flg_showed, enum_folded, flg_p_face_raise, flg_p_3bet, flg_p_3bet_opp, flg_p_3bet_def_opp, enum_p_3bet_action, flg_p_4bet, flg_p_4bet_opp, flg_p_4bet_def_opp, enum_p_4bet_action, flg_p_squeeze, flg_p_squeeze_opp, flg_p_squeeze_def_opp, enum_p_squeeze_action, flg_f_face_raise, flg_f_3bet, flg_f_3bet_opp, flg_f_3bet_def_opp, enum_f_3bet_action, flg_f_4bet, flg_f_4bet_opp, flg_f_4bet_def_opp, enum_f_4bet_action, flg_f_cbet, flg_f_cbet_opp, flg_f_cbet_def_opp, enum_f_cbet_action, flg_t_face_raise, flg_t_3bet, flg_t_3bet_opp, flg_t_3bet_def_opp, enum_t_3bet_action, flg_t_4bet, flg_t_4bet_opp, flg_t_4bet_def_opp, enum_t_4bet_action, flg_t_cbet, flg_t_cbet_opp, flg_t_cbet_def_opp, enum_t_cbet_action, flg_t_float, flg_t_float_opp, flg_t_float_def_opp, enum_t_float_action, flg_t_donk, flg_t_donk_opp, flg_t_donk_def_opp, enum_t_donk_action, flg_r_face_raise, flg_r_3bet, flg_r_3bet_opp, flg_r_3bet_def_opp, enum_r_3bet_action, flg_r_4bet, flg_r_4bet_opp, flg_r_4bet_def_opp, enum_r_4bet_action, flg_r_cbet, flg_r_cbet_opp, flg_r_cbet_def_opp, enum_r_cbet_action, flg_r_float, flg_r_float_opp, flg_r_float_def_opp, enum_r_float_action, flg_r_donk, flg_r_donk_opp, flg_r_donk_def_opp, enum_r_donk_action, val_curr_conv, seat, holecard_1, holecard_2, holecard_3, holecard_4, id_suits, flg_hero, amt_before, amt_blind, amt_ante, amt_bet_p, amt_bet_f, amt_bet_t, amt_bet_r, amt_bet_ttl, id_action_p, id_action_f, id_action_t, id_action_r, flg_p_open, flg_p_open_opp, flg_f_first, flg_f_open, flg_f_open_opp, flg_f_has_position, flg_t_first, flg_t_open, flg_t_open_opp, flg_t_has_position, flg_r_first, flg_r_open, flg_r_open_opp, flg_r_has_position, -1, -1, -1, -1, amt_p_raise_facing, val_p_raise_facing_pct, amt_p_2bet_facing, val_p_2bet_facing_pct, amt_p_3bet_facing, val_p_3bet_facing_pct, amt_p_4bet_facing, val_p_4bet_facing_pct, amt_p_5bet_facing, val_p_5bet_facing_pct, val_p_raise_aggressor_pos, amt_p_raise_made, val_p_raise_made_pct, amt_p_raise_made_2, val_p_raise_made_2_pct, amt_f_bet_facing, val_f_bet_facing_pct, val_f_bet_aggressor_pos, amt_f_bet_made, val_f_bet_made_pct, amt_f_raise_facing, val_f_raise_facing_pct, amt_f_2bet_facing, val_f_2bet_facing_pct, amt_f_3bet_facing, val_f_3bet_facing_pct, amt_f_4bet_facing, val_f_4bet_facing_pct, val_f_raise_aggressor_pos, amt_f_raise_made, val_f_raise_made_pct, amt_f_raise_made_2, val_f_raise_made_2_pct, amt_t_bet_facing, val_t_bet_facing_pct, val_t_bet_aggressor_pos, amt_t_bet_made, val_t_bet_made_pct, amt_t_raise_facing, val_t_raise_facing_pct, amt_t_2bet_facing, val_t_2bet_facing_pct, amt_t_3bet_facing, val_t_3bet_facing_pct, amt_t_4bet_facing, val_t_4bet_facing_pct, val_t_raise_aggressor_pos, amt_t_raise_made, val_t_raise_made_pct, amt_t_raise_made_2, val_t_raise_made_2_pct, amt_r_bet_facing, val_r_bet_facing_pct, val_r_bet_aggressor_pos, amt_r_bet_made, val_r_bet_made_pct, amt_r_raise_facing, val_r_raise_facing_pct, amt_r_2bet_facing, val_r_2bet_facing_pct, amt_r_3bet_facing, val_r_3bet_facing_pct, amt_r_4bet_facing, val_r_4bet_facing_pct, val_r_raise_aggressor_pos, amt_r_raise_made, val_r_raise_made_pct, amt_r_raise_made_2, val_r_raise_made_2_pct FROM cash_hand_player_statistics);; Reason: Fatal Error (ERROR: null value in column "id_hand" violates not-null constraint )

[kraada]

That error implies corruption in your database - the easiest fix will be to export and reimport your hands. How large is this database?

[oracle3001]

Hands abbr is not working properly now. It is simply displaying hands in full form

[trylobit]

That error implies corruption in your database - the easiest fix will be to export and reimport your hands. How large is this database?

I've just dropped my hands just like after getting a bad beat when I read this.
I have about 4,3M hands importing took 2 days...

Is this the only option?

[kraada]

We're aware of the hands abbreviated issue and will get that fixed.

The problem is that somewhere in your database you have a null value for a data field (id_hand) that is always specified to be NOT NULL in the database schema.

At least for that row you definitely have bad data which PostgreSQL should never have allowed to exist (no matter what PT4 tried to insert, in fact). As a result, even if we eliminated whatever rows had the invalid data we don't know what caused the problem or whether there is corruption elsewhere.

Reimporting your hands may be painful but it is the safest option - it will ensure you have internally consistent data.

[trylobit]

OK guys...
I am waiting for the final Mac version. For now I am going back to HM.

Can't wait to see PT4 on Mac.

Best of luck!

[trylobit]

Even if I want to reimport all the hands. I've got only processed files of last month or so, as earlier I was using HM.
How am I suppose to import those hands???

[WhiteRider]

PT4 has an option to convert hands from your HM/HM2 databases. HM should have archived the original hand histories as well so unless you deleted the files you probably still have all of the originals for your older hands too.