Starting hands

[TonyB73]

I'm sorry if this has been raised before - I have looked through the forum and haven't found it.

Under the "Hands" tab, the "Starting Hands" display produces a long, 15-line error starting with: "Unable to execute query: ...". The "Final Hands" display seems to work fine.

I am using Beta 20, but this has been a problem for several versions now (I just haven't gotten around to raising it).

Help?

[kraada]

Could you please enable logging (Configure --> Options --> Logging Enabled needs to be checked, then restart PT3) and reload that report, then look at the log file (C:\Program Files\PokerTracker 3\PokerTracker.log) and give me the full text of the error message? Once I have a better idea why it can't execute the query I should be able to help you find a way to get around it; this isn't a problem for everybody.

[TonyB73]

Thanks for the response.

FYI, I just got a similar problem on the General tab, where the bottom display (Player Statistics) came up with a similar error. Never seen it there before.

Here is the full text of the original error:

2008/11/08 13:43:44.948: [00001028][PostgresConnection (Error)] Unable to execute query: SELECT (holdem_hand_player_statistics.id_holecard) as "id_holecard", (count(holdem_hand_player_statistics.id_hand)) as "cnt_hands", (sum((case when(holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) as "cnt_won_hand", (sum(holdem_hand_player_statistics.amt_won)) as "amt_won", (sum( (CASE WHEN ( (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult)) <> 0 THEN ((holdem_hand_player_statistics.amt_won * 1.0 )/( (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult))) ELSE 0 END) )) as "amt_bb_won", (sum( (case when(holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s OR holdem_hand_player_statistics.flg_blind_db OR holdem_hand_player_statistics.flg_blind_ds) then 1 else 0 end))) as "cnt_blind", (sum((case when(holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))) as "cnt_p_ccall", (sum( (case when( NOT(NOT(holdem_hand_player_statistics.flg_p_face_raise) OR (holdem_hand_player_statistics.flg_p_limp) OR (holdem_hand_player_statistics.flg_p_first_raise)) AND (holdem_hand_player_detail.amt_blind=0)) then 1 else 0 end) )) as "cnt_p_ccall_opp", (sum((case when(holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))) as "cnt_vpip", (sum((case when(holdem_hand_player_statistics.flg_won_hand AND holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))) as "cnt_f_saw_won", (sum((case when(holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))) as "cnt_f_saw", (sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))) as "cnt_pfr", (sum( (case when(holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ) as "cnt_p_raise_first_in", (sum((case when(holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end))) as "cnt_p_open_opp", (sum( (case when(holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))) as "cnt_prev_callers_limp", (sum( (case when(holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.flg_p_limp = false AND holdem_hand_player_statistics.flg_p_ccall = false) then 1 else 0 end))) as "cnt_prev_callers_raise", (sum((case when(holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "cnt_wtsd", (sum( (case when(holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) as "cnt_wtsd_won" FROM holdem_hand_player_statistics , holdem_hand_player_detail, holdem_limit WHERE (holdem_hand_player_statistics.id_hand = holdem_hand_player_detail.id_hand AND holdem_hand_player_statistics.id_player = holdem_hand_player_detail.id_player) AND (holdem_limit.id_limit = holdem_hand_player_statistics.id_limit) AND (holdem_hand_player_statistics.id_player = 7) AND ((holdem_hand_player_statistics.id_holecard) > 0) GROUP BY (holdem_hand_player_statistics.id_holecard) ; Reason: Fatal Error (ERROR: could not read block 1163 of relation 1663/20576/22866: Invalid argument )
2008/11/08 13:43:45.059: [00001028][Query] Query execution time: 9736.59054433 ms : SELECT (holdem_hand_player_statistics.id_holecard) as "id_holecard", (count(holdem_hand_player_statistics.id_hand)) as "cnt_hands", (sum((case when(holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) as "cnt_won_hand", (sum(holdem_hand_player_statistics.amt_won)) as "amt_won", (sum( (CASE WHEN ( (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult)) <> 0 THEN ((holdem_hand_player_statistics.amt_won * 1.0 )/( (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult))) ELSE 0 END) )) as "amt_bb_won", (sum( (case when(holdem_hand_player_statistics.flg_blind_b OR holdem_hand_player_statistics.flg_blind_s OR holdem_hand_player_statistics.flg_blind_db OR holdem_hand_player_statistics.flg_blind_ds) then 1 else 0 end))) as "cnt_blind", (sum((case when(holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))) as "cnt_p_ccall", (sum( (case when( NOT(NOT(holdem_hand_player_statistics.flg_p_face_raise) OR (holdem_hand_player_statistics.flg_p_limp) OR (holdem_hand_player_statistics.flg_p_first_raise)) AND (holdem_hand_player_detail.amt_blind=0)) then 1 else 0 end) )) as "cnt_p_ccall_opp", (sum((case when(holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))) as "cnt_vpip", (sum((case when(holdem_hand_player_statistics.flg_won_hand AND holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))) as "cnt_f_saw_won", (sum((case when(holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))) as "cnt_f_saw", (sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))) as "cnt_pfr", (sum( (case when(holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ) as "cnt_p_raise_first_in", (sum((case when(holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end))) as "cnt_p_open_opp", (sum( (case when(holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))) as "cnt_prev_callers_limp", (sum( (case when(holdem_hand_player_statistics.flg_p_open = false AND holdem_hand_player_statistics.cnt_p_raise > 0 AND holdem_hand_player_statistics.flg_p_limp = false AND holdem_hand_player_statistics.flg_p_ccall = false) then 1 else 0 end))) as "cnt_prev_callers_raise", (sum((case when(holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "cnt_wtsd", (sum( (case when(holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) as "cnt_wtsd_won" FROM holdem_hand_player_statistics , holdem_hand_player_detail, holdem_limit WHERE (holdem_hand_player_statistics.id_hand = holdem_hand_player_detail.id_hand AND holdem_hand_player_statistics.id_player = holdem_hand_player_detail.id_player) AND (holdem_limit.id_limit = holdem_hand_player_statistics.id_limit) AND (holdem_hand_player_statistics.id_player = 7) AND ((holdem_hand_player_statistics.id_holecard) > 0) GROUP BY (holdem_hand_player_statistics.id_holecard)

[TonyB73]

And here is the log file entry for the second one:

2008/11/08 13:33:20.591: [00001028][PostgresConnection (Error)] Unable to execute query: SELECT id_limit, sum(cnt_vpip), sum(cnt_hands), sum(cnt_pfr), sum(cnt_f_saw_won), sum(cnt_f_saw), sum(cnt_wtsd), sum(cnt_wtsd_won), sum(cnt_f_bet), sum(cnt_f_raise), sum(cnt_t_bet), sum(cnt_t_raise), sum(cnt_r_bet), sum(cnt_r_raise), sum(cnt_f_call), sum(cnt_t_call), sum(cnt_r_call), sum(cnt_f_fold), sum(cnt_t_fold), sum(cnt_r_fold), sum(cnt_p_3bet), sum(cnt_f_3bet), sum(cnt_t_3bet), sum(cnt_r_3bet), sum(cnt_p_3bet_opp), sum(cnt_f_3bet_opp), sum(cnt_t_3bet_opp), sum(cnt_r_3bet_opp), sum(cnt_p_3bet_def_action_fold), sum(cnt_f_3bet_def_action_fold), sum(cnt_t_3bet_def_action_fold), sum(cnt_r_3bet_def_action_fold), sum(cnt_p_3bet_def_opp), sum(cnt_f_3bet_def_opp), sum(cnt_t_3bet_def_opp), sum(cnt_r_3bet_def_opp), sum(cnt_steal_att), sum(cnt_steal_opp), sum(cnt_bb_steal_fold), sum(cnt_steal_def_opp_bb), sum(cnt_sb_steal_fold), sum(cnt_steal_def_opp_sb), sum(amt_won) FROM ( SELECT (holdem_hand_player_statistics.id_limit) as "id_limit", (sum((case when(holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))) as "cnt_vpip", (count(holdem_hand_player_statistics.id_hand)) as "cnt_hands", (sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))) as "cnt_pfr", (sum((case when(holdem_hand_player_statistics.flg_won_hand AND holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))) as "cnt_f_saw_won", (sum((case when(holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))) as "cnt_f_saw", (sum((case when(holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "cnt_wtsd", (sum( (case when(holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) as "cnt_wtsd_won", (sum((case when(holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))) as "cnt_f_bet", (sum(holdem_hand_player_statistics.cnt_f_raise)) as "cnt_f_raise", (sum((case when(holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))) as "cnt_t_bet", (sum(holdem_hand_player_statistics.cnt_t_raise)) as "cnt_t_raise", (sum((case when(holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))) as "cnt_r_bet", (sum(holdem_hand_player_statistics.cnt_r_raise)) as "cnt_r_raise", (sum(holdem_hand_player_statistics.cnt_f_call)) as "cnt_f_call", (sum(holdem_hand_player_statistics.cnt_t_call)) as "cnt_t_call", (sum(holdem_hand_player_statistics.cnt_r_call)) as "cnt_r_call", (sum((case when(holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))) as "cnt_f_fold", (sum((case when(holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))) as "cnt_t_fold", (sum((case when(holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))) as "cnt_r_fold", (sum((case when(holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))) as "cnt_p_3bet", (sum((case when(holdem_hand_player_statistics.flg_f_3bet) then 1 else 0 end))) as "cnt_f_3bet", (sum((case when(holdem_hand_player_statistics.flg_t_3bet) then 1 else 0 end))) as "cnt_t_3bet", (sum((case when(holdem_hand_player_statistics.flg_r_3bet) then 1 else 0 end))) as "cnt_r_3bet", (sum((case when(holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))) as "cnt_p_3bet_opp", (sum((case when(holdem_hand_player_statistics.flg_f_3bet_opp) then 1 else 0 end))) as "cnt_f_3bet_opp", (sum((case when(holdem_hand_player_statistics.flg_t_3bet_opp) then 1 else 0 end))) as "cnt_t_3bet_opp", (sum((case when(holdem_hand_player_statistics.flg_r_3bet_opp) then 1 else 0 end))) as "cnt_r_3bet_opp", (sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))) as "cnt_p_3bet_def_action_fold", (sum((case when(holdem_hand_player_statistics.enum_f_3bet_action='F') then 1 else 0 end))) as "cnt_f_3bet_def_action_fold", (sum((case when(holdem_hand_player_statistics.enum_t_3bet_action='F') then 1 else 0 end))) as "cnt_t_3bet_def_action_fold", (sum((case when(holdem_hand_player_statistics.enum_r_3bet_action='F') then 1 else 0 end))) as "cnt_r_3bet_def_action_fold", (sum((case when(holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))) as "cnt_p_3bet_def_opp", (sum((case when(holdem_hand_player_statistics.flg_f_3bet_def_opp) then 1 else 0 end))) as "cnt_f_3bet_def_opp", (sum((case when(holdem_hand_player_statistics.flg_t_3bet_def_opp) then 1 else 0 end))) as "cnt_t_3bet_def_opp", (sum((case when(holdem_hand_player_statistics.flg_r_3bet_def_opp) then 1 else 0 end))) as "cnt_r_3bet_def_opp", (sum((case when(holdem_hand_player_statistics.flg_steal_att) then 1 else 0 end))) as "cnt_steal_att", (sum((case when(holdem_hand_player_statistics.flg_steal_opp) then 1 else 0 end))) as "cnt_steal_opp", (sum((case when(holdem_hand_player_statistics.flg_bb_steal_fold) then 1 else 0 end))) as "cnt_bb_steal_fold", (sum( (case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_b) then 1 else 0 end))) as "cnt_steal_def_opp_bb", (sum((case when(holdem_hand_player_statistics.flg_sb_steal_fold) then 1 else 0 end))) as "cnt_sb_steal_fold", (sum( (case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))) as "cnt_steal_def_opp_sb", (sum(holdem_hand_player_statistics.amt_won)) as "amt_won" FROM holdem_hand_player_statistics WHERE (holdem_hand_player_statistics.id_player = 7) GROUP BY (holdem_hand_player_statistics.id_limit) UNION SELECT holdem_cache.id_limit, sum(holdem_cache.cnt_vpip), sum(holdem_cache.cnt_hands), sum(holdem_cache.cnt_pfr), sum(holdem_cache.cnt_f_saw_won), sum(holdem_cache.cnt_f_saw), sum(holdem_cache.cnt_wtsd), sum(holdem_cache.cnt_wtsd_won), sum(holdem_cache.cnt_f_bet), sum(holdem_cache.cnt_f_raise), sum(holdem_cache.cnt_t_bet), sum(holdem_cache.cnt_t_raise), sum(holdem_cache.cnt_r_bet), sum(holdem_cache.cnt_r_raise), sum(holdem_cache.cnt_f_call), sum(holdem_cache.cnt_t_call), sum(holdem_cache.cnt_r_call), sum(holdem_cache.cnt_f_fold), sum(holdem_cache.cnt_t_fold), sum(holdem_cache.cnt_r_fold), sum(holdem_cache.cnt_p_3bet), sum(holdem_cache.cnt_f_3bet), sum(holdem_cache.cnt_t_3bet), sum(holdem_cache.cnt_r_3bet), sum(holdem_cache.cnt_p_3bet_opp), sum(holdem_cache.cnt_f_3bet_opp), sum(holdem_cache.cnt_t_3bet_opp), sum(holdem_cache.cnt_r_3bet_opp), sum(holdem_cache.cnt_p_3bet_def_action_fold), sum(holdem_cache.cnt_f_3bet_def_action_fold), sum(holdem_cache.cnt_t_3bet_def_action_fold), sum(holdem_cache.cnt_r_3bet_def_action_fold), sum(holdem_cache.cnt_p_3bet_def_opp), sum(holdem_cache.cnt_f_3bet_def_opp), sum(holdem_cache.cnt_t_3bet_def_opp), sum(holdem_cache.cnt_r_3bet_def_opp), sum(holdem_cache.cnt_steal_att), sum(holdem_cache.cnt_steal_opp), sum(holdem_cache.cnt_bb_steal_fold), sum(holdem_cache.cnt_steal_def_opp_bb), sum(holdem_cache.cnt_sb_steal_fold), sum(holdem_cache.cnt_steal_def_opp_sb), sum(holdem_cache.amt_won) FROM holdem_cache WHERE holdem_cache.id_player = 7 GROUP BY holdem_cache.id_limit) AS CacheTable GROUP BY id_limit; Reason: Fatal Error (ERROR: could not read block 1163 of relation 1663/20576/22866: Invalid argument )

[TonyB73]

Aaaaaaaahhhhhh! My PT3 is falling apart!

Now my graphs tab doesn't work.

I did some housekeeping on the database to see if that would help, and got an error on that too. Interesting that it referenced "block 1163" too?

Help!

[kraada]

This issue is often the result of faulty hardware or a system crash. You can set PostgreSQL to ignore these errors by clicking Start --> Programs --> PostgreSQL --> Configuration Files --> Edit postgresql.conf. In the configuration file that appears, go to the bottom of the file and add the text "zero_damaged_pages = on" on a new line and then save and close the file. Click Start --> Programs --> PostgreSQL --> Reload Configuration and PostgreSQL will ignore the damaged data. If you continue to have problems with that hard drive, you should consider replacing it.

[TonyB73]

Thanks for your response.

I tried your solution, but it made no difference. I did notice that (I think) in the postgresql.conf file every line starts with a # symbol, which I thought meant a comment, but in any case I tried the new line both with and without that symbol at the beginning and it didn't work either way. Rebooting and reloading PT3 after inserting it made no difference either.

Is there anything else I could do? Do I need to re-import all the hands or anything drastic like that?

Maybe I should just get a new hard drive before this one packs up altogether ...

Also, last night I got the registration problem again, that I thought was fixed with Beta 20. Shutting down and restarting Pt3 fixes it, but its a pain. Am I the only one that this has happened to?

[kraada]

The # that starts the lines in the conf file do mean that the line is commented out. You need to not have the zero_damaged_pages line have a # in front of it. All lines with #s to start are ignored.

The registration issues might be caused by not running PT3 as administrator; try right clicking the desktop icon for PT3 and click "Run as Administrator" and see if that fixes it for you.

[TonyB73]

Thanks dude. I did try it without the #, but there was no change. I'll give it another shot tonight just to make sure.

I'm also looking into a new hard drive - I'm actually running PT3 on a fairly old laptop so I will probably just try and source another machine rather than swapping a new hard drive in. By the way, if i do need to transfer over to another HD/laptop, can I do it without using up my second registration (I was planning to use that on my Mac, when you guys get a compatible version up and running)?

And thanks for your comment re registration issues - I'll check that out tonight too.

[kraada]

PT3 can be installed concurrently on up to two machines. If you uninstall that prior registration is no longer counted against you.

If you're moving to a new machine, you'll want to bring all of your hand histories, Layouts.pt3 (your HUD), StatsDefinitionsCustomized.pt3 (custom stats), and Buddies.cfg (buddy list). Import the hands, copy the other files into the right locations and you'll be good to go.