Just installed newupdate without post

[gibbon]

hi searched google and also for this issue

can anyone help ps ive found and deleted the pip file and rebooted

Thanking you in advance

Unable to execute query: SELECT (holdem_table_session_summary.id_session) as "id_session", (holdem_table_session_summary.flg_note) as "flg_note", (holdem_table_session_summary.date_start) as "date_start", (holdem_table_session_summary.date_end) as "date_end", (holdem_table_session_summary.id_site) as "id_site", (holdem_table.table_name) as "table_name", (holdem_table_session_summary.id_limit) as "id_limit", (holdem_table_session_summary.seat) as "seat", (holdem_table_session_summary.cnt_hands) as "cnt_hands", (holdem_table_session_summary.amt_won) as "amt_won", (holdem_table_session_summary.amt_won * 1.0 / (holdem_limit.amt_bb * holdem_limit.val_nlpl_mult)) as "amt_bb_won", (holdem_table_session_summary.amt_rake) as "amt_rake", (holdem_table_session_summary.amt_mgr) as "amt_mgr" FROM holdem_table_session_summary, holdem_table, holdem_limit WHERE (holdem_table.id_table = holdem_table_session_summary.id_table) AND (holdem_limit.id_limit = holdem_table_session_summary.id_limit) AND (holdem_table_session_summary.id_player = 111) ; Reason: Fatal Error (ERROR: division by zero )
2008/10/01 21:46:21.796: [00006028][Query] Query execution time: 41.76144419 ms : SELECT (holdem_table_session_summary.id_session) as "id_session", (holdem_table_session_summary.flg_note) as "flg_note", (holdem_table_session_summary.date_start) as "date_start", (holdem_table_session_summary.date_end) as "date_end", (holdem_table_session_summary.id_site) as "id_site", (holdem_table.table_name) as "table_name", (holdem_table_session_summary.id_limit) as "id_limit", (holdem_table_session_summary.seat) as "seat", (holdem_table_session_summary.cnt_hands) as "cnt_hands", (holdem_table_session_summary.amt_won) as "amt_won", (holdem_table_session_summary.amt_won * 1.0 / (holdem_limit.amt_bb * holdem_limit.val_nlpl_mult)) as "amt_bb_won", (holdem_table_session_summary.amt_rake) as "amt_rake", (holdem_table_session_summary.amt_mgr) as "amt_mgr" FROM holdem_table_session_summary, holdem_table, holdem_limit WHERE (holdem_table.id_table = holdem_table_session_summary.id_table) AND (holdem_limit.id_limit = holdem_table_session_summary.id_limit) AND (holdem_table_session_summary.id_player = 111)
2008/10/01 21:46:25.328: [00006028][Query] Connecting to database: new datebase 16/05/08

[gibbon]

ps com stats

21:42:32.328: [- Main -][System] PokerTracker v3.00 build 3
2008/10/01 21:42:32.343: [- Main -][SystemInfo] Windows Version: 5.1 build 2600 (platform 2) Service Pack 2
2008/10/01 21:42:32.359: [- Main -][SystemInfo] C:\ Disk Space: 476,930 mb total; 430,626 mb used; 46,303 mb free
2008/10/01 21:42:32.375: [- Main -][SystemInfo] E:\ Disk Space: 7,741 mb total; 2,455 mb used; 5,287 mb free
2008/10/01 21:42:32.406: [- Main -][SystemInfo] Processor 1: Speed: 2.41 GHz Name: Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz

[gibbon]

