[HM2] HM2 sypie błędy z PostgreSQL

    • neekenVIP
      neekenVIP
      Brąz
      na forum od: 15.11.2013 Posty: 677
      Hej,
      może ktoś zobaczyć, czy w dzienniku zdarzeń też mu sypie tyle zwykłeych errorów:


      Przykładowy error

      2014-05-04 22:05:03 CESTERROR: prepared statement "insertplayer" already
      exists
      2014-05-04 22:05:03 CESTSTATEMENT: PREPARE INSERTPLAYER
      (text,smallint,integer,integer,smallint) AS Insert into players
      (playername,pokersite_id,cashhands,tourneyhands,optimizationstatus) values
      ($1,$2,$3,$4,$5) RETURNING player_id;

      PREPARE CSUpdate (integer,integer,smallint,smallint,smallint,integer,
      integer,integer,integer,integer,
      integer,integer,integer,integer,integer,
      integer,integer,integer,integer,integer,
      integer,integer,integer,integer,integer,
      integer,integer,integer,integer,integer,
      integer,integer,integer,integer,integer,
      integer,integer,integer,integer,integer,
      integer,integer,integer,integer,integer,
      integer,integer,integer,integer,integer,
      integer,integer,integer,integer,integer,
      integer,integer,integer,integer,integer,
      integer,integer,integer,integer,integer,
      integer,integer,integer,integer,integer,
      integer,integer,integer,integer,integer,
      integer,integer)
      as
      Update CompiledPlayerResults set totalhands = totalhands + $6
      , TotalAmountWonincents = TotalAmountWonincents + $7
      , TotalRakeincents = TotalRakeincents + $8
      , TotalBBsWon = TotalBBsWon + $9
      , VPIPHands = VPIPHands + $10
      , PFRHands = PFRHands + $11
      , CouldColdCall = CouldColdCall + $12
      , DidColdCall = DidColdCall + $13
      , CouldThreeBet = CouldThreeBet + $14
      , DidThreeBet = DidThreeBet + $15
      , CouldSqueeze = CouldSqueeze + $16
      , DidSqueeze = DidSqueeze + $17
      , FacingTwoPreflopRaisers = FacingTwoPreflopRaisers + $18
      , CalledTwoPreflopRaisers = CalledTwoPreflopRaisers + $19
      , RaisedTwoPreflopRaisers = RaisedTwoPreflopRaisers + $20
      , SmallBlindStealAttempted = SmallBlindStealAttempted + $21
      , SmallBlindStealDefended = SmallBlindStealDefended + $22
      , SmallBlindStealReraised = SmallBlindStealReraised + $23
      , BigBlindStealAttempted = BigBlindStealAttempted + $24
      , BigBlindStealDefended = BigBlindStealDefended + $25
      , BigBlindStealReraised = BigBlindStealReraised + $26
      , SawNonSmallShowdown = SawNonSmallShowdown + $27
      , WonNonSmallShowdown = WonNonSmallShowdown + $28
      , SawLargeShowdown = SawLargeShowdown + $29
      , WonLargeShowdown = WonLargeShowdown + $30
      , SawNonSmallShowdownLimpedFlop = SawNonSmallShowdownLimpedFlop + $31
      , WonNonSmallShowdownLimpedFlop = WonNonSmallShowdownLimpedFlop + $32
      , SawLargeShowdownLimpedFlop = SawLargeShowdownLimpedFlop + $33
      , WonLargeShowdownLimpedFlop = WonLargeShowdownLimpedFlop + $34
      , WonHand = WonHand + $35
      , WonHandWhenSawFlop = WonHandWhenSawFlop + $36
      , WonHandWhenSawTurn = WonHandWhenSawTurn + $37
      , WonHandWhenSawRiver = WonHandWhenSawRiver + $38
      , FacedThreeBetPreflop = FacedThreeBetPreflop + $39
      , FoldedToThreeBetPreflop = FoldedToThreeBetPreflop + $40
      , CalledThreeBetPreflop = CalledThreeBetPreflop + $41
      , RaisedThreeBetPreflop = RaisedThreeBetPreflop + $42
      , FacedFourBetPreflop = FacedFourBetPreflop + $43
      , FoldedToFourBetPreflop = FoldedToFourBetPreflop + $44
      , CalledFourBetPreflop = CalledFourBetPreflop + $45
      , RaisedFourBetPreflop = RaisedFourBetPreflop + $46
      , TurnFoldIPPassOnFlopCB = TurnFoldIPPassOnFlopCB + $47
      , TurnCallIPPassOnFlopCB = TurnCallIPPassOnFlopCB + $48
      , TurnRaiseIPPassOnFlopCB = TurnRaiseIPPassOnFlopCB + $49
      , RiverFoldIPPassOnTurnCB = RiverFoldIPPassOnTurnCB + $50
      , RiverCallIPPassOnTurnCB = RiverCallIPPassOnTurnCB + $51
      , RiverRaiseIPPassOnTurnCB = RiverRaiseIPPassOnTurnCB + $52
      , SawFlop = SawFlop + $53
      , SawShowdown = SawShowdown + $54
      , WonShowdown = WonShowdown + $55
      , TotalBets = TotalBets + $56
      , TotalCalls = TotalCalls + $57
      , FlopContinuationBetPossible = FlopContinuationBetPossible + $58
      , FlopContinuationBetMade = FlopContinuationBetMade + $59
      , TurnContinuationBetPossible = TurnContinuationBetPossible + $60
      , TurnContinuationBetMade = TurnContinuationBetMade + $61
      , RiverContinuationBetPossible = RiverContinuationBetPossible + $62
      , RiverContinuationBetMade = RiverContinuationBetMade + $63
      , FacingFlopContinuationBet = FacingFlopContinuationBet + $64
      , FoldedToFlopContinuationBet = FoldedToFlopContinuationBet + $65
      , CalledFlopContinuationBet = CalledFlopContinuationBet + $66
      , RaisedFlopContinuationBet = RaisedFlopContinuationBet + $67
      , FacingTurnContinuationBet = FacingTurnContinuationBet + $68
      , FoldedToTurnContinuationBet = FoldedToTurnContinuationBet + $69
      , CalledTurnContinuationBet = CalledTurnContinuationBet + $70
      , RaisedTurnContinuationBet = RaisedTurnContinuationBet + $71
      , FacingRiverContinuationBet = FacingRiverContinuationBet + $72
      , FoldedToRiverContinuationBet = FoldedToRiverContinuationBet + $73
      , CalledRiverContinuationBet = CalledRiverContinuationBet + $74
      , RaisedRiverContinuationBet = RaisedRiverContinuationBet + $75
      , TotalPostFlopStreetsSeen = TotalPostFlopStreetsSeen + $76
      , totalaggressivepostflopstreetsseen = totalaggressivepostflopstreetsseen
      + $77
      where compiledplayerresults_id = (select compiledplayerresults_id from
      compiledplayerresults where player_id = $1
      and playedyearandmonth = $2
      and numberofplayers = $3
      and gametype_id = $4
      and bbgroup_id = $5 limit 1);
  • 1 odpowiedź