Error with Contao 4.9.20 and Strict Mode and [Craffft / contao-calendar-ical-bundle]

When using Contao 4.9.20 and MySQL strict mode and [Craffft / contao-calendar-ical-bundle] (or maybe other extensions that write to tl_calendar_events), events cannot be created (error message below).

In the Contao forums, spooky pointed out that maybe these lines should be changed to:

$arrSet['bookingStartDate'] = $dc->activeRecord->bookingStartDate ?: null; $arrSet['bookingEndDate'] = $dc->activeRecord->bookingEndDate ?: null;

Error message: [2021-08-25 17:38:08] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'INSERT INTO tl_calendar_events (pid,tstamp,title,alias,author,addTime,startTime,endTime,startDate,endDate,pageTitle,description,location,address,teaser,addImage,overwriteMeta,singleSRC,alt,imageTitle,size,imagemargin,imageUrl,fullsize,caption,floating,recurring,repeatEach,repeatEnd,recurrences,addEnclosure,enclosure,orderEnclosure,source,jumpTo,articleId,url,target,cssClass,noComments,published,start,stop,unsubscribeLimit,enableDeregistration,eventBookingNotificationSender,eventBookingNotificationCenterIds,enableNotificationCenter,maxEscortsPerMember,maxMembers,bookingStartDate,bookingEndDate,addBookingForm,city,postal,street,enableMultiBookingWithSameAddress,featured,unsubscribeLimitTstamp,categories,cssStyleSelector) VALUES ('3', 1629905888, 'BELEGT', '', '1', '', 1631224800, 1631397600, 1631224800, 1631397600, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'above', '', '', '0', '0', '', '', '', 'default', '0', '0', '', '', '', '', 1, '', '', '0', '', '0', '', '', 0, 0, '', '', '', '', '', '', '', '', '', '', '')': SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'bookingStartDate' at row 1" at /contao49/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'INSERT INTO tl_calendar_events (pid,tstamp,title,alias,author,addTime,startTime,endTime,startDate,endDate,pageTitle,description,location,address,teaser,addImage,overwriteMeta,singleSRC,alt,imageTitle,size,imagemargin,imageUrl,fullsize,caption,floating,recurring,repeatEach,repeatEnd,recurrences,addEnclosure,enclosure,orderEnclosure,source,jumpTo,articleId,url,target,cssClass,noComments,published,start,stop,unsubscribeLimit,enableDeregistration,eventBookingNotificationSender,eventBookingNotificationCenterIds,enableNotificationCenter,maxEscortsPerMember,maxMembers,bookingStartDate,bookingEndDate,addBookingForm,city,postal,street,enableMultiBookingWithSameAddress,featured,unsubscribeLimitTstamp,categories,cssStyleSelector) VALUES ('3', 1629905888, 'BELEGT', '', '1', '', 1631224800, 1631397600, 1631224800, 1631397600, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'above', '', '', '0', '0', '', '', '', 'default', '0', '0', '', '', '', '', 1, '', '', '0', '', '0', '', '', 0, 0, '', '', '', '', '', '', '', '', '', '', '')':\n\nSQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'bookingStartDate' at row 1 at /contao49/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: HY000): SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'bookingStartDate' at row 1 at /homepages/0/d180520326/htdocs/contao49/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'bookingStartDate' at row 1 at /contao49/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:132)"} []

Hi Jo I've fixed the issue in 4665db0. Would you test version 4.1.6 and give me feedback? Cheers Marko

Hi Marko, thank you for the quick reaction and fix. Unfortunately, in my test installation (Contao 4.9.20, strict mode, iCal Calendar / Calendar Event Booking Bundle), I still get the following error and the calendar is empty:

An exception occurred while executing 'INSERT INTO tl_calendar_events (`pid`, `tstamp`, `title`, `alias`, `author`, `addTime`, `startTime`, `endTime`, `startDate`, `endDate`, `pageTitle`, `description`, `location`, `address`, `teaser`, `addImage`, `overwriteMeta`, `singleSRC`, `alt`, `imageTitle`, `size`, `imagemargin`, `imageUrl`, `fullsize`, `caption`, `floating`, `recurring`, `repeatEach`, `repeatEnd`, `recurrences`, `addEnclosure`, `enclosure`, `orderEnclosure`, `source`, `jumpTo`, `articleId`, `url`, `target`, `cssClass`, `noComments`, `published`, `start`, `stop`, `unsubscribeLimitTstamp`, `unsubscribeLimit`, `enableDeregistration`, `eventBookingNotificationSender`, `eventBookingNotificationCenterIds`, `enableNotificationCenter`, `includeEscortsWhenCalculatingRegCount`, `maxEscortsPerMember`, `maxMembers`, `minMembers`, `bookingEndDate`, `bookingStartDate`, `enableMultiBookingWithSameAddress`, `addBookingForm`, `city`, `postal`, `street`) VALUES ('1', 1630395250, 'BELEGT', '', '1', '', 1631224800, 1631397600, 1631224800, 1631397600, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'above', '', '', '0', '0', '', '', '', 'default', '0', '0', '', '', '', '', 1, '', '', '', '0', '', '0', '', '', 0, 0, 0, 0, '', '', '', '', '', '', '')':

SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'unsubscribeLimitTstamp' at row 1

(Caches are emptied etc.) Apparently, more fields are concerned by the strict mode ...

