Error 22012: division by zero
Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Dec 2008
    Posts
    58

    Default Error 22012: division by zero

    Hi,

    Since the last update I receive an error 22012 with the following custom stats.

    Before the update every ran correctly without any error.

    <Stat GroupName="Default" ColumnName="Base FTP"
    ValueExpressions="sum(round(cast(((cast(pkh.rakeam ount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP"
    Evaluate="FTP" ColumnHeader="Base FTP" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Full Tilt Points" />
    <Stat GroupName="Default" ColumnName="FTP/100"
    ValueExpressions="sum(round(cast(((cast(pkh.rakeam ount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTPHand"
    Evaluate="FTPHand/1.0/TotalHands*100" ColumnHeader="FTP/100" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Full Tilt Points per 100h" />
    <Stat GroupName="Default" ColumnName="BC FTP"
    ValueExpressions="sum(round(cast(((cast(pkh.rakeam ount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP"
    Evaluate="FTP*2.5" ColumnHeader="BC FTP" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Full Tilt Points" />
    <Stat GroupName="Default" ColumnName="BC FTP/100"
    ValueExpressions="sum(round(cast(((cast(pkh.rakeam ount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTPHand"
    Evaluate="FTPHand/1.0/TotalHands*250" ColumnHeader="BC FTP/100" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Full Tilt Points per 100h" />
    <Stat GroupName="Default" ColumnName="BC FTP $"
    ValueExpressions="sum(round(cast(((cast(pkh.rakeam ount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP"
    Evaluate="FTP*2.5*.0035" ColumnHeader="BC FTP $" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="BC FTP $ total" />
    <Stat GroupName="Default" ColumnName="$/100 From FTPs (BC)"
    ValueExpressions="sum(round(cast(((cast(pkh.rakeam ount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTPHand"
    Evaluate="FTPHand/1.0/TotalHands*250*.0035" ColumnHeader="BC $/100 from FTP" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="BC FTP $/100" />
    <Stat ColumnName="WCRake"
    ValueExpressions="SUM(pkh.rakeamount * (phmisc.postamountpreflop + phmisc.betamountpreflop + phmisc.callamountpreflop + COALESCE(flop.betamount + flop.callamount, 0) + COALESCE(turn.betamount + turn.callamount, 0) + COALESCE(river.betamount + river.callamount, 0)) * 1. / (pkh.potsize + pkh.rakeamount)) * 0.01 AS WCRake"
    Evaluate="WCRake" ColumnHeader="WC Rake" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Weighted Contributed Rake (including uncalled bets)" />
    <Stat ColumnName="WCRB"
    ValueExpressions="SUM(pkh.rakeamount * (phmisc.postamountpreflop + phmisc.betamountpreflop + phmisc.callamountpreflop + COALESCE(flop.betamount + flop.callamount, 0) + COALESCE(turn.betamount + turn.callamount, 0) + COALESCE(river.betamount + river.callamount, 0)) * 1. / (pkh.potsize + pkh.rakeamount)) * 0.0027 AS WCRB"
    Evaluate="WCRB" ColumnHeader="WC Rakeback" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="WCRB" />
    <Stat Groupname="Default" ColumnName="EV Earn"
    ValueExpressions="SUM(pkh.rakeamount * (phmisc.postamountpreflop + phmisc.betamountpreflop + phmisc.callamountpreflop + COALESCE(flop.betamount + flop.callamount, 0) + COALESCE(turn.betamount + turn.callamount, 0) + COALESCE(river.betamount + river.callamount, 0)) * 1. / (pkh.potsize + pkh.rakeamount)) * 0.0027 AS WCRB;sum(case when EV.SklanskyBucks <> 0 or (EV.SklanskyBucks = 0 and EV.EquityPct = 500) then EV.SklanskyBucks else ph.NetAmountWon end) as SklanskyAdjustedWinnings;sum(round(cast(((cast(pkh .rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP;"
    Evaluate="(WCRB+(SklanskyAdjustedWinnings/100.0)+(FTP*2.5*.0035))" ColumnHeader="EVEarn" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="EVEarn" />

    Thanks for your help

    EDIT : is it possible to downgrade the version of HM ?
    Last edited by MoTh; 02-13-2011 at 07:28 PM.

  2. #2
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

  3. #3
    Senior Member
    Join Date
    May 2009
    Posts
    159

    Default

    Can you give a little insight why this happens?

    The problem must occur during import. (I downgraded after 1.11.06a import to 1.11.05d and the error was still there.)

    Can you put up the 1.11.05e for download please.
    Last edited by lonelycube; 02-27-2011 at 11:52 AM. Reason: spelling

Similar Threads

  1. Replies: 1
    Last Post: 12-17-2010, 03:59 PM
  2. Database division ...
    By rktnan in forum Manager General
    Replies: 1
    Last Post: 09-21-2009, 09:54 PM
  3. Replies: 3
    Last Post: 09-13-2009, 08:48 AM
  4. Error: 22012
    By nugget in forum Manager General
    Replies: 1
    Last Post: 11-10-2008, 01:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •