humhub-contrib / external_calendar Goto Github PK

Hi,

The public iCal link doesn't work any more.
I have this in the logs :

INFO Thu, 25 May 2023 10:06:01 +0200
$_GET = []

$_SERVER = [
'HOME' => '/var/www'
'LOGNAME' => 'www-data'
'PATH' => '/usr/bin:/bin'
'LANG' => 'C.UTF-8'
'SHELL' => '/bin/sh'
'PWD' => '/var/www'
'PHP_SELF' => '/var/www/html/humhub/protected/yii'
'SCRIPT_NAME' => '/var/www/html/humhub/protected/yii'
'SCRIPT_FILENAME' => '/var/www/html/humhub/protected/yii'
'PATH_TRANSLATED' => '/var/www/html/humhub/protected/yii'
'DOCUMENT_ROOT' => ''
'REQUEST_TIME_FLOAT' => 1685001961.3557
'REQUEST_TIME' => 1685001961
'argv' => [
0 => '/var/www/html/humhub/protected/yii'
1 => 'cron/run'
]
'argc' => 2
]

ERREUR Thu, 25 May 2023 10:06:01 +0200 application
yii\base\UnknownMethodException: Calling unknown method: humhub\components\console\Application::getSession() in /var/www/html/humhub/protected/vendor/yiisoft/yii2/base/Component.php:300
Stack trace:
#0 /var/www/html/humhub/protected/vendor/yiisoft/yii2/web/User.php(690): yii\base\Component->__call()
#1 /var/www/html/humhub/protected/vendor/yiisoft/yii2/web/User.php(199): yii\web\User->renewAuthStatus()
#2 /var/www/html/humhub/protected/vendor/yiisoft/yii2/web/User.php(367): yii\web\User->getIdentity()
#3 /var/www/html/humhub/protected/vendor/yiisoft/yii2/base/Component.php(139): yii\web\User->getIsGuest()
#4 /var/www/html/humhub/protected/modules/calendar/interfaces/event/AbstractCalendarQuery.php(312): yii\base\Component->__get()
#5 /var/www/html/humhub/protected/modules/calendar/interfaces/event/AbstractCalendarQuery.php(226): humhub\modules\calendar\interfaces\event\AbstractCalendarQuery::find()
#6 /var/www/html/humhub/protected/modules/calendar/models/CalendarEntryQuery.php(72): humhub\modules\calendar\interfaces\event\AbstractCalendarQuery::findForFilter()
#7 /var/www/html/humhub/protected/modules/calendar/interfaces/CalendarService.php(152): humhub\modules\calendar\models\CalendarEntryQuery::findForFilter()
#8 /var/www/html/humhub/protected/modules/calendar/interfaces/CalendarService.php(207): humhub\modules\calendar\interfaces\CalendarService->getCalendarItems()
#9 /var/www/html/humhub/protected/modules/calendar/models/reminder/ReminderProcessor.php(82): humhub\modules\calendar\interfaces\CalendarService->getUpcomingEntries()
#10 /var/www/html/humhub/protected/modules/calendar/models/reminder/ReminderProcessor.php(63): humhub\modules\calendar\models\reminder\ReminderProcessor->runByUpcomingEvents()
#11 /var/www/html/humhub/protected/modules/calendar/models/reminder/ReminderService.php(20): humhub\modules\calendar\models\reminder\ReminderProcessor->run()
#12 /var/www/html/humhub/protected/modules/calendar/Events.php(377): humhub\modules\calendar\models\reminder\ReminderService->sendAllReminder()
#13 [internal function]: humhub\modules\calendar\Events::onCronRun()
#14 /var/www/html/humhub/protected/vendor/yiisoft/yii2/base/Event.php(312): call_user_func()
#15 /var/www/html/humhub/protected/vendor/yiisoft/yii2/base/Component.php(642): yii\base\Event::trigger()
#16 /var/www/html/humhub/protected/vendor/yiisoft/yii2/base/Controller.php(297): yii\base\Component->trigger()
#17 /var/www/html/humhub/protected/vendor/yiisoft/yii2/console/Controller.php(86): yii\base\Controller->beforeAction()
#18 /var/www/html/humhub/protected/vendor/yiisoft/yii2/base/Controller.php(176): yii\console\Controller->beforeAction()
#19 /var/www/html/humhub/protected/vendor/yiisoft/yii2/console/Controller.php(180): yii\base\Controller->runAction()
#20 /var/www/html/humhub/protected/vendor/yiisoft/yii2/base/Module.php(552): yii\console\Controller->runAction()
#21 /var/www/html/humhub/protected/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction()
#22 /var/www/html/humhub/protected/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction()
#23 /var/www/html/humhub/protected/vendor/yiisoft/yii2/base/Application.php(384): yii\console\Application->handleRequest()
#24 /var/www/html/humhub/protected/yii(29): yii\base\Application->run()
#25 {main}

