Database Error

[LeftyMcGee]

Not sure what is going on here. This is the error I am getting and the pterrorlog.txt info. Some hands will import and others won't. I did not have any trouble yesterday and I downloaded a Stars update today. Any help would be much appreciated.

A database error has occurred.

DBCode: -1045 Error Text: Select Error: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Not a valid bookmark.

pterrorlog.txt info
*********************************
PT Version: 2.17.02a
Error Date: 05/21/2008 09:57
Database Error: -1045
Error Text: Select error: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Not a valid bookmark.
DataObject: d_tb_player_summary_detail
Syntax In Error: SELECT game_level.game_level_desc, game_level.game_level_big_bet as big_bet, sum(iif(game_players.won_hand = 1, game.rake, 0)) as rake_in_game_won, sum(game_players.won_hand) as game_won, sum(iif(game_players.won_hand = 1, game_players.saw_flop_n, 0)) as games_won_wsf, sum(game_players.total_bet) as game_players_total_bet, sum(game_players.total_won) as game_players_total_won, sum(iif(isnull(game.exrate), game_players.total_won - game_players.total_bet, (game_players.total_won - game_players.total_bet)/game.exrate)) as amt_won, sum(went_to_showdown_n) as went_to_showdown, sum(iif(game_players.went_to_showdown_n = 1, game_players.won_hand, 0)) as won_showdown, sum(game_players.pre_flop_raise_n) as pre_flop_raises, sum(game_players.flop_ck_raise_n) as ck_raise_1, sum(game_players.turn_bet_ck_raise_n) as ck_raise_2, sum(game_players.river_bet_ck_raise_n) as ck_raise_3, sum(iif(game_players.big_blind_n + game_players.small_blind_n = 0, 1, 0)) as games_not_a_blind, sum(game_players.big_blind_n + game_players.small_blind_n) as blind_games, sum(saw_flop_n) as saw_flop_all_games, sum(iif(game_players.big_blind_n + game_players.small_blind_n = 0, game_players.saw_flop_n, 0)) as saw_flop_nb, count(*) as total_hands, sum(iif(tpossible_actions > 0, 1, 0)) as saw_turn, sum(iif(rpossible_actions > 0, 1, 0)) as saw_river, sum(vol_put_money_in_pot) as vol_put_money_in, sum(small_blind_n) as times_as_sb, sum(iif(small_blind_n = 1 AND vol_put_money_in_pot = 1, 1, 0)) as called_from_sb, sum(iif(steal_attempted = 1 AND folded_to_steal_attempt = 1 AND small_blind_n = 1, 1, 0)) as folded_sb, sum(iif(steal_attempted = 1 AND folded_to_steal_attempt = 0 AND small_blind_n = 1 AND won_hand = 1 AND went_to_showdown_n = 0, 1, 0)) as sb_def_won_wo_sd, sum(iif(steal_attempted = 1 AND folded_to_steal_attempt = 0 AND small_blind_n = 1 AND won_hand = 0 AND went_to_showdown_n = 0, 1, 0)) as sb_def_folded, sum(iif(steal_attempted = 1 AND folded_to_steal_attempt = 0 AND small_blind_n = 1 AND went_to_showdown_n = 1, 1, 0)) as sb_def_wsd, sum(iif(steal_attempted = 1 AND folded_to_steal_attempt = 0 AND small_blind_n = 1 AND won_hand = 1 AND went_to_showdown_n = 1, 1, 0)) as sb_def_won_wsd, sum(iif(steal_attempted = 1 AND folded_to_steal_attempt = 1 AND big_blind_n = 1, 1, 0)) as folded_bb, sum(iif(steal_attempted = 1 AND folded_to_steal_attempt = 0 AND big_blind_n = 1 AND won_hand = 1 AND went_to_showdown_n = 0, 1, 0)) as bb_def_won_wo_sd, sum(iif(steal_attempted = 1 AND folded_to_steal_attempt = 0 AND big_blind_n = 1 AND won_hand = 0 AND went_to_showdown_n = 0, 1, 0)) as bb_def_folded, sum(iif(steal_attempted = 1 AND folded_to_steal_attempt = 0 AND big_blind_n = 1 AND went_to_showdown_n = 1, 1, 0)) as bb_def_wsd, sum(iif(steal_attempted = 1 AND folded_to_steal_attempt = 0 AND big_blind_n = 1 AND won_hand = 1 AND went_to_showdown_n = 1, 1, 0)) as bb_def_won_wsd, sum(iif(steal_attempted = 1 AND small_blind_n = 1, 1, 0)) as steal_attempted_sb, sum(iif(steal_attempted = 1 AND big_blind_n = 1, 1, 0)) as steal_attempted_bb, sum(chance_to_steal) as chance_to_steal_blinds, sum(attempted_steal) as attempted_to_steal_blinds, sum(iif(attempted_steal = 1 AND won_hand = 1 AND saw_flop_n = 0, 1, 0)) as sa_no_flop, sum(iif(attempted_steal = 1 AND won_hand = 0 AND went_to_showdown_n = 0, 1, 0)) as sa_fold, sum(iif(attempted_steal = 1 AND won_hand = 1 AND went_to_showdown_n = 0, 1, 0)) as sa_won_no_sd, sum(iif(attempted_steal = 1 AND went_to_showdown_n = 1, 1, 0)) as sa_wsd, sum(iif(attempted_steal = 1 AND won_hand = 1 AND went_to_showdown_n = 1, 1, 0)) as sa_won_wsd, (game_level_big_bet + (game_level_big_bet * game_level.pl_nl)) as actual_bb, sum(limp_call_reraise_pf) as limp_raise, sum(folded_to_river_bet) as fold_to_river_bet, sum(iif(rcall > 0 AND (rraise + rbet = 0), 1, 0)) as bet_on_river, sum(pfr_raise) as pfr_raised, sum(iif(pfr_check > 0 AND flop_ck_raise_n = 0, 1, 0)) as pfr_checked, sum(iif(pfr_check > 0 AND flop_ck_raise_n > 0, 1, 0)) as pfr_check_raised, sum(pfr_fold) as pfr_folded, sum(pfr_call) as pfr_called, sum(pfr_bet) as pfr_betout, sum(iif(pre_flop_raise_n = 1 AND pfr_raise = 0 AND pfr_check = 0 AND pfr_fold = 0 AND pfr_call = 0 AND pfr_bet = 0, 1, 0)) as pfr_noflop, sum(ppossible_actions) as p_act, sum(fpossible_actions) as f_act, sum(tpossible_actions) as t_act, sum(rpossible_actions) as r_act, sum(pcheck) as p_check, sum(fcheck) as f_check, sum(tcheck) as t_check, sum(rcheck) as r_check, sum(pfold) as p_fold, sum(ffold) as f_fold, sum(tfold) as t_fold, sum(rfold) as r_fold, sum(praise) as p_raise, sum(fraise) as f_raise, sum(traise) as t_raise, sum(rraise) as r_raise, sum(pcall) as p_call, sum(fcall) as f_call, sum(tcall) as t_call, sum(rcall) as r_call, sum(fbet) as f_bet, sum(tbet) as t_bet, sum(rbet) as r_bet, sum(iif(isnull(when_folded) or when_folded = '', 1, 0)) as no_fold, sum(iif(when_folded = 'Pre-flop', 1, 0)) as pre_flop, sum(iif(when_folded = 'After flop', 1, 0)) as flop, sum(iif(when_folded = 'After turn', 1, 0)) as turn, sum(iif(when_folded = 'After river', 1, 0)) as river, sum(steal_hu_chance) as shuc, sum(steal_hu_fold) as shuf, sum(iif(pre_flop_raise_n > 0 and won_hand = 1 and went_to_showdown_n = 0, 1, 0)) as pfr_won_no_sd, sum(iif(pre_flop_raise_n > 0 and won_hand = 0 and went_to_showdown_n = 0, 1, 0)) as pfr_fold_no_sd, sum(iif(pre_flop_raise_n > 0 and went_to_showdown_n = 1, 1, 0)) as pfr_wsd, sum(iif(pre_flop_raise_n > 0 and won_hand = 1 and went_to_showdown_n = 1, 1, 0)) as pfr_won_wsd, sum(iif(praise = 0 and pcall > 0, 1, 0)) as pfc_times, sum(iif(praise = 0 and pcall > 0 and won_hand = 1 and went_to_showdown_n = 0, 1, 0)) as pfc_won_no_sd, sum(iif(praise = 0 and pcall > 0 and won_hand = 0 and went_to_showdown_n = 0, 1, 0)) as pfc_fold_no_sd, sum(iif(praise = 0 and pcall > 0 and went_to_showdown_n = 1, 1, 0)) as pfc_wsd, sum(iif(praise = 0 and pcall > 0 and won_hand = 1 and went_to_showdown_n = 1, 1, 0)) as pfc_won_wsd, sum(iif(fbet + fraise > 0, 1, 0)) as fbet_times, sum(iif(fbet + fraise > 0 and won_hand = 1 and went_to_showdown_n = 0, 1, 0)) as fbet_won_no_sd, sum(iif(fbet + fraise > 0 and won_hand = 0 and went_to_showdown_n = 0, 1, 0)) as fbet_fold_no_sd, sum(iif(fbet + fraise > 0 and went_to_showdown_n = 1, 1, 0)) as fbet_wsd, sum(iif(fbet + fraise > 0 and won_hand = 1 and went_to_showdown_n = 1, 1, 0)) as fbet_won_wsd, sum(iif(fbet + fraise = 0 AND fcall > 0, 1, 0)) as fcall_times, sum(iif(fbet + fraise = 0 AND fcall > 0 and won_hand = 1 and went_to_showdown_n = 0, 1, 0)) as fcall_won_no_sd, sum(iif(fbet + fraise = 0 AND fcall > 0 and won_hand = 0 and went_to_showdown_n = 0, 1, 0)) as fcall_fold_no_sd, sum(iif(fbet + fraise = 0 AND fcall > 0 and went_to_showdown_n = 1, 1, 0)) as fcall_wsd, sum(iif(fbet + fraise = 0 AND fcall > 0 and won_hand = 1 and went_to_showdown_n = 1, 1, 0)) as fcall_won_wsd, sum(iif(tbet + traise > 0, 1, 0)) as tbet_times, sum(iif(tbet + traise > 0 and won_hand = 1 and went_to_showdown_n = 0, 1, 0)) as tbet_won_no_sd, sum(iif(tbet + traise > 0 and won_hand = 0 and went_to_showdown_n = 0, 1, 0)) as tbet_fold_no_sd, sum(iif(tbet + traise > 0 and went_to_showdown_n = 1, 1, 0)) as tbet_wsd, sum(iif(tbet + fraise > 0 and won_hand = 1 and went_to_showdown_n = 1, 1, 0)) as tbet_won_wsd, sum(iif(tbet + traise = 0 AND tcall > 0, 1, 0)) as tcall_times, sum(iif(tbet + traise = 0 AND tcall > 0 and won_hand = 1 and went_to_showdown_n = 0, 1, 0)) as tcall_won_no_sd, sum(iif(tbet + traise = 0 AND tcall > 0 and won_hand = 0 and went_to_showdown_n = 0, 1, 0)) as tcall_fold_no_sd, sum(iif(tbet + traise = 0 AND tcall > 0 and went_to_showdown_n = 1, 1, 0)) as tcall_wsd, sum(iif(tbet + traise = 0 AND tcall > 0 and won_hand = 1 and went_to_showdown_n = 1, 1, 0)) as tcall_won_wsd, sum(iif(rbet + rraise > 0, 1, 0)) as rbet_times, sum(iif(rbet + rraise > 0 and won_hand = 1 and went_to_showdown_n = 0, 1, 0)) as rbet_won_no_sd, sum(iif(rbet + rraise > 0 and won_hand = 0 and went_to_showdown_n = 0, 1, 0)) as rbet_fold_no_sd, sum(iif(rbet + rraise > 0 and went_to_showdown_n = 1, 1, 0)) as rbet_wsd, sum(iif(rbet + rraise > 0 and won_hand = 1 and went_to_showdown_n = 1, 1, 0)) as rbet_won_wsd, sum(iif(rbet + rraise = 0 AND rcall > 0, 1, 0)) as rcall_times, sum(iif(rbet + rraise = 0 AND rcall > 0 and won_hand = 1 and went_to_showdown_n = 0, 1, 0)) as rcall_won_no_sd, sum(iif(rbet + rraise = 0 AND rcall > 0 and won_hand = 0 and went_to_showdown_n = 0, 1, 0)) as rcall_fold_no_sd, sum(iif(rbet + rraise = 0 AND rcall > 0 and went_to_showdown_n = 1, 1, 0)) as rcall_wsd, sum(iif(rbet + rraise = 0 AND rcall > 0 and won_hand = 1 and went_to_showdown_n = 1, 1, 0)) as rcall_won_wsd, sum(cold_call_pf) as ccpf FROM game, game_players, game_level WHERE ( game.game_id = game_players.game_id ) AND ( game.game_level_id = game_level.game_level_id ) AND ( game_players.player_id = 4 ) GROUP BY game_level.game_level_desc, game_level.game_level_big_bet, (game_level_big_bet + (game_level_big_bet * game_level.pl_nl))
*********************************

[ptrack pat]

See the FAQ, issue #2
http://www.pokertracker3.com/forums/vie ... =30&t=1377