[PT2] Error beim Import

    • betterb
      betterb
      Bronze
      Dabei seit: 21.08.2006 Beiträge: 1.805
      Ich habe per Auto-Import 2GB Handhistories importiert, das war zumindest der Plan. Das ganze lief auch 15h gut, nur kamen dann folgende Fehlermeldungen:

      code:
      PT Version: 2.17.03d
      Error Date: 01/29/2009   17:14
      Database Error: 26
      Error Text: SQLSTATE = 08S01
      No response from the backend;
      No response from the backend
      
      No changes made to database.
      
      INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, final_hand, hand_rank_id, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 13257, 4, 5192522, 5, 'Kd', 'Kc', 'o', 6.0000, 2.0000, 4.0000, 4.0000, 16.0000, 0.0000, 'Y', 'a pair of kings', 2, 'KK', 13, 13, 0, 0, 1, 0, 369909, 1, 6, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 1, 1, 2, 0, 0, 1, 1, 1, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 0.0000, 13257, 0, 0, 0, 17.0000 )
      DataObject: d_game_players
      Syntax In Error: INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, played_hand, final_hand, hand_rank_id, hole_cards, card_order1, card_order2, card_order3, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count ) VALUES ( 13257, 4, 5192522, 5, 'Kd', 'Kc', 'o', 6.0000, 2.0000, 4.0000, 4.0000, 16.0000, 0.0000, 'Y', 'a pair of kings', 2, 'KK', 13, 13, 0, 0, 1, 0, 369909, 1, 6, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 1, 1, 2, 0, 0, 1, 1, 1, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 0.0000, 13257, 0, 0, 0, 17.0000 )
      *********************************
      
      *********************************
      PT Version: 2.17.03d
      Error Date: 01/29/2009   17:27
      Database Error: 26
      Error Text: Select error: SQLSTATE = 08S01
      Could not send Query(connection dead);
      Could not send Query(connection dead)
      DataObject: d_dd_game_level
      Syntax In Error:   SELECT DISTINCT  game_level.game_level_id ,           game_level.game_level_desc ,           game_level.game_level_big_bet ,           game_level.pl_nl     FROM game_level    
      *********************************
      
      *********************************
      PT Version: 2.17.03d
      Error Date: 01/29/2009   17:28
      Database Error: 26
      Error Text: Select error: SQLSTATE = 08S01
      Could not send Query(connection dead);
      Could not send Query(connection dead)
      DataObject: d_player_names
      Syntax In Error:   SELECT players.screen_name,   
               players.location,   
               0 as handle,   
               players.treeview_icon,   
               players.player_id,   
               players.main_site_id,   
               players.site_id,   
               players.alias_id,   
               players.hide_ind,   
               players.ring_player,   
               players.tourney_player, 
      			upper(players.screen_name) as upper_name   
          FROM players  
         WHERE ( players.main_site_id = 2 ) OR  
               ( players.player_id = 0 )    
      



      Beim Update des Caches von PokerAce kam dementsprechend auch eine Fehlermeldung.
      Nun habe ich ins Summary von PT2 geguckt und dort sind weitaus mehr Hände drin als vorher, aber wahrscheinlich nicht alle. Nun ist meine Frage, ob die Hände, die importiert worden, fehlerfrei und komplett importiert worden sind oder ob ich nun alle Hände purgen muss?

      Ich kann leider die Log nicht genau deuten und die Zeile "No changes made to database." irritiert mich auch ein wenig.
  • 6 Antworten