Can you please help me ?

Humhub community edition v1.14.2
External Calendar v 1.3.3

I have installed this module in Administration => Modules => Browse Online.
After installation, it appears in the Installed tab, but when I click enabled, it shows me a pop-up with a message Enable Module.

HumHub Version: 1.5.2; external-calendar Version: 1.1.9;

Problems:

1. it does not enable this module for me (just in case - other modules can be enabled/disabled, installed; I am running on PHP 7.4; MariaDB 10.3
2. I believe it needs to be Enabling Module instead of Enable Module

Please see details here: humhub/humhub#5110

schulferien.org provides calendars for german school holidays. The entries are formatted like this:

BEGIN:VEVENT
CREATED:20230630T032002Z
LAST-MODIFIED:20230630T032002Z
DTSTAMP:20230630T032002Z
SUMMARY:Sommerferien 2023 Niedersachsen
DTSTART;VALUE=DATE:20230706
DTEND;VALUE=DATE:20230817
URL:http://www.schulferien.org
DESCRIPTION:Alle Termine auf www.schulferien.org
TRANSP:TRANSPARENT
UID:[email protected]
END:VEVENT

These entries are shown only on their first day as a full-day-event, they should run over multiple days.

I'm trying to embed our humhub calendar in our website.
As I see it the calendar exported via the link is empty when you are not logged in.

I also tried to subscribe to the calendar using Thunderbird, but it didn't ask me for any credentials and just imports the empty no login version.

Is there any chance of exporting the calendar without login or logging in with a standard ics importer tool?

It would be really great to see webcal:// implemented! At the moment it is not possible to sync with calendar on mac. I think there are quite a lot users outside using mac and icloud.

Testing the generated ics link with a validator (icalendar.org), errors are shown for events with specific times (not whole day events):
e.g.

'Invalid TZID value or missing VTIMEZONE component (Europe/Berlin) near line # 24Reference: 3.2.19. Time Zone Identifier'.

DTSTAMP:20200915T115304Z
DTSTART;TZID=Europe/Berlin:20200827T180000
DTEND;TZID=Europe/Berlin:20200827T200000

The events/appointments are showing up fine in the actual client calendars though.

To reproduce:

• Export calendar from HumHub (events/appointments with specific start and end times need to be included)
• Test with ical validator e.g. https://icalendar.org

On my devices/client calendars (macs/ios), all is working ok but perhaps this could cause issues (timezone?) for others.

Not sure if this is a factor but the DTSTART/END times are local (Europe/Berlin) but the DTSTAMP is UTC.

When the events from an external calendar are exported, both the LOCATION and DESCRIPTION iCalendar properties have bad values:

LOCATION:1
DESCRIPTION:1

Would it be possible to include scheduled tasks in the calendar export?

Test the inclusion and format of birthdays in exported events. Either export seperately or as recurrent yearly event?

Database Exception – yii\db\Exception
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes
The SQL being executed was: ALTER TABLE external_calendar_entry ADD INDEX idx_unique_external-calendar_entry_recurrence (parent_event_id, recurrence_id)

Error Info: Array
(
[0] => 42000
[1] => 1071
[2] => Specified key was too long; max key length is 1000 bytes
)

↵
Caused by: PDOException
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

in /home3/danielrodd/public_html/app/protected/vendor/yiisoft/yii2/db/Command.php at line 1290

Description
Steps To Reproduce

1. open you external-caledar
2. make sure you have some events
3. create export
4. click on Copy to clipboard button

Actual Result: clicking on the Copy to clipboard button copies the url
Expected Result: throws the error ReferenceError: clipboard is not defined

TEXT:

humhub.log.js?v=1591265373:149 ERROR - humhub.modules.action: An unexpected error occurred. If this keeps happening, please contact a site administrator. ReferenceError: clipboard is not defined
    at jQuery.fn.init.<anonymous> (humhub.ui.additions.js?v=1591265373:139)
    at ActionBinding.handle (humhub.action.js?v=1596119240:550)
    at HTMLAnchorElement.<anonymous> (humhub.action.js?v=1596119240:802)
    at HTMLDocument.dispatch (jquery.js?v=1596124848:5429)
    at HTMLDocument.elemData.handle (jquery.js?v=1596124848:5233)

hi,
you probably know that a external calendar doesn't behave as regular calendar entries: there is no possibility to 'accept' or 'decline' an event.
Could this evolve to a higher integration of eternal events in spaces calendar?
That would be awesome :)

