0
Undo
Votes
Hello Team,
i have an external url, which provides an google compatible ical file.
In jevents (i was silver memebr for years) i added a new calendar and added this url.
By start of import, i get a huge fail message - please let me know, what is reson for this - what is wrong.
320 There were problems saving the event detailProblem saving event Exception: Problem saving event (253402124400) : Out of range value for column 'dtstart' at row 1 in /var/www/salvator-iss/htdocs/sitex-x23/components/com_jevents/libraries/iCalEventDetail.php:301 Stack trace: #0 /var/www/salvator-iss/htdocs/sitex-x23/components/com_jevents/libraries/iCalEvent.php(295): iCalEventDetail->store(false) #1 /var/www/salvator-iss/htdocs/sitex-x23/components/com_jevents/libraries/iCalICSFile.php(441): iCalEvent->store(false, true) #2 /var/www/salvator-iss/htdocs/sitex-x23/administrator/components/com_jevents/controllers/icals.php(450): iCalICSFile->store() #3 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/MVC/Controller/BaseController.php(693): AdminIcalsController->save() #4 /var/www/salvator-iss/htdocs/sitex-x23/administrator/components/com_jevents/jevents.php(274): Joomla\CMS\MVC\Controller\BaseController->execute('reload') #5 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/Dispatcher/LegacyComponentDispatcher.php(71): require_once('/var/www/salvat...') #6 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/Dispatcher/LegacyComponentDispatcher.php(73): Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}('/var/www/salvat...') #7 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/Component/ComponentHelper.php(361): Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() #8 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/Application/AdministratorApplication.php(143): Joomla\CMS\Component\ComponentHelper::renderComponent('com_jevents') #9 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/Application/AdministratorApplication.php(186): Joomla\CMS\Application\AdministratorApplication->dispatch() #10 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/Application/CMSApplication.php(293): Joomla\CMS\Application\AdministratorApplication->doExecute() #11 /var/www/salvator-iss/htdocs/sitex-x23/administrator/includes/app.php(61): Joomla\CMS\Application\CMSApplication->execute() #12 /var/www/salvator-iss/htdocs/sitex-x23/administrator/index.php(32): require_once('/var/www/salvat...') #13 {main}
Joomla is lates version 4.4.1 ... Jevents made update today!
PHP 8.1.26
If i get this running, i start to pay again, as i need to get the modules and cronjob support for this functionality.
As it is urgend, i appreciate for you quick response and suport.
Thank you and with best regards
Frank
i have an external url, which provides an google compatible ical file.
In jevents (i was silver memebr for years) i added a new calendar and added this url.
By start of import, i get a huge fail message - please let me know, what is reson for this - what is wrong.
320 There were problems saving the event detailProblem saving event Exception: Problem saving event (253402124400) : Out of range value for column 'dtstart' at row 1 in /var/www/salvator-iss/htdocs/sitex-x23/components/com_jevents/libraries/iCalEventDetail.php:301 Stack trace: #0 /var/www/salvator-iss/htdocs/sitex-x23/components/com_jevents/libraries/iCalEvent.php(295): iCalEventDetail->store(false) #1 /var/www/salvator-iss/htdocs/sitex-x23/components/com_jevents/libraries/iCalICSFile.php(441): iCalEvent->store(false, true) #2 /var/www/salvator-iss/htdocs/sitex-x23/administrator/components/com_jevents/controllers/icals.php(450): iCalICSFile->store() #3 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/MVC/Controller/BaseController.php(693): AdminIcalsController->save() #4 /var/www/salvator-iss/htdocs/sitex-x23/administrator/components/com_jevents/jevents.php(274): Joomla\CMS\MVC\Controller\BaseController->execute('reload') #5 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/Dispatcher/LegacyComponentDispatcher.php(71): require_once('/var/www/salvat...') #6 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/Dispatcher/LegacyComponentDispatcher.php(73): Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}('/var/www/salvat...') #7 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/Component/ComponentHelper.php(361): Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() #8 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/Application/AdministratorApplication.php(143): Joomla\CMS\Component\ComponentHelper::renderComponent('com_jevents') #9 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/Application/AdministratorApplication.php(186): Joomla\CMS\Application\AdministratorApplication->dispatch() #10 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/Application/CMSApplication.php(293): Joomla\CMS\Application\AdministratorApplication->doExecute() #11 /var/www/salvator-iss/htdocs/sitex-x23/administrator/includes/app.php(61): Joomla\CMS\Application\CMSApplication->execute() #12 /var/www/salvator-iss/htdocs/sitex-x23/administrator/index.php(32): require_once('/var/www/salvat...') #13 {main}
Joomla is lates version 4.4.1 ... Jevents made update today!
PHP 8.1.26
If i get this running, i start to pay again, as i need to get the modules and cronjob support for this functionality.
As it is urgend, i appreciate for you quick response and suport.
Thank you and with best regards
Frank
fde68
set the post as Critical priority — 11 months ago
Hello, sadly i did not get any response.
All in know by investigation in meantime, is, that the faile basically is compatible with google's .ics standard. But jevents shows this feil message.
The situation is, that the given file could not be changed, as it is part of a system. The plan is, to import this file frequently, to get the latest events in the jevents component in the given website.
Question:
Is there any developer, who can check, what is reason for this fail - and can set up a modified version of .ics import, so that we can use this?
Thank you
All in know by investigation in meantime, is, that the faile basically is compatible with google's .ics standard. But jevents shows this feil message.
The situation is, that the given file could not be changed, as it is part of a system. The plan is, to import this file frequently, to get the latest events in the jevents component in the given website.
Question:
Is there any developer, who can check, what is reason for this fail - and can set up a modified version of .ics import, so that we can use this?
Thank you
See your error message
What dates do you have for your events - it looks as though one or more may have an extreme value that can't be stored in the database
Out of range value for column 'dtstart'
What dates do you have for your events - it looks as though one or more may have an extreme value that can't be stored in the database
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!
Hello, thank you for your response.
Whyever, the calendar has some facts, start in in 1970, as i can see. I know, it is not very professional ... but it based on another system, a portal for teachers.
Attached i send you the .ics file - zipped.
This needs to download frequently from a fixed url ... so, basically i am not able to change anythang with the file.
So, how is it possible, to modify the import, that it works? What is needed to do?
Thank you very much.
Best regards
Fank
Whyever, the calendar has some facts, start in in 1970, as i can see. I know, it is not very professional ... but it based on another system, a portal for teachers.
Attached i send you the .ics file - zipped.
This needs to download frequently from a fixed url ... so, basically i am not able to change anythang with the file.
So, how is it possible, to modify the import, that it works? What is needed to do?
Thank you very much.
Best regards
Fank
I just imported this calendar with no problems - though it took a while because it so large
Looking at the file I see where the problem arises e.g.
Looking at the file I see where the problem arises e.g.
BEGIN:VEVENT
DTSTART;TZID=Europe/Berlin:99991230T000000
DTEND;TZID=Europe/Berlin:99991230T000000
X-WWS-ID:2338
UID:2338-1-1676635868-calendar--klassenarbeiten@kss.schulerzbistum.de
CREATED:20230217T121108Z
LAST-MODIFIED:20230217T121108Z
DTSTAMP:20230217T121108Z
X-WWS-C-USER-ID:30064772741
X-WWS-M-USER-ID:30064772741
SUMMARY:9m KA Deutsch
SEQUENCE:2
END:VEVENT
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!
Look at the dates for the start and end of the event - they are somewhat extreme!
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!
- 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.