[TYPO3-calendar] Not possible to save event in FE

[Mario Matzulla]

Hi Christian,

Am 18.06.15 um 14:11 schrieb Christian Welzel:
> Hi there,
> 
> i updated an old 4.5 installation to 6.2 with latest cal.
> Before the update i could safe events in the frontend.
> 
> Now i cannot. The error is:
> 
> exec_INSERTquery
> 
> caller     TYPO3\CMS\Core\Database\DatabaseConnection::exec_INSERTquery
> 
> ERROR     Column 'type' cannot be null
> 
> lastBuiltQuery     INSERT INTO tx_cal_event
> (pid,tstamp,crdate,hidden,type,allday,start_date,start_time,end_date,end_time,title,organizer,location,location_id,teaser,description,calendar_id,cruser_id,fe_cruser_id)
> VALUES ('23','1434629288','1434629288','0',NULL,'0','20150618','68400','20150618','75600','test','',NULL,'2','test','test','1','1','1')
> 
> debug_backtrace
> require(3/typo3/sysext/cms/tslib/index_ts.php),3/index.php#28 //
> TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->INTincScript#232 //
> TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->recursivelyReplaceIntPlaceholdersInContent#3638 //
> TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->INTincScript_process#3671 //
> TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->USER#3723 // TYPO3\CMS\Frontend\ContentObject\UserContentObject->render#862 //
> TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->callUserFunction#41 // call_user_func_array#6634 // tx_cal_controller->main# //
> tx_cal_controller->getContent#100 // tx_cal_controller->saveEvent#189 // tx_cal_modelcontroller->saveEvent#657 //
> tx_cal_event_service->saveEvent#85 // tx_cal_event_service->_saveEvent#621 //
> TYPO3\CMS\Core\Database\DatabaseConnection->exec_INSERTquery#661 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#218
> 
> i'm not sure how to set this type-field to non-NULL...
> The database is set to "not null default 0".
> 
> 

Please compare your create_event.tmpl and confirm_event.tmpl template with one shipped with cal. There you will find a ###TYPE### marker
somewhere. This will add the missing value to your dataset.

Regards,
Mario