Thanks for the useful work

To reproduce:

• from calendar in HumHub, go to calendar export to generate .ics file/link
• input link to create a new subscription in an external calendar or iCal validator

Comments:
Not sure whether this is primarily an External Calendar Module issue or HumHub core but when using External Calendar with HumHub 1.6.x,, inputting the generated .ics export link to a client calendar or iCal validator, the clients are not able to access a generated .ics /VCALENDAR file, only html.

As the same Calendar (1.0.12 ) and External Calendar module (1.1.11) versions are currently working fine (re ics subscriptions) with another HumHub installation (1.5.x), presumably this is an issue in combination with 1.6.x preventing clients from accessing a generated ics file?

(The above referred-to HumHub 1.5.x installation- completely different server environment - has now been updated to 1.6.2 and the generated ics. links for subscribing to the calendar are facing the same problem.)

Many thanks!

As a server administrator I see the following message and I honestly don't know what do do about it: There is no information on which space / calendar is causing this or the affected URL.

Furthermore I'd suggest to avoid translating error messages because it makes it harder to find solutions online and to discuss those errors in an international community.

This is triggered by each hourly cronjob.

yii\base\InvalidValueException: Fehler beim Erstellen der iCal-Datei... Überprüfen Sie, ob der Link erreichbar ist. in /srv/www/htdocs/[redacted]/modules/external_calendar/models/ICalSync.php:80
Stack trace:
#0 /srv/www/htdocs/[redacted]/modules/external_calendar/models/ICalSync.php(68): humhub\modules\external_calendar\models\ICalSync->syncICal()
#1 /srv/www/htdocs/[redacted]/modules/external_calendar/models/ExternalCalendar.php(408): humhub\modules\external_calendar\models\ICalSync::sync(Object(humhub\modules\external_calendar\models\ExternalCalendar), NULL, NULL)
#2 /srv/www/htdocs/[redacted]/modules/external_calendar/jobs/SyncHourly.php(27): humhub\modules\external_calendar\models\ExternalCalendar->sync()
#3 /srv/humhub/protected/humhub/modules/queue/ActiveJob.php(33): humhub\modules\external_calendar\jobs\SyncHourly->run()
#4 /srv/humhub/protected/vendor/yiisoft/yii2-queue/src/Queue.php(246): humhub\modules\queue\ActiveJob->execute(Object(humhub\modules\queue\driver\MySQL))
#5 /srv/humhub/protected/vendor/yiisoft/yii2-queue/src/cli/Queue.php(162): yii\queue\Queue->handleMessage('12165264', 'O:48:"humhub\\mo...', '300', '1')
#6 /srv/humhub/protected/vendor/yiisoft/yii2-queue/src/cli/Command.php(146): yii\queue\cli\Queue->execute('12165264', 'O:48:"humhub\\mo...', '300', '1', '27397')
#7 [internal function]: yii\queue\cli\Command->actionExec('12165264', '300', '1', '27397')
#8 /srv/humhub/protected/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#9 /srv/humhub/protected/vendor/yiisoft/yii2/base/Controller.php(181): yii\base\InlineAction->runWithParams(Array)
#10 /srv/humhub/protected/vendor/yiisoft/yii2/console/Controller.php(184): yii\base\Controller->runAction('exec', Array)
#11 /srv/humhub/protected/vendor/yiisoft/yii2/base/Module.php(534): yii\console\Controller->runAction('exec', Array)
#12 /srv/humhub/protected/vendor/yiisoft/yii2/console/Application.php(181): yii\base\Module->runAction('queue/exec', Array)
#13 /srv/humhub/protected/vendor/yiisoft/yii2/console/Application.php(148): yii\console\Application->runAction('queue/exec', Array)
#14 /srv/humhub/protected/vendor/yiisoft/yii2/base/Application.php(392): yii\console\Application->handleRequest(Object(yii\console\Request))
#15 /srv/www/htdocs/[redacted]/yii.php(38): yii\base\Application->run()
#16 {main}

