Dear all,
while importing an iCal (Internetcalender) an error occurs.
The callstack when pushing the Update or URL Link within the iCal menu in JEvents Backend is:
320 There were problems saving the event detailProblem saving event Exception: Problem saving event (2457817200) : 22003, 1264, Out of range value for column 'dtstart' at row 1 in /kunden/moerike-gymnasium.de/joomla4/components/com_jevents/libraries/iCalEventDetail.php:301 Stack trace: #0 /kunden/moerike-gymnasium.de/joomla4/components/com_jevents/libraries/iCalEvent.php(295): iCalEventDetail->store() #1 /kunden/moerike-gymnasium.de/joomla4/components/com_jevents/libraries/iCalICSFile.php(441): iCalEvent->store() #2 /kunden/moerike-gymnasium.de/joomla4/administrator/components/com_jevents/controllers/icals.php(450): iCalICSFile->store() #3 /kunden/moerike-gymnasium.de/joomla4/libraries/src/MVC/Controller/BaseController.php(730): AdminIcalsController->save() #4 /kunden/moerike-gymnasium.de/joomla4/administrator/components/com_jevents/jevents.php(274): Joomla\CMS\MVC\Controller\BaseController->execute() #5 /kunden/moerike-gymnasium.de/joomla4/libraries/src/Dispatcher/LegacyComponentDispatcher.php(71): require_once('...') #6 /kunden/moerike-gymnasium.de/joomla4/libraries/src/Dispatcher/LegacyComponentDispatcher.php(73): Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() #7 /kunden/moerike-gymnasium.de/joomla4/libraries/src/Component/ComponentHelper.php(361): Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() #8 /kunden/moerike-gymnasium.de/joomla4/libraries/src/Application/AdministratorApplication.php(150): Joomla\CMS\Component\ComponentHelper::renderComponent() #9 /kunden/moerike-gymnasium.de/joomla4/libraries/src/Application/AdministratorApplication.php(195): Joomla\CMS\Application\AdministratorApplication->dispatch() #10 /kunden/moerike-gymnasium.de/joomla4/libraries/src/Application/CMSApplication.php(306): Joomla\CMS\Application\AdministratorApplication->doExecute() #11 /kunden/moerike-gymnasium.de/joomla4/administrator/includes/app.php(58): Joomla\CMS\Application\CMSApplication->execute() #12 /kunden/moerike-gymnasium.de/joomla4/administrator/index.php(32): require_once('...') #13 {main}
It looks like the number 2457817200 is higher than the allowed value for INT values in MySQL:
Stackoverflow article
I'm using Joomla with JEvents v3.6.76 Stable version.
Any idea how I can resolve this problem?
The import of the same iCal into e.g. Outlook works without any problems.
Regards
Felix