Wednesday, 13 December 2023
  2 Replies
  280 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
5 months 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 — 5 months ago
benoven set the type of the post as  Issue — 5 months ago
5 months 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!

5 months 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 — 4 months ago
  • Page :
  • 1
There are no replies made for this post yet.

Members Area

Show your support

Unlike many Joomla calendars we do not charge to download JEvents - please show your support for this project by becoming a member of the JEvents Club Club members get access to early releases, exclusive member support forums, and Silver and Gold members can use many exciting JEvents addons

Your membership will ensure that JEvents continues to be the best events calendar for Joomla.