Hello,

I played around with the export of different humhub calender ressources and when I wanted to delete these tests from "My Exports" I noticed, that this is not possible. I get this error message:

"The requested ressource could not be found."

There is no other error in my humhub log, only the one posted above shown directly in the browser wehen trying to delete.

The only way to delete all these tests, is to deactivate and reactivate "external calendar" module. I think this is no good idea, because also the resource/calendar list of other users will be lost.

Humhub version: 1.3.20
PHP: v. 7.2.19
External calendar: v. 1.1.7
Calendar: v. 1.0.5

GCal events with HTML description are presented with no formatting on HumHub, thus revealing all HTML tags, rendering the text much less readable and jeopardizing linked URLs

In imported events turn links into clickable links.

I'm using this service to turn Eventbrite into Ical https://eb-to-ical.daylightpirates.org/

The resulting events include a URL, but it is not clickable

Hi,

I added the public "Holidays in Germany" calendar to the configuration and executed the sync which was reported as successful. But actually, the calendar entries are not shown in Humhub. What can I do to investigate that? The address of the calendar is:

https://calendar.google.com/calendar/embed?src=de.german%23holiday%40group.v.calendar.google.com&ctz=Europe%2FBerlin

Thanks,

Sven

The module doesn't work on Humhub 1.15 because of humhub\widgets\ModalConfirm in https://github.com/humhub-contrib/external_calendar/blob/master/views/calendar/view.php

When I attempt to add an external calendar, after clicking “Save” a new page briefly shows a notice at the bottom that says “Calendar successfully created!” but the top of the page shows an error message (“Oooops... It looks like you may have taken the wrong turn”): “Missing required parameters: id”.

There is no log message in the HumHub logs, and the external calendar does not in fact appear to be created.

HumHub version: 1.5.1
External Calendar version: 1.1.8

Hi,

I have problem with adding Google Calendar.

My humhub version is 1.8.2 + External Calendar 1.2.0.

In Log I can see this error:

