Calendar Unknown column 'event_image_required' in 'field list'

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"
}
}
 
Run this:
Code:
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.
 
Mhm. I have just deleted all Calendar files from my serfver, reuploaded, then reinstalled. Same result.
 
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.
 
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'
 
Back
Top