1. REGISTRATION REQUIREMENTS:

    Register with your xenforo.com Username then start a conversation at xenforo.com w/Bob and provide the following:
    1. Your XenForo License Validation Token
    2. The Domain Name associated with the License
    NOTE: Your account will be validated once ALL requirements are verified/met. Thank you for your patience.

As Designed Urgent - I'm getting this error

Discussion in 'Sportsbook Resolved Bug Reports' started by ineedhelp, Apr 5, 2013.

  1. ineedhelp

    ineedhelp New Member Sportsbook

    I'm getting this error when I enter a large number like million etc.

    Code:
    Mysqli statement execute error : Out of range value for column 'amount_staked' at row 1
    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in NFLJ/Sportsbook/DataWriter/Wager.php at line 76
    NFLJ_Sportsbook_DataWriter_Wager->_postSave() in XenForo/DataWriter.php at line 1385
    XenForo_DataWriter->save() in NFLJ/Sportsbook/ControllerPublic/Wager.php at line 42
    NFLJ_Sportsbook_ControllerPublic_Wager->actionAdd() in XenForo/FrontController.php at line 310
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
    XenForo_FrontController->run() in /var/www/vhosts/barfilounge.com/httpdocs/index.php at line 13
    Solution please.
     
  2. Bob

    Bob Developer Staff Member

    its an int(10) field. There is NO WAY that its throwing that error on a MILLION. I have people making 100 mil wagers for the past 2 years. Something else is up.

    Are you running STOCK sportsbook? and which version?
     
  3. ineedhelp

    ineedhelp New Member Sportsbook

    The weird thing is. It only seems to be effecting one event. Others function fine as they should. It was created about 2 months ago I think and it's going to end tomorrow. Placing large wagers worked before on this event. Maybe it's something to do with the date?

    I only have your sports book 1.0.4 your latest version.
     
  4. Bob

    Bob Developer Staff Member

    As you can see here, I just placed a 30,000,000.00 wager on an outcome.

    error.png
     
  5. ineedhelp

    ineedhelp New Member Sportsbook

    Yes I can do that as well on other events. I can only place thousands or hundreds on the effected event.
     
  6. Bob

    Bob Developer Staff Member

    and you've made NO modifications? Date wouldn't effect it. that error is saying that the data being passed in the variable doesn't not match. Is the event public? ie, can I see it, I'd like to see what the data in the template looks like.
     
  7. ineedhelp

    ineedhelp New Member Sportsbook

    Yes you can see it. The link to the site is in the error code.

    If changes were made incorrectly it wouldn't have saved the changes.
     
  8. Bob

    Bob Developer Staff Member

    which event tho lol
     
  9. ineedhelp

    ineedhelp New Member Sportsbook

    Oh yeah. The second last one at the bottom. It has 59 wagers so far. English Premier League. Football.
     
  10. Bob

    Bob Developer Staff Member

    ah, well, I see the issue. You are maxing out the unsigned INT(10). An unsigned INT has the max value of 4294967295 no matter if its INT(1) or int(10) and will use 4 bytes of data.

    The MAX = 4,294,967,295.00

    What that event is currently sitting at = 4,293,814,292.00

    You'll need to modify the field and change the unsigned INT(10) to an unsigned BIGINT
     
  11. Bob

    Bob Developer Staff Member

    btw, you will have to do the same to the same field in the event table (amount_staked)
     
  12. ineedhelp

    ineedhelp New Member Sportsbook

    Can you do a quick addon update for this. It maybe effecting others too.

    How do I make the changes including the BIGINT change?
     
  13. ineedhelp

    ineedhelp New Member Sportsbook

    This addon also deletes all member credits when editing member profiles via ACP.

    I'm using the Credits addon.
     
  14. Bob

    Bob Developer Staff Member

    No, I will be releasing a brand new version of Sportsbook in about a week or two.

    In the mean time you can easily modify the 2 fields via phpMyAdmin (takes about 30 seconds).

    Well aware of this which is why I sent out an EMAIL Blast last week to all license holders pointing them to the HOT FIX that is posted here that fixes the issue.
     
    ineedhelp likes this.
  15. ineedhelp

    ineedhelp New Member Sportsbook

    Problem solved. Thanks!
     
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.