Calendar Unknown column 'event_image_required' in 'field list'

[Alpha1]

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'event_image_required' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Alfa, A moment ago

Stack Trace
#0 /library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('UPDATE `xf_nf_e...')
#1 /library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'UPDATE `xf_nf_e...')
#2 /library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('UPDATE `xf_nf_e...')
#3 /library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_nf_e...', Array)
#4 /library/XenForo/DataWriter.php(1654): Zend_Db_Adapter_Abstract->update('xf_nf_event_cal...', Array, '(calendar_id = ...')
#5 /library/XenForo/DataWriter.php(1623): XenForo_DataWriter->_update()
#6 /library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#7 /library/NixFifty/Calendar/ControllerAdmin/Calendar.php(153): XenForo_DataWriter->save()
#8 /library/XenForo/FrontController.php(369): NixFifty_Calendar_ControllerAdmin_Calendar->actionSave()
#9 /library/XenForo/FrontController.php(152): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /admin.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
["url"] => string(62) "https://my-forum.com/admin.php?event-calendar/events.1/save"
["_GET"] => array(1) {
["event-calendar/events_1/save"] => string(0) ""
}
["_POST"] => array(15) {
["calendar_title"] => string(6) "Events"
["calendar_description"] => string(0) ""
["parent_calendar_id"] => string(1) "0"
["display_order"] => string(1) "1"
["thread_node_id"] => string(3) "394"
["thread_prefix_id"] => string(1) "0"
["event_image_required"] => string(1) "1"
["background_color"] => string(6) "01579B"
["border_color"] => string(6) "002F6C"
["text_color"] => string(6) "FFFFFF"
["min_tags"] => string(1) "0"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(39) "/admin.php?event-calendar/events.1/edit"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}

 

[Naz]

Run this:

ALTER TABLE `xf_nf_calendar_event` ADD COLUMN `event_image_required` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

Looks like your opcache might've prevented the step from running on upgrade.

 

[Alpha1]

Mhm. I have just deleted all Calendar files from my serfver, reuploaded, then reinstalled. Same result.

 

[Naz]

That wouldn't clear your opcache. Also, the same upgrade worked fine here and you can see the query itself on line 149 of the installer.

 

[Alpha1]

Clearing opcache had no effect. I also cleared CloudFlare cache.

 

[Alpha1]

This seems related:
https://nixfifty.com/threads/v1-0-9-undefined-index-event_image_required.8676/

 

[Alpha1]

ALTER TABLE `xf_nf_calendar_event` ADD COLUMN `event_image_required` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';

result:

#1060 - Duplicate column name 'event_image_required'