Calendar Beta 8: Error on when deleting a event

When I delete a event I got this server error

Server Error
Mysqli statement execute error : BIGINT UNSIGNED value is out of range in '`mydatabase`.`xf_user`.`nf_calendar_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 NixFifty/Calendar/DataWriter/Event.php at line 969
  4. NixFifty_Calendar_DataWriter_Event->_eventRemoved() in NixFifty/Calendar/DataWriter/Event.php at line 864
  5. NixFifty_Calendar_DataWriter_Event->_postDelete() in XenForo/DataWriter.php at line 1793
  6. XenForo_DataWriter->delete() in NixFifty/Calendar/ControllerPublic/Event.php at line 521
  7. NixFifty_Calendar_ControllerPublic_Event->actionDelete() in XenForo/FrontController.php at line 369
  8. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 152
  9. XenForo_FrontController->run() in /home/public/sites/www.mysite.com/index.php at line 13
 
Solved.

it was a "old" event, How did i fix it?
1: remove for public view
2: delete permanently
Now it's gone without any error.

New event created and removing on the normal way without any issue.
 
I think in a very early version, user event counts weren't being updated. So you probably had a user who had an event but their event count was still 0. When you deleted that, it tried to minus 1 from the user's event count but since it was already 0, it got confused and broke.

Nonetheless, this is fixed in the next version. :D
 
Back
Top