Including external calendar URL (webcal) isn't possible
I'd like to import this external nextcloud calendar with Typo3 7.6.32 and cal 1.11.1.
If I download the ical-file by pressing the "Herunterladen" (download)-button in the top right corner, an add this to the "Include ICS File"-calendar, everything works fine. The new events are created in the sysfolder.
However, if I create a new external calendar with the URL
(see the link of the "Abonieren" (subscribe)-button), nothing will happen. But this link works fine with a google calendar.
When I start the sheduler "Updating external calendars (created by saving the calendar record) (cal)"
I get an error message:
Die Ausführung von Task "Updating external calendars (created by saving the calendar record) (cal)" ist fehlgeschlagen mit folgender Meldung: Could not write new md5 hash to database: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Does anybody have any ideas?
#2 Updated by Leo Führinger 5 days ago
I figured out the wrong SQL query:
'SELECT * FROM tx_cal_calendar WHERE type IN (1,2) AND uid= AND tx_cal_calendar.hidden=0 AND (tx_cal_calendar.starttime<=1547481240) AND (tx_cal_calendar.endtime=0 OR tx_cal_calendar.endtime>1547481240) AND tx_cal_calendar.deleted = 0'
There is a missing uid=