Hi Jo I do not understand why this error occurs. The field uses a save_callback that only returns NULL or an integer. But you've got an empty string as a value for tl_calendar_events.unsubscribeLimitTstamp. https://github.com/markocupic/calendar-event-booking-bundle/blob/4665db06c8ef3dc199245a5037220f8121f0b9ef/src/Contao/Dca/TlCalendarEvents.php#L79 Is it true? The error occurs in the backend when you try to create a new event? Could you post the whole stack trace, please?

Hi Marko Couldn't make it any earlier, unfortunately. Here is what happens:

First, I installed Crafft/iCal Calendar and entered the ics-calendar url for the Google Calendar
The events from the Google Calendar are the automatically created as single events
Then I install the calendar event booking bundle and open the calendar settings page in order to set the page for the unsubscription module; when I save the settings, I get the error message and the events from Google are gone
I can create events in the backend and save them without any error or problem, but the events from the Google Calendar won't show up
Once I created an event in the calendar (manually), the error message won't appear, but I get them in the logs when iCal tries to sync with the Google Calendar
Creating a new calendar brings back the error message

I am more than willing to provide more information, just tell me what you need. Here's the stack trace:

[3/3] DriverException Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO tl_calendar_events (pid,tstamp,title,alias,author,addTime,startTime,endTime,startDate,endDate,pageTitle,description,location,address,teaser,addImage,overwriteMeta,singleSRC,alt,imageTitle,size,imagemargin,imageUrl,fullsize,caption,floating,recurring,repeatEach,repeatEnd,recurrences,addEnclosure,enclosure,orderEnclosure,source,jumpTo,articleId,url,target,cssClass,noComments,published,start,stop,unsubscribeLimitTstamp,unsubscribeLimit,enableDeregistration,eventBookingNotificationSender,eventBookingNotificationCenterIds,enableNotificationCenter,includeEscortsWhenCalculatingRegCount,maxEscortsPerMember,maxMembers,minMembers,bookingEndDate,bookingStartDate,enableMultiBookingWithSameAddress,addBookingForm,city,postal,street`) VALUES ('2', 1630933546, 'BELEGT', '', '1', '', 1631224800, 1631397600, 1631224800, 1631397600, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'above', '', '', '0', '0', '', '', '', 'default', '0', '0', '', '', '', '', 1, '', '', '', '0', '', '0', '', '', 0, 0, 0, 0, '', '', '', '', '', '', '')':

SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'unsubscribeLimitTstamp' at row 1

at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128 at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception occurred while executing \'INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'2\', 1630933546, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', \'0\', \'\', \'0\', \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')\':SQLSTATE[HY000]: General error: 1366 Incorrect integer value: \'\' for column \'unsubscribeLimitTstamp\' at row 1', object(Exception)) (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182) at Doctrine\DBAL\DBALException::wrapException(object(Driver), object(Exception), 'An exception occurred while executing \'INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'2\', 1630933546, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', \'0\', \'\', \'0\', \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')\':SQLSTATE[HY000]: General error: 1366 Incorrect integer value: \'\' for column \'unsubscribeLimitTstamp\' at row 1') (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:159) at Doctrine\DBAL\DBALException::driverExceptionDuringQuery(object(Driver), object(Exception), 'INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'2\', 1630933546, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', \'0\', \'\', \'0\', \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')', array()) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:2212) at Doctrine\DBAL\Connection->handleExceptionDuringQuery(object(Exception), 'INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'2\', 1630933546, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', \'0\', \'\', \'0\', \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')', array(), array()) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1299) at Doctrine\DBAL\Connection->executeQuery('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'2\', 1630933546, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', \'0\', \'\', \'0\', \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')') (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274) at Contao\Database\Statement->query() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248) at Contao\Database\Statement->execute() (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:918) at Contao\CalendarImport->importFromICS('2', object(Date), object(Date), true, array('X-WR-TIMEZONE', 'Europe/Zurich'), true) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:143) at Contao\CalendarImport->importFromWebICS('2', 'https://calendar.google.com/calendar/ical/***group.calendar.google.com/***/basic.ics', object(Date), object(Date), array('CET', 'CET'), '', '', null) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:110) at Contao\CalendarImport->importCalendarWithData(array('id' => '2', 'tstamp' => '0', 'title' => 'test (copy)', 'jumpTo' => '5', 'protected' => '', 'groups' => null, 'allowComments' => '', 'notify' => 'notify_admin', 'sortOrder' => 'ascending', 'perPage' => '0', 'moderate' => '', 'bbcode' => '', 'requireLogin' => '', 'disableCaptcha' => '', 'ical_importing' => '1', 'ical_source_end' => '1661551200', 'ical_source_start' => '1630015200', 'ical_end' => '1661581719', 'ical_start' => '1630045719', 'ical_cache' => '10', 'ical_replacement_event_title' => '', 'ical_pattern_event_title' => '', 'ical_filter_event_title' => '', 'ical_port' => null, 'ical_bnpw' => '', 'ical_proxy' => '', 'ical_url' => 'https://calendar.google.com/calendar/ical/***group.calendar.google.com/***/basic.ics', 'ical_description' => null, 'ical_prefix' => '', 'ical_alias' => '', 'ical_source' => '1', 'ical_timezone' => 'CET', 'make_ical' => '', 'eventUnsubscribePage' => '1')) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:74) at Contao\CalendarImport->importCalendarWithID('2') (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:53) at Contao\CalendarImport->importFromURL(object(DC_Table)) (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:2121) at Contao\DC_Table->edit() (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:644) at Contao\Backend->getBackendModule('calendar', null) (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:167) at Contao\BackendMain->run() (vendor/contao/core-bundle/src/Controller/BackendController.php:48) at Contao\CoreBundle\Controller\BackendController->mainAction() (vendor/symfony/http-kernel/HttpKernel.php:158) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/http-kernel/HttpKernel.php:80) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (vendor/symfony/http-kernel/Kernel.php:201) at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) (web/index.php:31)
`

`[2/3] Exception Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'unsubscribeLimitTstamp' at row 1

at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException)) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:134) at Doctrine\DBAL\Driver\PDOConnection->doQuery('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'2\', 1630933546, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', \'0\', \'\', \'0\', \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')') (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php:36) at Doctrine\DBAL\Driver\PDOConnection->query('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'2\', 1630933546, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', \'0\', \'\', \'0\', \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')') (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1295) at Doctrine\DBAL\Connection->executeQuery('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'2\', 1630933546, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', \'0\', \'\', \'0\', \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')') (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274) at Contao\Database\Statement->query() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248) at Contao\Database\Statement->execute() (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:918) at Contao\CalendarImport->importFromICS('2', object(Date), object(Date), true, array('X-WR-TIMEZONE', 'Europe/Zurich'), true) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:143) at Contao\CalendarImport->importFromWebICS('2', 'https://calendar.google.com/calendar/ical/***group.calendar.google.com/***/basic.ics', object(Date), object(Date), array('CET', 'CET'), '', '', null) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:110) at Contao\CalendarImport->importCalendarWithData(array('id' => '2', 'tstamp' => '0', 'title' => 'test (copy)', 'jumpTo' => '5', 'protected' => '', 'groups' => null, 'allowComments' => '', 'notify' => 'notify_admin', 'sortOrder' => 'ascending', 'perPage' => '0', 'moderate' => '', 'bbcode' => '', 'requireLogin' => '', 'disableCaptcha' => '', 'ical_importing' => '1', 'ical_source_end' => '1661551200', 'ical_source_start' => '1630015200', 'ical_end' => '1661581719', 'ical_start' => '1630045719', 'ical_cache' => '10', 'ical_replacement_event_title' => '', 'ical_pattern_event_title' => '', 'ical_filter_event_title' => '', 'ical_port' => null, 'ical_bnpw' => '', 'ical_proxy' => '', 'ical_url' => 'https://calendar.google.com/calendar/ical/***group.calendar.google.com/***/basic.ics', 'ical_description' => null, 'ical_prefix' => '', 'ical_alias' => '', 'ical_source' => '1', 'ical_timezone' => 'CET', 'make_ical' => '', 'eventUnsubscribePage' => '1')) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:74) at Contao\CalendarImport->importCalendarWithID('2') (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:53) at Contao\CalendarImport->importFromURL(object(DC_Table)) (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:2121) at Contao\DC_Table->edit() (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:644) at Contao\Backend->getBackendModule('calendar', null) (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:167) at Contao\BackendMain->run() (vendor/contao/core-bundle/src/Controller/BackendController.php:48) at Contao\CoreBundle\Controller\BackendController->mainAction() (vendor/symfony/http-kernel/HttpKernel.php:158) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/http-kernel/HttpKernel.php:80) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (vendor/symfony/http-kernel/Kernel.php:201) at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) (web/index.php:31)`

`[1/3] PDOException PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'unsubscribeLimitTstamp' at row 1

at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:132 at PDO->query('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'2\', 1630933546, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', \'0\', \'\', \'0\', \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')') (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:132) at Doctrine\DBAL\Driver\PDOConnection->doQuery('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'2\', 1630933546, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', \'0\', \'\', \'0\', \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')') (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php:36) at Doctrine\DBAL\Driver\PDOConnection->query('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'2\', 1630933546, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', \'0\', \'\', \'0\', \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')') (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1295) at Doctrine\DBAL\Connection->executeQuery('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'2\', 1630933546, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', \'0\', \'\', \'0\', \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')') (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274) at Contao\Database\Statement->query() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248) at Contao\Database\Statement->execute() (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:918) at Contao\CalendarImport->importFromICS('2', object(Date), object(Date), true, array('X-WR-TIMEZONE', 'Europe/Zurich'), true) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:143) at Contao\CalendarImport->importFromWebICS('2', 'https://calendar.google.com/calendar/ical/***group.calendar.google.com/***/basic.ics', object(Date), object(Date), array('CET', 'CET'), '', '', null) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:110) at Contao\CalendarImport->importCalendarWithData(array('id' => '2', 'tstamp' => '0', 'title' => 'test (copy)', 'jumpTo' => '5', 'protected' => '', 'groups' => null, 'allowComments' => '', 'notify' => 'notify_admin', 'sortOrder' => 'ascending', 'perPage' => '0', 'moderate' => '', 'bbcode' => '', 'requireLogin' => '', 'disableCaptcha' => '', 'ical_importing' => '1', 'ical_source_end' => '1661551200', 'ical_source_start' => '1630015200', 'ical_end' => '1661581719', 'ical_start' => '1630045719', 'ical_cache' => '10', 'ical_replacement_event_title' => '', 'ical_pattern_event_title' => '', 'ical_filter_event_title' => '', 'ical_port' => null, 'ical_bnpw' => '', 'ical_proxy' => '', 'ical_url' => 'https://calendar.google.com/calendar/ical/***group.calendar.google.com/***/basic.ics', 'ical_description' => null, 'ical_prefix' => '', 'ical_alias' => '', 'ical_source' => '1', 'ical_timezone' => 'CET', 'make_ical' => '', 'eventUnsubscribePage' => '1')) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:74) at Contao\CalendarImport->importCalendarWithID('2') (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:53) at Contao\CalendarImport->importFromURL(object(DC_Table)) (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:2121) at Contao\DC_Table->edit() (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:644) at Contao\Backend->getBackendModule('calendar', null) (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:167) at Contao\BackendMain->run() (vendor/contao/core-bundle/src/Controller/BackendController.php:48) at Contao\CoreBundle\Controller\BackendController->mainAction() (vendor/symfony/http-kernel/HttpKernel.php:158) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/http-kernel/HttpKernel.php:80) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (vendor/symfony/http-kernel/Kernel.php:201) at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) (web/index.php:31)`

OK. It looks like the exception is throwed in the Ical extension. CalendarImport::importFromICS() traverses the DCA and checks if a default value was set for each field. If this is not the case the extension takes an empty string as default value. But this is not a good idea if the field requires an integer.

It would be better not to set those empty fields at all and let the database set the correct empty value upon new inserts.

As a workaround I added the 'default' key to all these fields in the DCA.

Please update calendar-event-booking-bundle again and give me feedback.

Hm, I still get the same error. But if the error initially is caused by the ical-Bundle, I'd maybe post it there - ?

[3/3] DriverException Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO tl_calendar_events (pid,tstamp,title,alias,author,addTime,startTime,endTime,startDate,endDate,pageTitle,description,location,address,teaser,addImage,overwriteMeta,singleSRC,alt,imageTitle,size,imagemargin,imageUrl,fullsize,caption,floating,recurring,repeatEach,repeatEnd,recurrences,addEnclosure,enclosure,orderEnclosure,source,jumpTo,articleId,url,target,cssClass,noComments,published,start,stop,unsubscribeLimitTstamp,unsubscribeLimit,enableDeregistration,eventBookingNotificationSender,eventBookingNotificationCenterIds,enableNotificationCenter,includeEscortsWhenCalculatingRegCount,maxEscortsPerMember,maxMembers,minMembers,bookingEndDate,bookingStartDate,enableMultiBookingWithSameAddress,addBookingForm,city,postal,street`) VALUES ('4', 1631169505, 'BELEGT', '', '1', '', 1631224800, 1631397600, 1631224800, 1631397600, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'above', '', '', '0', '0', '', '', '', 'default', '0', '0', '', '', '', '', 1, '', '', '', 0, '', 0, '', '', 0, 0, 0, 0, '', '', '', '', '', '', '')':

SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'unsubscribeLimitTstamp' at row 1

at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128 at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception occurred while executing \'INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'4\', 1631169505, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', 0, \'\', 0, \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')\':SQLSTATE[HY000]: General error: 1366 Incorrect integer value: \'\' for column \'unsubscribeLimitTstamp\' at row 1', object(Exception)) (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182) at Doctrine\DBAL\DBALException::wrapException(object(Driver), object(Exception), 'An exception occurred while executing \'INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'4\', 1631169505, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', 0, \'\', 0, \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')\':SQLSTATE[HY000]: General error: 1366 Incorrect integer value: \'\' for column \'unsubscribeLimitTstamp\' at row 1') (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:159) at Doctrine\DBAL\DBALException::driverExceptionDuringQuery(object(Driver), object(Exception), 'INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'4\', 1631169505, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', 0, \'\', 0, \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')', array()) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:2212) at Doctrine\DBAL\Connection->handleExceptionDuringQuery(object(Exception), 'INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'4\', 1631169505, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', 0, \'\', 0, \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')', array(), array()) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1299) at Doctrine\DBAL\Connection->executeQuery('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'4\', 1631169505, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', 0, \'\', 0, \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')') (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274) at Contao\Database\Statement->query() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248) at Contao\Database\Statement->execute() (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:918) at Contao\CalendarImport->importFromICS('4', object(Date), object(Date), true, array('X-WR-TIMEZONE', 'Europe/Zurich'), true) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:143) at Contao\CalendarImport->importFromWebICS('4', 'https://calendar.google.com/calendar/ical/***/basic.ics', object(Date), object(Date), array('CET', 'CET'), '', '', null) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:110) at Contao\CalendarImport->importCalendarWithData(array('id' => '4', 'tstamp' => '0', 'title' => 'test (copy) 3', 'jumpTo' => '5', 'protected' => '', 'groups' => null, 'allowComments' => '', 'notify' => 'notify_admin', 'sortOrder' => 'ascending', 'perPage' => '0', 'moderate' => '', 'bbcode' => '', 'requireLogin' => '', 'disableCaptcha' => '', 'ical_importing' => '1', 'ical_source_end' => '1661551200', 'ical_source_start' => '1630015200', 'ical_end' => '1661581719', 'ical_start' => '1630045719', 'ical_cache' => '10', 'ical_replacement_event_title' => '', 'ical_pattern_event_title' => '', 'ical_filter_event_title' => '', 'ical_port' => null, 'ical_bnpw' => '', 'ical_proxy' => '', 'ical_url' => 'https://calendar.google.com/calendar/ical/***/basic.ics', 'ical_description' => null, 'ical_prefix' => '', 'ical_alias' => '', 'ical_source' => '1', 'ical_timezone' => 'CET', 'make_ical' => '', 'eventUnsubscribePage' => '1')) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:74) at Contao\CalendarImport->importCalendarWithID('4') (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:53) at Contao\CalendarImport->importFromURL(object(DC_Table)) (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:2121) at Contao\DC_Table->edit() (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:644) at Contao\Backend->getBackendModule('calendar', null) (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:167) at Contao\BackendMain->run() (vendor/contao/core-bundle/src/Controller/BackendController.php:48) at Contao\CoreBundle\Controller\BackendController->mainAction() (vendor/symfony/http-kernel/HttpKernel.php:158) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/http-kernel/HttpKernel.php:80) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (vendor/symfony/http-kernel/Kernel.php:201) at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) (web/index.php:31)

[2/3] Exception Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'unsubscribeLimitTstamp' at row 1

at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException)) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:134) at Doctrine\DBAL\Driver\PDOConnection->doQuery('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'4\', 1631169505, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', 0, \'\', 0, \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')') (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php:36) at Doctrine\DBAL\Driver\PDOConnection->query('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'4\', 1631169505, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', 0, \'\', 0, \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')') (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1295) at Doctrine\DBAL\Connection->executeQuery('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'4\', 1631169505, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', 0, \'\', 0, \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')') (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274) at Contao\Database\Statement->query() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248) at Contao\Database\Statement->execute() (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:918) at Contao\CalendarImport->importFromICS('4', object(Date), object(Date), true, array('X-WR-TIMEZONE', 'Europe/Zurich'), true) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:143) at Contao\CalendarImport->importFromWebICS('4', 'https://calendar.google.com/calendar/ical/***/basic.ics', object(Date), object(Date), array('CET', 'CET'), '', '', null) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:110) at Contao\CalendarImport->importCalendarWithData(array('id' => '4', 'tstamp' => '0', 'title' => 'test (copy) 3', 'jumpTo' => '5', 'protected' => '', 'groups' => null, 'allowComments' => '', 'notify' => 'notify_admin', 'sortOrder' => 'ascending', 'perPage' => '0', 'moderate' => '', 'bbcode' => '', 'requireLogin' => '', 'disableCaptcha' => '', 'ical_importing' => '1', 'ical_source_end' => '1661551200', 'ical_source_start' => '1630015200', 'ical_end' => '1661581719', 'ical_start' => '1630045719', 'ical_cache' => '10', 'ical_replacement_event_title' => '', 'ical_pattern_event_title' => '', 'ical_filter_event_title' => '', 'ical_port' => null, 'ical_bnpw' => '', 'ical_proxy' => '', 'ical_url' => 'https://calendar.google.com/calendar/ical/***/basic.ics', 'ical_description' => null, 'ical_prefix' => '', 'ical_alias' => '', 'ical_source' => '1', 'ical_timezone' => 'CET', 'make_ical' => '', 'eventUnsubscribePage' => '1')) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:74) at Contao\CalendarImport->importCalendarWithID('4') (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:53) at Contao\CalendarImport->importFromURL(object(DC_Table)) (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:2121) at Contao\DC_Table->edit() (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:644) at Contao\Backend->getBackendModule('calendar', null) (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:167) at Contao\BackendMain->run() (vendor/contao/core-bundle/src/Controller/BackendController.php:48) at Contao\CoreBundle\Controller\BackendController->mainAction() (vendor/symfony/http-kernel/HttpKernel.php:158) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/http-kernel/HttpKernel.php:80) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (vendor/symfony/http-kernel/Kernel.php:201) at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) (web/index.php:31)

[1/3] PDOException PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'unsubscribeLimitTstamp' at row 1

at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:132 at PDO->query('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'4\', 1631169505, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', 0, \'\', 0, \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')') (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:132) at Doctrine\DBAL\Driver\PDOConnection->doQuery('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'4\', 1631169505, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', 0, \'\', 0, \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')') (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php:36) at Doctrine\DBAL\Driver\PDOConnection->query('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'4\', 1631169505, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', 0, \'\', 0, \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')') (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1295) at Doctrine\DBAL\Connection->executeQuery('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES (\'4\', 1631169505, \'BELEGT\', \'\', \'1\', \'\', 1631224800, 1631397600, 1631224800, 1631397600, \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'above\', \'\', \'\', \'0\', \'0\', \'\', \'\', \'\', \'default\', \'0\', \'0\', \'\', \'\', \'\', \'\', 1, \'\', \'\', \'\', 0, \'\', 0, \'\', \'\', 0, 0, 0, 0, \'\', \'\', \'\', \'\', \'\', \'\', \'\')') (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274) at Contao\Database\Statement->query() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248) at Contao\Database\Statement->execute() (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:918) at Contao\CalendarImport->importFromICS('4', object(Date), object(Date), true, array('X-WR-TIMEZONE', 'Europe/Zurich'), true) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:143) at Contao\CalendarImport->importFromWebICS('4', 'https://calendar.google.com/calendar/ical/***/basic.ics', object(Date), object(Date), array('CET', 'CET'), '', '', null) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:110) at Contao\CalendarImport->importCalendarWithData(array('id' => '4', 'tstamp' => '0', 'title' => 'test (copy) 3', 'jumpTo' => '5', 'protected' => '', 'groups' => null, 'allowComments' => '', 'notify' => 'notify_admin', 'sortOrder' => 'ascending', 'perPage' => '0', 'moderate' => '', 'bbcode' => '', 'requireLogin' => '', 'disableCaptcha' => '', 'ical_importing' => '1', 'ical_source_end' => '1661551200', 'ical_source_start' => '1630015200', 'ical_end' => '1661581719', 'ical_start' => '1630045719', 'ical_cache' => '10', 'ical_replacement_event_title' => '', 'ical_pattern_event_title' => '', 'ical_filter_event_title' => '', 'ical_port' => null, 'ical_bnpw' => '', 'ical_proxy' => '', 'ical_url' => 'https://calendar.google.com/calendar/ical/***/basic.ics', 'ical_description' => null, 'ical_prefix' => '', 'ical_alias' => '', 'ical_source' => '1', 'ical_timezone' => 'CET', 'make_ical' => '', 'eventUnsubscribePage' => '1')) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:74) at Contao\CalendarImport->importCalendarWithID('4') (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:53) at Contao\CalendarImport->importFromURL(object(DC_Table)) (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:2121) at Contao\DC_Table->edit() (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:644) at Contao\Backend->getBackendModule('calendar', null) (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:167) at Contao\BackendMain->run() (vendor/contao/core-bundle/src/Controller/BackendController.php:48) at Contao\CoreBundle\Controller\BackendController->mainAction() (vendor/symfony/http-kernel/HttpKernel.php:158) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/http-kernel/HttpKernel.php:80) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (vendor/symfony/http-kernel/Kernel.php:201) at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) (web/index.php:31) `

Hi Johannes

And you are running markocupic/calendar-event-booking-bundle on at least version 4.2.4?

Marko Cupic Surenweidstr. 2 CH-6208 Oberkirch

http://4ae-racing-team.ch http://kletterkader.com

Gesendet: Donnerstag, 09. September 2021 um 08:53 Uhr Von: "johannes-bittner" @.> An: "markocupic/calendar-event-booking-bundle" @.> Cc: "Marko Cupic" @.>, "State change" @.> Betreff: Re: [markocupic/calendar-event-booking-bundle] Error with Contao 4.9.20 and Strict Mode and [Craffft / contao-calendar-ical-bundle] (#34)

Hm, I still get the same error. But if the error initially is caused by the ical-Bundle, I'd maybe post it there - ?

[3/3] DriverException Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street`) VALUES ('4', 1631169505, 'BELEGT', '', '1', '', 1631224800, 1631397600, 1631224800, 1631397600, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'above', '', '', '0', '0', '', '', '', 'default', '0', '0', '', '', '', '', 1, '', '', '', 0, '', 0, '', '', 0, 0, 0, 0, '', '', '', '', '', '', '')':

SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'unsubscribeLimitTstamp' at row 1

at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128 at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception occurred while executing 'INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES ('4', 1631169505, 'BELEGT', '', '1', '', 1631224800, 1631397600, 1631224800, 1631397600, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'above', '', '', '0', '0', '', '', '', 'default', '0', '0', '', '', '', '', 1, '', '', '', 0, '', 0, '', '', 0, 0, 0, 0, '', '', '', '', '', '', '')':SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'unsubscribeLimitTstamp' at row 1', object(Exception)) (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182) at Doctrine\DBAL\DBALException::wrapException(object(Driver), object(Exception), 'An exception occurred while executing 'INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES ('4', 1631169505, 'BELEGT', '', '1', '', 1631224800, 1631397600, 1631224800, 1631397600, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'above', '', '', '0', '0', '', '', '', 'default', '0', '0', '', '', '', '', 1, '', '', '', 0, '', 0, '', '', 0, 0, 0, 0, '', '', '', '', '', '', '')':SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'unsubscribeLimitTstamp' at row 1') (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:159) at Doctrine\DBAL\DBALException::driverExceptionDuringQuery(object(Driver), object(Exception), 'INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES ('4', 1631169505, 'BELEGT', '', '1', '', 1631224800, 1631397600, 1631224800, 1631397600, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'above', '', '', '0', '0', '', '', '', 'default', '0', '0', '', '', '', '', 1, '', '', '', 0, '', 0, '', '', 0, 0, 0, 0, '', '', '', '', '', '', '')', array()) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:2212) at Doctrine\DBAL\Connection->handleExceptionDuringQuery(object(Exception), 'INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES ('4', 1631169505, 'BELEGT', '', '1', '', 1631224800, 1631397600, 1631224800, 1631397600, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'above', '', '', '0', '0', '', '', '', 'default', '0', '0', '', '', '', '', 1, '', '', '', 0, '', 0, '', '', 0, 0, 0, 0, '', '', '', '', '', '', '')', array(), array()) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1299) at Doctrine\DBAL\Connection->executeQuery('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES ('4', 1631169505, 'BELEGT', '', '1', '', 1631224800, 1631397600, 1631224800, 1631397600, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'above', '', '', '0', '0', '', '', '', 'default', '0', '0', '', '', '', '', 1, '', '', '', 0, '', 0, '', '', 0, 0, 0, 0, '', '', '', '', '', '', '')') (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274) at Contao\Database\Statement->query() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248) at Contao\Database\Statement->execute() (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:918) at Contao\CalendarImport->importFromICS('4', object(Date), object(Date), true, array('X-WR-TIMEZONE', 'Europe/Zurich'), true) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:143) at Contao\CalendarImport->importFromWebICS('4', 'https://calendar.google.com/calendar/ical/***/basic.ics', object(Date), object(Date), array('CET', 'CET'), '', '', null) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:110) at Contao\CalendarImport->importCalendarWithData(array('id' => '4', 'tstamp' => '0', 'title' => 'test (copy) 3', 'jumpTo' => '5', 'protected' => '', 'groups' => null, 'allowComments' => '', 'notify' => 'notify_admin', 'sortOrder' => 'ascending', 'perPage' => '0', 'moderate' => '', 'bbcode' => '', 'requireLogin' => '', 'disableCaptcha' => '', 'ical_importing' => '1', 'ical_source_end' => '1661551200', 'ical_source_start' => '1630015200', 'ical_end' => '1661581719', 'ical_start' => '1630045719', 'ical_cache' => '10', 'ical_replacement_event_title' => '', 'ical_pattern_event_title' => '', 'ical_filter_event_title' => '', 'ical_port' => null, 'ical_bnpw' => '', 'ical_proxy' => '', 'ical_url' => 'https://calendar.google.com/calendar/ical/***/basic.ics', 'ical_description' => null, 'ical_prefix' => '', 'ical_alias' => '', 'ical_source' => '1', 'ical_timezone' => 'CET', 'make_ical' => '', 'eventUnsubscribePage' => '1')) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:74) at Contao\CalendarImport->importCalendarWithID('4') (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:53) at Contao\CalendarImport->importFromURL(object(DC_Table)) (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:2121) at Contao\DC_Table->edit() (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:644) at Contao\Backend->getBackendModule('calendar', null) (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:167) at Contao\BackendMain->run() (vendor/contao/core-bundle/src/Controller/BackendController.php:48) at Contao\CoreBundle\Controller\BackendController->mainAction() (vendor/symfony/http-kernel/HttpKernel.php:158) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/http-kernel/HttpKernel.php:80) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (vendor/symfony/http-kernel/Kernel.php:201) at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) (web/index.php:31)

[2/3] Exception Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'unsubscribeLimitTstamp' at row 1

at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException)) (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:134) at Doctrine\DBAL\Driver\PDOConnection->doQuery('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES ('4', 1631169505, 'BELEGT', '', '1', '', 1631224800, 1631397600, 1631224800, 1631397600, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'above', '', '', '0', '0', '', '', '', 'default', '0', '0', '', '', '', '', 1, '', '', '', 0, '', 0, '', '', 0, 0, 0, 0, '', '', '', '', '', '', '')') (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php:36) at Doctrine\DBAL\Driver\PDOConnection->query('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES ('4', 1631169505, 'BELEGT', '', '1', '', 1631224800, 1631397600, 1631224800, 1631397600, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'above', '', '', '0', '0', '', '', '', 'default', '0', '0', '', '', '', '', 1, '', '', '', 0, '', 0, '', '', 0, 0, 0, 0, '', '', '', '', '', '', '')') (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1295) at Doctrine\DBAL\Connection->executeQuery('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES ('4', 1631169505, 'BELEGT', '', '1', '', 1631224800, 1631397600, 1631224800, 1631397600, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'above', '', '', '0', '0', '', '', '', 'default', '0', '0', '', '', '', '', 1, '', '', '', 0, '', 0, '', '', 0, 0, 0, 0, '', '', '', '', '', '', '')') (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274) at Contao\Database\Statement->query() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248) at Contao\Database\Statement->execute() (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:918) at Contao\CalendarImport->importFromICS('4', object(Date), object(Date), true, array('X-WR-TIMEZONE', 'Europe/Zurich'), true) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:143) at Contao\CalendarImport->importFromWebICS('4', 'https://calendar.google.com/calendar/ical/***/basic.ics', object(Date), object(Date), array('CET', 'CET'), '', '', null) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:110) at Contao\CalendarImport->importCalendarWithData(array('id' => '4', 'tstamp' => '0', 'title' => 'test (copy) 3', 'jumpTo' => '5', 'protected' => '', 'groups' => null, 'allowComments' => '', 'notify' => 'notify_admin', 'sortOrder' => 'ascending', 'perPage' => '0', 'moderate' => '', 'bbcode' => '', 'requireLogin' => '', 'disableCaptcha' => '', 'ical_importing' => '1', 'ical_source_end' => '1661551200', 'ical_source_start' => '1630015200', 'ical_end' => '1661581719', 'ical_start' => '1630045719', 'ical_cache' => '10', 'ical_replacement_event_title' => '', 'ical_pattern_event_title' => '', 'ical_filter_event_title' => '', 'ical_port' => null, 'ical_bnpw' => '', 'ical_proxy' => '', 'ical_url' => 'https://calendar.google.com/calendar/ical/***/basic.ics', 'ical_description' => null, 'ical_prefix' => '', 'ical_alias' => '', 'ical_source' => '1', 'ical_timezone' => 'CET', 'make_ical' => '', 'eventUnsubscribePage' => '1')) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:74) at Contao\CalendarImport->importCalendarWithID('4') (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:53) at Contao\CalendarImport->importFromURL(object(DC_Table)) (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:2121) at Contao\DC_Table->edit() (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:644) at Contao\Backend->getBackendModule('calendar', null) (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:167) at Contao\BackendMain->run() (vendor/contao/core-bundle/src/Controller/BackendController.php:48) at Contao\CoreBundle\Controller\BackendController->mainAction() (vendor/symfony/http-kernel/HttpKernel.php:158) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/http-kernel/HttpKernel.php:80) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (vendor/symfony/http-kernel/Kernel.php:201) at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) (web/index.php:31)

[1/3] PDOException PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'unsubscribeLimitTstamp' at row 1

at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:132 at PDO->query('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES ('4', 1631169505, 'BELEGT', '', '1', '', 1631224800, 1631397600, 1631224800, 1631397600, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'above', '', '', '0', '0', '', '', '', 'default', '0', '0', '', '', '', '', 1, '', '', '', 0, '', 0, '', '', 0, 0, 0, 0, '', '', '', '', '', '', '')') (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:132) at Doctrine\DBAL\Driver\PDOConnection->doQuery('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES ('4', 1631169505, 'BELEGT', '', '1', '', 1631224800, 1631397600, 1631224800, 1631397600, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'above', '', '', '0', '0', '', '', '', 'default', '0', '0', '', '', '', '', 1, '', '', '', 0, '', 0, '', '', 0, 0, 0, 0, '', '', '', '', '', '', '')') (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php:36) at Doctrine\DBAL\Driver\PDOConnection->query('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES ('4', 1631169505, 'BELEGT', '', '1', '', 1631224800, 1631397600, 1631224800, 1631397600, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'above', '', '', '0', '0', '', '', '', 'default', '0', '0', '', '', '', '', 1, '', '', '', 0, '', 0, '', '', 0, 0, 0, 0, '', '', '', '', '', '', '')') (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1295) at Doctrine\DBAL\Connection->executeQuery('INSERT INTO tl_calendar_events (pid, tstamp, title, alias, author, addTime, startTime, endTime, startDate, endDate, pageTitle, description, location, address, teaser, addImage, overwriteMeta, singleSRC, alt, imageTitle, size, imagemargin, imageUrl, fullsize, caption, floating, recurring, repeatEach, repeatEnd, recurrences, addEnclosure, enclosure, orderEnclosure, source, jumpTo, articleId, url, target, cssClass, noComments, published, start, stop, unsubscribeLimitTstamp, unsubscribeLimit, enableDeregistration, eventBookingNotificationSender, eventBookingNotificationCenterIds, enableNotificationCenter, includeEscortsWhenCalculatingRegCount, maxEscortsPerMember, maxMembers, minMembers, bookingEndDate, bookingStartDate, enableMultiBookingWithSameAddress, addBookingForm, city, postal, street) VALUES ('4', 1631169505, 'BELEGT', '', '1', '', 1631224800, 1631397600, 1631224800, 1631397600, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'above', '', '', '0', '0', '', '', '', 'default', '0', '0', '', '', '', '', 1, '', '', '', 0, '', 0, '', '', 0, 0, 0, 0, '', '', '', '', '', '', '')') (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274) at Contao\Database\Statement->query() (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248) at Contao\Database\Statement->execute() (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:918) at Contao\CalendarImport->importFromICS('4', object(Date), object(Date), true, array('X-WR-TIMEZONE', 'Europe/Zurich'), true) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:143) at Contao\CalendarImport->importFromWebICS('4', 'https://calendar.google.com/calendar/ical/***/basic.ics', object(Date), object(Date), array('CET', 'CET'), '', '', null) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:110) at Contao\CalendarImport->importCalendarWithData(array('id' => '4', 'tstamp' => '0', 'title' => 'test (copy) 3', 'jumpTo' => '5', 'protected' => '', 'groups' => null, 'allowComments' => '', 'notify' => 'notify_admin', 'sortOrder' => 'ascending', 'perPage' => '0', 'moderate' => '', 'bbcode' => '', 'requireLogin' => '', 'disableCaptcha' => '', 'ical_importing' => '1', 'ical_source_end' => '1661551200', 'ical_source_start' => '1630015200', 'ical_end' => '1661581719', 'ical_start' => '1630045719', 'ical_cache' => '10', 'ical_replacement_event_title' => '', 'ical_pattern_event_title' => '', 'ical_filter_event_title' => '', 'ical_port' => null, 'ical_bnpw' => '', 'ical_proxy' => '', 'ical_url' => 'https://calendar.google.com/calendar/ical/***/basic.ics', 'ical_description' => null, 'ical_prefix' => '', 'ical_alias' => '', 'ical_source' => '1', 'ical_timezone' => 'CET', 'make_ical' => '', 'eventUnsubscribePage' => '1')) (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:74) at Contao\CalendarImport->importCalendarWithID('4') (vendor/craffft/contao-calendar-ical-bundle/src/Resources/contao/classes/CalendarImport.php:53) at Contao\CalendarImport->importFromURL(object(DC_Table)) (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:2121) at Contao\DC_Table->edit() (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:644) at Contao\Backend->getBackendModule('calendar', null) (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:167) at Contao\BackendMain->run() (vendor/contao/core-bundle/src/Controller/BackendController.php:48) at Contao\CoreBundle\Controller\BackendController->mainAction() (vendor/symfony/http-kernel/HttpKernel.php:158) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/http-kernel/HttpKernel.php:80) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (vendor/symfony/http-kernel/Kernel.php:201) at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) (web/index.php:31) `

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub, or unsubscribe. Triage notifications on the go with GitHub Mobile for iOS or Android.

Hi Marko, yes I am:

grafik

I was wondering too, and I even unistalled/reinstalled the package, emptied caches etc.

markocupic / calendar-event-booking-bundle

Error with Contao 4.9.20 and Strict Mode and [Craffft / contao-calendar-ical-bundle] #34