By benoven on Wednesday, 13 December 2023
Replies 2
Likes 0
Views 723
Votes 0
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
I found the reason for the Exception. There was a date in the year 2094 that caused this fault.

Felix
·
1 year ago
·
0 Likes
·
0 Votes
·
0 Comments
·
What is the date in question?
·
1 year ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post