2008/10/01 21:45:53.703: [00005900][Query] Query execution time: 217.46159925 ms : SELECT (holdem_table_session_summary.id_session) as "id_session", (holdem_table_session_summary.flg_note) as "flg_note", (holdem_table_session_summary.date_start) as "date_start", (holdem_table_session_summary.date_end) as "date_end", (holdem_table_session_summary.id_site) as "id_site", (holdem_table.table_name) as "table_name", (holdem_table_session_summary.id_limit) as "id_limit", (holdem_table_session_summary.seat) as "seat", (holdem_table_session_summary.cnt_hands) as "cnt_hands", (holdem_table_session_summary.amt_won) as "amt_won", (holdem_table_session_summary.amt_won * 1.0 / (holdem_limit.amt_bb * holdem_limit.val_nlpl_mult)) as "amt_bb_won", (holdem_table_session_summary.amt_rake) as "amt_rake", (holdem_table_session_summary.amt_mgr) as "amt_mgr" FROM holdem_table_session_summary, holdem_table, holdem_limit WHERE (holdem_table.id_table = holdem_table_session_summary.id_table) AND (holdem_limit.id_limit = holdem_table_session_summary.id_limit) AND (holdem_table_session_summary.id_player = 22056)
2008/10/01 21:45:53.859: [00006024][QueryReportCtrl] Query load time: 0 ms
2008/10/01 21:45:54.406: [00005900][Query] Connecting to database: new datebase 16/05/08
2008/10/01 21:45:54.406: [00005900][Query] Executing SQL: SELECT (holdem_hand_summary.id_hand) as "id_hand", (holdem_hand_summary.id_site) as "id_site", (holdem_hand_summary.hand_no) as "hand_no", (holdem_hand_summary.flg_note) as "flg_note", (holdem_hand_player_statistics.date_played) as "date_played", (holdem_hand_player_statistics.flg_blind_s) as "flg_blind_s", (holdem_hand_player_statistics.flg_blind_b) as "flg_blind_b", (holdem_hand_player_statistics.flg_blind_db) as "flg_blind_db", (holdem_hand_player_statistics.flg_blind_ds) as "flg_blind_ds", (holdem_hand_player_statistics.flg_p_ccall) as "flg_p_ccall", (holdem_hand_player_statistics.amt_won) as "amt_won", (holdem_hand_player_statistics.amt_won * 1.0 / (holdem_limit.amt_bb * holdem_limit.val_nlpl_mult)) as "amt_bb_won", (holdem_hand_player_detail.holecard_1) as "id_holecard1", (holdem_hand_player_detail.holecard_2) as "id_holecard2", (holdem_hand_player_statistics.flg_f_saw) as "flg_f_saw", (holdem_hand_summary.card_1) as "id_flop1", (holdem_hand_summary.card_2) as "id_flop2", (holdem_hand_summary.card_3) as "id_flop3", (holdem_hand_summary.card_4) as "id_turn", (holdem_hand_summary.card_5) as "id_river", (holdem_hand_summary.amt_pot) as "amt_pot", (holdem_hand_summary.amt_rake) as "amt_rake", (holdem_hand_player_statistics.id_final_hand) as "id_final_hand", (holdem_hand_player_statistics.flg_showed) as "flg_showed", (holdem_hand_player_statistics.enum_folded) as "enum_folded", (player_winner.player_name) as "str_winner", (holdem_hand_summary.id_win_hand) as "id_win_hand", (holdem_hand_player_statistics.id_session) as "id_session" FROM holdem_hand_summary, holdem_hand_player_statistics, holdem_limit, holdem_hand_player_detail, player player_winner WHERE (holdem_hand_summary.id_hand = holdem_hand_player_statistics.id_hand) AND (holdem_limit.id_limit = holdem_hand_summary.id_limit) AND (holdem_hand_summary.id_hand = holdem_hand_player_detail.id_hand) AND (player_winner.id_player = holdem_hand_summary.id_winner) AND (holdem_limit.id_limit = holdem_hand_player_statistics.id_limit) AND (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_hand_player_statistics.id_player = 22056) AND (holdem_hand_player_statistics.id_session) in (61774)
2008/10/01 21:45:54.406: [00006028][Query] Connecting to database: new datebase 16/05/08
2008/10/01 21:45:54.421: [00006028][Query] Executing SQL: SELECT holdem_hand_player_statistics.amt_won FROM holdem_hand_summary holdem_hand_summary, holdem_hand_player_statistics WHERE holdem_hand_player_statistics.id_hand = holdem_hand_summary.id_hand AND holdem_hand_player_statistics.id_player = 22056 AND holdem_hand_player_statistics.id_session in (61774) ORDER BY holdem_hand_summary.date_played ASC;
2008/10/01 21:45:55.406: [00006028][Query] Query execution time: 969.58866597 ms : SELECT holdem_hand_player_statistics.amt_won FROM holdem_hand_summary holdem_hand_summary, holdem_hand_player_statistics WHERE holdem_hand_player_statistics.id_hand = holdem_hand_summary.id_hand AND holdem_hand_player_statistics.id_player = 22056 AND holdem_hand_player_statistics.id_session in (61774) ORDER BY holdem_hand_summary.date_played ASC;
2008/10/01 21:45:55.484: [00005900][Query] Query execution time: 1033.37250592 ms : SELECT (holdem_hand_summary.id_hand) as "id_hand", (holdem_hand_summary.id_site) as "id_site", (holdem_hand_summary.hand_no) as "hand_no", (holdem_hand_summary.flg_note) as "flg_note", (holdem_hand_player_statistics.date_played) as "date_played", (holdem_hand_player_statistics.flg_blind_s) as "flg_blind_s", (holdem_hand_player_statistics.flg_blind_b) as "flg_blind_b", (holdem_hand_player_statistics.flg_blind_db) as "flg_blind_db", (holdem_hand_player_statistics.flg_blind_ds) as "flg_blind_ds", (holdem_hand_player_statistics.flg_p_ccall) as "flg_p_ccall", (holdem_hand_player_statistics.amt_won) as "amt_won", (holdem_hand_player_statistics.amt_won * 1.0 / (holdem_limit.amt_bb * holdem_limit.val_nlpl_mult)) as "amt_bb_won", (holdem_hand_player_detail.holecard_1) as "id_holecard1", (holdem_hand_player_detail.holecard_2) as "id_holecard2", (holdem_hand_player_statistics.flg_f_saw) as "flg_f_saw", (holdem_hand_summary.card_1) as "id_flop1", (holdem_hand_summary.card_2) as "id_flop2", (holdem_hand_summary.card_3) as "id_flop3", (holdem_hand_summary.card_4) as "id_turn", (holdem_hand_summary.card_5) as "id_river", (holdem_hand_summary.amt_pot) as "amt_pot", (holdem_hand_summary.amt_rake) as "amt_rake", (holdem_hand_player_statistics.id_final_hand) as "id_final_hand", (holdem_hand_player_statistics.flg_showed) as "flg_showed", (holdem_hand_player_statistics.enum_folded) as "enum_folded", (player_winner.player_name) as "str_winner", (holdem_hand_summary.id_win_hand) as "id_win_hand", (holdem_hand_player_statistics.id_session) as "id_session" FROM holdem_hand_summary, holdem_hand_player_statistics, holdem_limit, holdem_hand_player_detail, player player_winner WHERE (holdem_hand_summary.id_hand = holdem_hand_player_statistics.id_hand) AND (holdem_limit.id_limit = holdem_hand_summary.id_limit) AND (holdem_hand_summary.id_hand = holdem_hand_player_detail.id_hand) AND (player_winner.id_player = holdem_hand_summary.id_winner) AND (holdem_limit.id_limit = holdem_hand_player_statistics.id_limit) AND (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_hand_player_statistics.id_player = 22056) AND (holdem_hand_player_statistics.id_session) in (61774)
2008/10/01 21:45:55.484: [00006028][Query] Executing SQL: SELECT player.player_name, count(*), sum( holdem_hand_player_statistics.amt_won ), count( distinct date_trunc('day', (holdem_hand_summary.date_played + INTERVAL '10 HOURS')) ), sum( (CASE WHEN ( (holdem_limit.amt_bb * holdem_limit.val_nlpl_mult) ) <> 0 THEN (( holdem_hand_player_statistics.amt_won )/( (holdem_limit.amt_bb * holdem_limit.val_nlpl_mult) )) ELSE 0 END) ) FROM holdem_hand_summary, holdem_hand_player_statistics, holdem_limit, player WHERE holdem_hand_player_statistics.id_hand = holdem_hand_summary.id_hand AND holdem_hand_player_statistics.id_player = player.id_player AND holdem_limit.id_limit = holdem_hand_summary.id_limit AND holdem_hand_player_statistics.id_player = 22056 AND holdem_hand_player_statistics.id_session in (61774) GROUP BY player.player_name;
2008/10/01 21:45:55.609: [00006032][QueryReportCtrl] Query load time: 15 ms

[WhiteRider]

Is this in Build 3?

The "Reason: Fatal Error (ERROR: division by zero )" probably means that you have a Custom Stat which isn't defined correctly.
Where do you see this error? and what were you doing / looking at at the time?

[gibbon]

sessions

[gibbon]

sorry it only happens when i try to look at sessions

everthing else is fine and i have no custom stats that i have ever put on

[gibbon]

and yes it is version 3

[WhiteRider]

Have you configured the report by clicking the spanner/wrench icon to the right and adding any stats?
Is it the 'Sessions' or 'Session Hands' report?
Have you got any filters set? Try "Clear"ing them.

[gibbon]

only when looking at sessions not hands of the session and i didnt have any filters and nor or have i added any other data

[WhiteRider]

OK, Please enable logging, reproduce the problem and submit your PokerTracker.log file to the Support system , and link to this thread in the reference field of the ticket so that we can investigate.