Fixed Weird Error

[oman]

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

 

[Bob]

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).