Your username here MUST MATCH your XenForo username (connected to your XF license).

    Once you have registered here, then you need to 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

Not open for further replies.


AMS Premium
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:


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

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).
Not open for further replies.