yii\base\InvalidValueException: Error while creating ical... Check if link is reachable. in /var/www/htdocs/example.com/demo/demo/protected/modules/external_calendar/models/ICalSync.php:80Stack trace:
#0 /var/www/htdocs/example.com/demo/demo/protected/modules/external_calendar/controllers/CalendarController.php(108): humhub\modules\external_calendar\models\ICalSync->syncICal()
#1 [internal function]: humhub\modules\external_calendar\controllers\CalendarController->actionEdit()
#2 /var/www/htdocs/example.com/demo/demo/protected/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
#3 /var/www/htdocs/example.com/demo/demo/protected/vendor/yiisoft/yii2/base/Controller.php(181): yii\base\InlineAction->runWithParams()
#4 /var/www/htdocs/example.com/demo/demo/protected/vendor/yiisoft/yii2/base/Module.php(534): yii\base\Controller->runAction()
#5 /var/www/htdocs/example.com/demo/demo/protected/vendor/yiisoft/yii2/web/Application.php(104): yii\base\Module->runAction()
#6 /var/www/htdocs/example.com/demo/demo/protected/vendor/yiisoft/yii2/base/Application.php(392): yii\web\Application->handleRequest()
#7 /var/www/htdocs/example.com/demo/demo/index.php(25): yii\base\Application->run()
#8 {main}

Hey,
I've add an ics calendar to this module but if the calender resync it doublecate the appointments and dosn't update theme or didn't create a new one, if still exist.

Is this an issu in my ics file?

my appointments look like this:
BEGIN:VEVENT
UID:1
DTSTAMP:20231214T150000
CLASS:PUBLIC
DTSTART;VALUE=DATE:20240105
DTEND;VALUE=DATE:20240108
LOCATION:Nürburgring
SUMMARY:INTERNATIONALES RHEIN SHIAI
END:VEVENT

any Ideas?

I just tried to add several different iCalendar links. However, an error occurs every single time "Error while creating iCal File. Please check, if Url is correct and Internet connection of server is enabled."

Does this error just occurs for me or is it the same problem for someone else, too? How can this problem be fixed?

If I use in the "normal" calendar module the function recurring appointments and change or delete afterwards one appointment, it isn't adopted to the calendars, which has subscribed to the external calendar. If I change the whole series, it will be adopted. (Humhub 1.9.1, external calendar 1.2.0, calendar-module 1.1.10)

Every time an external calendar is synchronized, all of the events in the calendar seem to be re-posted and appear at the top of the stream.

Is there a way to prevent existing calendar entries from moving back to the top of the stream on every sync?

hi
manually or automatically, I can't seem to fetch events from a shared calendar ..
is it a know issue recently?

I have this in the logs:

