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.

Fixed Weird Error

Discussion in 'Sportsbook Resolved Bug Reports' started by oman, Jan 30, 2014.

  1. oman

    oman Member AMS Premium Showcase

    I deleted the archive for Sportsbook as we would normally do.

    The following error came up:

    Server Error
    Mysqli statement execute error : BIGINT UNSIGNED value is out of range in '(`nzwarrio_fans`.`xf_nflj_sportsbook_category`.`event_count` - 1)'

    1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    3. Zend_Db_Adapter_Abstract->query() in NFLJ/Sportsbook/Model/Category.php at line 822
    4. NFLJ_Sportsbook_Model_Category->updateEventCount() in NFLJ/Sportsbook/DataWriter/Event.php at line 211
    5. NFLJ_Sportsbook_DataWriter_Event->_updateRemoveCategoryEventsCount() in NFLJ/Sportsbook/DataWriter/Event.php at line 305
    6. NFLJ_Sportsbook_DataWriter_Event->_postDelete() in XenForo/DataWriter.php at line 1767
    7. XenForo_DataWriter->delete() in NFLJ/Sportsbook/Model/Event.php at line 654
    8. NFLJ_Sportsbook_Model_Event->deleteEvents() in NFLJ/Sportsbook/ControllerAdmin/Event.php at line 88
    9. NFLJ_Sportsbook_ControllerAdmin_Event->actionDeleteArchive() in XenForo/FrontController.php at line 347
    10. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    11. XenForo_FrontController->run() in /home/nzwarrio/public_html/www.nzwarriorsfans.com/admin.php at line 13
    Also, the events which had a discussion thread got a post at the end saying it had been removed. (I gather this is as designed)

    Though, the actual text came up like this:

    nflj_sportsbook_event_has_been_removed

    Is that meant to be like that, or is it meant to be a normal sentence?

    oman
     
  2. Bob

    Bob Developer Staff Member

    Looks like you ran the Delete Archive (which completely wipes Sportsbook Clean) and that there was some manual DB work done that through off the event counts on the categories. This has all changed in the new version anyway, so I wouldn't worry about it. SB 1.3.0 Beta 2 should be available today :)

    as far as the nflj_sportsbook_event_has_been_removed. This is supposed to be a phrase, but when I created it, I forgot to associate it with the addon. Its now associated, so the next upgrade will have the actual phrase (altho, it won't change the posts).
     
  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.