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
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