Wednesday, 13 December 2023
  2 Replies
  724 Visits
0
Votes
Undo
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
1 year ago
·
#233502
Accepted Answer
0
Votes
Undo
I found the reason for the Exception. There was a date in the year 2094 that caused this fault.

Felix
benoven set the post as Normal priority — 1 year ago
benoven set the type of the post as  Issue — 1 year ago
1 year ago
·
#233467
0
Votes
Undo
What is the date in question?

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!

1 year ago
·
#233502
Accepted Answer
0
Votes
Undo
I found the reason for the Exception. There was a date in the year 2094 that caused this fault.

Felix
geraint selected the reply #233502 as the answer for this post — 1 year ago
  • Page :
  • 1
There are no replies made for this post yet.