`INFO Sat, 12 Nov 2022 01:27:16 +0100 application
$_GET = [
'id' => '2'
'pjax' => '#layout-content'
'' => '166842'
'cguid' => 'a428a577-e79499a67e'
]

$_SERVER = [
'TEMP' => '/home/tmp'
'TMPDIR' => '/home/tmp'
'TMP' => '/home/tmp'
'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin'
'HOSTNAME' => ''
'USER' => 'user'
'HOME' => '/home/'
'SCRIPT_NAME' => '/index.php'
'REQUEST_URI' => '/s/actualites/external_calendar/calendar/edit?id=2&pjax=%23layout-content&=1662'
'QUERY_STRING' => 'id=2&pjax=%23layout-content&=1662'
'REQUEST_METHOD' => 'POST'
'SERVER_PROTOCOL' => 'HTTP/1.0'
'GATEWAY_INTERFACE' => 'CGI/1.1'
'REDIRECT_QUERY_STRING' => 'id=2&pjax=%23layout-content&=162'
'REDIRECT_URL' => '/s/actualites/external_calendar/calendar/edit'
'REMOTE_PORT' => '49020'
'SCRIPT_FILENAME' => '/home/eve/web/public_html/index.php'
'SERVER_ADMIN' => '[email protected]'
'CONTEXT_DOCUMENT_ROOT' => '/home/web/hub.net/public_html/'
'CONTEXT_PREFIX' => ''
'REQUEST_SCHEME' => 'https'
'DOCUMENT_ROOT' => '/home/web/hub.net/public_html/'
'REMOTE_ADDR' => '99.55.122.235'
'SERVER_PORT' => '443'
'SERVER_ADDR' => '111.112.278.55'
'SERVER_NAME' => 'humhub.net'
'SERVER_SOFTWARE' => 'Apache/2.4.54 (Ubuntu) mod_fcgid/2.3.9 OpenSSL/3.0.2'
'SERVER_SIGNATURE' => ''
'HTTP_COOKIE' => 'PHPSESSID=25b7; _identity=8285758422_identity%22%3B7D; _csrf=76b%22_csrf%22%3BiD'
'HTTP_CF_CONNECTING_IP' => '99.55.122.235'
'HTTP_PRIORITY' => 'u=0'
'HTTP_REFERER' => 'https://hub.net/s/actualites/external_calendar/calendar/edit?id=2'
'HTTP_SEC_FETCH_DEST' => 'document'
'HTTP_SEC_FETCH_USER' => '?1'
'HTTP_SEC_FETCH_MODE' => 'navigate'
'HTTP_SEC_FETCH_SITE' => 'same-origin'
'HTTP_ACCEPT_LANGUAGE' => 'fr-FR,fr;q=0.5'
'HTTP_SEC_GPC' => '1'
'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,/;q=0.8'
'HTTP_USER_AGENT' => 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36'
'CONTENT_TYPE' => 'application/x-www-form-urlencoded'
'HTTP_ORIGIN' => 'https://my.domain.net'
'HTTP_UPGRADE_INSECURE_REQUESTS' => '1'
'HTTP_CACHE_CONTROL' => 'max-age=0'
'HTTP_CF_VISITOR' => '{"scheme":"https"}'
'HTTP_X_FORWARDED_PROTO' => 'https'
'HTTP_CF_RAY' => '76G'
'HTTP_ACCEPT_ENCODING' => 'gzip'
'HTTP_CDN_LOOP' => 'cloudflare'
'HTTP_CF_IPCOUNTRY' => 'FR'
'CONTENT_LENGTH' => '412'
'HTTP_CONNECTION' => 'close'
'HTTP_X_FORWARDED_FOR' => '99.55.122.235, 99.55.122.2354'
'HTTP_HOST' => 'hub.net'
'proxy-nokeepalive' => '1'
'HTTPS' => 'on'
'REDIRECT_STATUS' => '200'
'REDIRECT_HTTPS' => 'on'
'FCGI_ROLE' => 'RESPONDER'
'PHP_SELF' => '/index.php'
'REQUEST_TIME_FLOAT' => 1668212836.7174
'REQUEST_TIME' => 1668212836
]
ATTENTION Sat, 12 Nov 2022 01:27:17 +0100 application
yii\base\InvalidValueException: Error while creating ical... Check if link is reachable. in /home/web/hub.net/public_html/protected/modules/external_calendar/models/ICalSync.php:80
Stack trace:
#0 /home/protected/modules/external_calendar/controllers/CalendarController.php(108): humhub\modules\external_calendar\models\ICalSync->syncICal()
#1 [internal function]: humhub\modules\external_calendar\controllers\CalendarController->actionEdit()
#2 /home/protected/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
#3 /home/protected/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams()
#4 /home/protected/vendor/yiisoft/yii2/base/Module.php(552): yii\base\Controller->runAction()
#5 /home/protected/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction()
#6 /home/protected/vendor/yiisoft/yii2/base/Application.php(384): yii\web\Application->handleRequest()
#7 /home/index.php(25): yii\base\Application->run()
#8 {main}`

thanks if you can have a look at it

I believe it would be a good idea to add the title to some of the buttons (maybe even not only for this module).
e.g. the "Export" button (the screenshot down below). The icon is good, but if you open it the first time, it may confuse you; you will be unsure about that until you click it.

Thank you!

The description is all one one line. But in the database, the line breaks are present.
We need to add nl2br when rendering the description.

