Wednesday, 29 November 2023
  9 Replies
  607 Visits
0
Votes
Undo
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
fde68 set the post as Critical priority — 12 months ago
fde68 set the type of the post as  Bug — 12 months ago
12 months ago
·
#233237
0
Votes
Undo
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
12 months ago
·
#233238
0
Votes
Undo
Of course, nobody is aktin for free support! This is asking for realizing a job!
Thank you!
12 months ago
·
#233243
0
Votes
Undo
Hm, any response please possible?

A ADDITIONAL CONTACTED THE TEAM ::: I TRIED - BUT ALSO NO RESPONSE:
Any idea, how to get supprt (also paid)
Thanks
11 months ago
·
#233253
0
Votes
Undo
See your error message

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!

11 months ago
·
#233261
0
Votes
Undo
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
11 months ago
·
#233286
0
Votes
Undo
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.


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!

11 months ago
·
#233292
0
Votes
Undo
Ok, what exactly is the problem?

i tried to import it manually by file downloaded first - it was the same.

Please, could this solved by changing config from server?
Or what is needed, that the import will work correctly?

Thanks for advise!
Best regards
Frank
11 months ago
·
#233308
0
Votes
Undo
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!

11 months ago
·
#233336
0
Votes
Undo
Thank you for the support ... as the answers are really short and a littly cryptic.
But yes, there where failed dates inside the ics ... these are corrected - and now it possible to import all dates correctly.
Bye
  • 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.