Over time, automatic synchronization leads to duplicate events in the calendar. So after a few days an event is listed 4x or more together.

I always solve this by doing a manual synchronization. Then each event is shown only once (as it should be). However, after a while the events double, due to the automatic synchronization.

The external calendar I sync is a Google Calendar.

Is this a bug or am I missing a setting to avoid events being shown twice in the calendar?

Database Exception – yii\db\Exception
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'recurrence_until' in 'where clause'
The SQL being executed was: SELECT external_calendar_entry.* FROM external_calendar_entry LEFT JOIN content ON external_calendar_entry.id = content.object_id LEFT JOIN contentcontainer ON content.contentcontainer_id = contentcontainer.id LEFT JOIN user ON content.created_by = user.id LEFT JOIN space ON contentcontainer.pk=space.id AND contentcontainer.class='humhub\modules\space\models\Space' LEFT JOIN user cuser ON contentcontainer.pk=cuser.id AND contentcontainer.class='humhub\modules\user\models\User' LEFT JOIN space_membership ON contentcontainer.pk=space_membership.space_id AND contentcontainer.class='humhub\modules\space\models\Space' AND space_membership.user_id=1 LEFT JOIN user_friendship cff ON cuser.id=cff.user_id AND cff.friend_user_id=1 WHERE (((start_datetime >= '2020-01-25 10:45:27') AND (start_datetime <= '2020-02-25 10:45:27')) OR ((end_datetime >= '2020-01-25 10:45:27') AND (end_datetime <= '2020-02-25 10:45:27')) OR ((external_calendar_entry.rrule IS NOT NULL) AND (external_calendar_entry.parent_event_id IS NULL) AND ((recurrence_until IS NULL) OR (recurrence_until >= '2020-01-25 10:45:27')))) AND ((contentcontainer.pk=1) AND (contentcontainer.class='humhub\modules\space\models\Space')) AND (space.id IS NOT NULL AND ( (space_membership.status=3) OR (content.visibility=1 AND space.visibility != 0)) OR cuser.id IS NOT NULL AND ( (content.visibility = 1) OR (content.visibility = 0 AND content.contentcontainer_id=1) OR (content.visibility = 0 AND cff.id IS NOT NULL))OR content.created_by=1) AND (external_calendar_entry.parent_event_id IS NULL) AND (content.object_model='humhub\modules\external_calendar\models\ExternalCalendarEntry') AND (content.object_model='humhub\modules\external_calendar\models\ExternalCalendarEntry') ORDER BY start_datetime LIMIT 5

Error Info: Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'recurrence_until' in 'where clause'
)

↵
Caused by: PDOException
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'recurrence_until' in 'where clause'

in /home3/danielrodd/public_html/app/protected/vendor/yiisoft/yii2/db/Command.php at line 1290

After updating from 1.3.3 to 1.4 all my dates are displayed multiple times in the calendar. And it is not possible anymore to get to the point where I can edit, delete or renew the URL from the external calendar. What can I do?

Hi
hh 1-13-0 and external-calendar 1.3.2 didn't fix my issues
which I can't understand, has my links (created by nextcloud) worked fine until not anymore. I can't find the origin of the problem.

Our calendars don't work, it's really a problem for us.
Would one just take a quick look at our log please?

Thanks

Error while creating iCal File. Please check, if Url is correct and Internet connection of server is enabled.

WARNING Thu, 29 Dec 2022 09:54:18 +0100 application yii\base\InvalidValueException: Error while creating ical... Check if link is reachable. in /home/protected/modules/external_calendar/models/ICalSync.php:80 Stack trace: #0 /home/protected/modules/external_calendar/controllers/CalendarController.php(108): humhub\modules\external_calendar\models\ICalSync->syncICal() #1 [internal function]: humhub\modules\external_calendar\controllers\CalendarController->actionEdit() #2 /home/protected/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array() #3 /home/protected/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams() #4 /home/protected/vendor/yiisoft/yii2/base/Module.php(552): yii\base\Controller->runAction() #5 /home/protected/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction() #6 /home/protected/vendor/yiisoft/yii2/base/Application.php(384): yii\web\Application->handleRequest() #7 /home/index.php(25): yii\base\Application->run()

`INFO  Thu, 29 Dec 2022 09:54:18 +0100 application
$_GET = [
'_pjax' => '#layout-content'
'_' => '1672267632640'
'cguid' => '4e33ef41-745d-4370-8b01-ac95cd2841de'
]

$_SERVER = [
'TEMP' => '/home/tmp'
'TMPDIR' => '/home/tmp'
'TMP' => '/home/tmp'
'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin'
'USER' => 'myself'
'HOME' => '/home/'
'SCRIPT_NAME' => '/index.php'
'REQUEST_URI' => '/s/053/external_calendar/calendar/edit?_pjax=%23layout-content&_=1672267632640'
'QUERY_STRING' => '_pjax=%23layout-content&_=1672267632640'
'REQUEST_METHOD' => 'POST'
'SERVER_PROTOCOL' => 'HTTP/1.0'
'GATEWAY_INTERFACE' => 'CGI/1.1'
'REDIRECT_QUERY_STRING' => '_pjax=%23layout-content&_=1672267632640'
'REDIRECT_URL' => '/s/053/external_calendar/calendar/edit'
'REMOTE_PORT' => '38662'
'SCRIPT_FILENAME' => '/home/index.php'
'SERVER_ADMIN' => '[email protected]'
'CONTEXT_DOCUMENT_ROOT' => '/home/'
'CONTEXT_PREFIX' => ''
'REQUEST_SCHEME' => 'https'
'DOCUMENT_ROOT' => '/home/'
'REMOTE_ADDR' => '12.345.123.123'
'SERVER_PORT' => '443'
'SERVER_ADDR' => '12.345.123.123'
'SERVER_NAME' => 'mon.domaine.net'
'SERVER_SOFTWARE' => 'Apache/2.4.54 (Ubuntu) mod_fcgid/2.3.9 OpenSSL/3.0.2'
'SERVER_SIGNATURE' => ''
'HTTP_COOKIE' => '_identity=111; PHPSESSID=222; _; language=333language00en-US; __Host-nc_sameSiteCookielax=true; __Host-nc_sameSiteCookiestrict=true'
'HTTP_CF_CONNECTING_IP' => '12.345.123.123'
'HTTP_REFERER' => 'https://mon.domaine.net/s/053/external_calendar/calendar/edit?_pjax=%23layout-content&_=123'
'HTTP_USER_AGENT' => 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Safari/605.1.15'
'HTTP_ACCEPT_LANGUAGE' => 'fr-fr'
'HTTP_ORIGIN' => 'https://mon.domaine.net'
'CONTENT_TYPE' => 'application/x-www-form-urlencoded'
'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
'HTTP_CF_VISITOR' => '{\"scheme\":\"https\"}'
'HTTP_X_FORWARDED_PROTO' => 'https'
'HTTP_CF_RAY' => '111-CDG'
'HTTP_ACCEPT_ENCODING' => 'gzip'
'HTTP_CDN_LOOP' => 'cloudflare'
'HTTP_CF_IPCOUNTRY' => 'FR'
'CONTENT_LENGTH' => '419'
'HTTP_CONNECTION' => 'close'
'HTTP_X_FORWARDED_FOR' => '12.345.123.123, 12.345.123.123'
'HTTP_HOST' => 'mon.domaine.net'
'proxy-nokeepalive' => '1'
'HTTPS' => 'on'
'REDIRECT_STATUS' => '200'
'REDIRECT_HTTPS' => 'on'
'FCGI_ROLE' => 'RESPONDER'
'PHP_SELF' => '/index.php'
'REQUEST_TIME_FLOAT' => 111.1111
'REQUEST_TIME' => 123456789
]`