groupoffice icon indicating copy to clipboard operation
groupoffice copied to clipboard

The event does not appear in the invited person's calendar

Open Yaaaxx opened this issue 3 months ago • 3 comments

Hi,

I'm currently in V25.0.57

I come back to you for the same problem. I start a new issue because the old one was messy.

So, when I create an event in the calendar with and add a user in the invitation field, click send email to participant, the event does not appear in the calendar of the participant.

For information, I don't use email so the email module is disable and uninstalled.

I found an error in the debug.log :

[2025-10-07 12:58:26][JMAP CalendarEvent/set][log][go\core\App:792] SMTP Error: Could not authenticate.
[2025-10-07 12:58:26][JMAP CalendarEvent/set][log][go\core\orm\EntityType:616] Pushing 3 JMAP sync changes
[2025-10-07 12:58:26][JMAP CalendarEvent/set][error][go\core\ErrorHandler:90] Lock jmap-set-lock by 6 in request JMAP CalendarEvent/set with pid 207456 took 1.2091200351715s
[2025-10-07 12:58:26][JMAP CalendarEvent/countMine][log][go\core\jmap\Router:107] Method CalendarEvent/countMine,  ID: clientCallId-6
[2025-10-07 12:58:26][JMAP CalendarEvent/query][log][go\core\jmap\Router:107] Method CalendarEvent/query,  ID: CalendarEvent_5
[2025-10-07 12:58:26][JMAP CalendarEvent/query][log][go\core\jmap\Router:107] Method CalendarEvent/query,  ID: CalendarEvent_6
[2025-10-07 12:58:26][JMAP CalendarEvent/changes][log][go\core\jmap\Router:107] Method CalendarEvent/changes,  ID: CalendarEvent_7
[2025-10-07 12:58:26][JMAP CalendarEvent/changes][log][go\core\model\Acl:371]
        SELECT agc.aclId, granted
        FROM `core_acl_group_changes` `agc`
        INNER JOIN `core_user_group` `ugc` ON
         agc.groupId = ugc.groupId
        WHERE
         `ugc`.`userId` = 6
        AND `agc`.`modSeq` > '0'
        AND `agc`.`aclId` IN (
                SELECT DISTINCT aclId
                FROM `calendar_calendar` `t`
        )
[2025-10-07 12:58:26][JMAP CalendarEvent/changes][log][go\core\model\Acl:378]
        Array
        (
        )

[2025-10-07 12:58:26][JMAP CalendarEvent/changes][log][go\core\jmap\Router:107] Method CalendarEvent/changes,  ID: CalendarEvent_8
[2025-10-07 12:58:26][JMAP CalendarEvent/changes][log][go\core\model\Acl:371]
        SELECT agc.aclId, granted
        FROM `core_acl_group_changes` `agc`
        INNER JOIN `core_user_group` `ugc` ON
         agc.groupId = ugc.groupId
        WHERE
         `ugc`.`userId` = 6
        AND `agc`.`modSeq` > '0'
        AND `agc`.`aclId` IN (
                SELECT DISTINCT aclId
                FROM `calendar_calendar` `t`
        )
[2025-10-07 12:58:26][JMAP CalendarEvent/changes][log][go\core\model\Acl:378]
        Array
        (
        )

[2025-10-07 12:58:26][JMAP CalendarEvent/get][log][go\core\jmap\Router:107] Method CalendarEvent/get,  ID: CalendarEvent_9
[2025-10-07 12:58:26][JMAP CalendarEvent/get][log][go\core\acl\model\AclItemEntity:303]
        SELECT calendar_calendar.id, calendar_calendar.name, calendar_calendar.description, calendar_calendar.defaultColor, calendar_calendar.timeZone, calendar_calendar.webcalUri, calendar_calendar.groupId, calendar_calendar.aclId, calendar_calendar.createdBy, calendar_calendar.ownerId, calendar_calendar.highestIt>
        FROM `calendar_calendar`
        LEFT JOIN `calendar_calendar_user` `caluser` ON
         calendar_calendar.id = caluser.id AND caluser.userId = 6
        WHERE
         calendar_calendar.id = '4'

[2025-10-07 12:58:29][sse.php][log][go\core\model\PushDispatcher:145] Closing DB connection: 470
[2025-10-07 12:58:29][sse.php][log][go\core\model\PushDispatcher:153] SSE Memory usage: 497176
[2025-10-07 12:58:29][JMAP CalendarEvent/changes][log][go\core\jmap\Router:107] Method CalendarEvent/changes,  ID: CalendarEvent_34
[2025-10-07 12:58:29][JMAP CalendarEvent/changes][log][go\core\model\Acl:371]
        SELECT agc.aclId, granted
        FROM `core_acl_group_changes` `agc`
        INNER JOIN `core_user_group` `ugc` ON
         agc.groupId = ugc.groupId
        WHERE
         `ugc`.`userId` = 5
        AND `agc`.`modSeq` > '0'
        AND `agc`.`aclId` IN (
                SELECT DISTINCT aclId
                FROM `calendar_calendar` `t`
        )
[2025-10-07 12:58:29][JMAP CalendarEvent/changes][log][go\core\model\Acl:378]
        Array
        (
        )

[2025-10-07 12:58:29][JMAP CalendarEvent/countMine][log][go\core\jmap\Router:107] Method CalendarEvent/countMine,  ID: clientCallId-12
[2025-10-07 12:58:29][JMAP CalendarEvent/query][log][go\core\jmap\Router:107] Method CalendarEvent/query,  ID: CalendarEvent_35
[2025-10-07 12:58:29][JMAP CalendarEvent/query][log][go\core\jmap\Router:107] Method CalendarEvent/query,  ID: CalendarEvent_36
[2025-10-07 12:58:29][JMAP CalendarEvent/get][log][go\core\jmap\Router:107] Method CalendarEvent/get,  ID: CalendarEvent_37
[2025-10-07 12:58:29][JMAP CalendarEvent/get][log][go\core\acl\model\AclItemEntity:303]
        SELECT calendar_calendar.id, calendar_calendar.name, calendar_calendar.description, calendar_calendar.defaultColor, calendar_calendar.timeZone, calendar_calendar.webcalUri, calendar_calendar.groupId, calendar_calendar.aclId, calendar_calendar.createdBy, calendar_calendar.ownerId, calendar_calendar.highestIt>
        FROM `calendar_calendar`
        LEFT JOIN `calendar_calendar_user` `caluser` ON
         calendar_calendar.id = caluser.id AND caluser.userId = 5
        WHERE
         calendar_calendar.id = '3'
[2025-10-07 12:58:38][index.php?r=core/auth/checkclient][log][GO\Base\Controller\AbstractController:488] Is the user switched: false
[2025-10-07 12:58:41][sse.php][log][go\core\model\PushDispatcher:145] Closing DB connection: 476
[2025-10-07 12:58:41][sse.php][log][go\core\model\PushDispatcher:153] SSE Memory usage: 497072
[2025-10-07 12:58:50][index.php?r=core/auth/checkclient][log][GO\Base\Controller\AbstractController:488] Is the user switched: false
[2025-10-07 12:58:50][index.php?r=email/account/checkUnseen][log][GO\Email\Controller\AccountController:173] Session writing closed
[2025-10-07 12:58:50][index.php?r=email/account/checkUnseen][log][GO\Base\Router:179]
        EXCEPTION: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'groupoffice.em_accounts' doesn't exist in /usr/share/groupoffice/go/base/db/Columns.php:78
        Stack trace:
        #0 /usr/share/groupoffice/go/base/db/Columns.php(78): PDO->query()
        #1 /usr/share/groupoffice/go/base/db/ActiveRecord.php(497): GO\Base\Db\Columns::getColumns()
        #2 /usr/share/groupoffice/go/base/Model.php(130): GO\Base\Db\ActiveRecord->__construct()
        #3 /usr/share/groupoffice/modules/email/model/Account.php(108): GO\Base\Model::model()
        #4 /usr/share/groupoffice/modules/email/controller/AccountController.php(179): GO\Email\Model\Account::model()
        #5 /usr/share/groupoffice/go/base/controller/AbstractController.php(491): GO\Email\Controller\AccountController->actionCheckUnseen()
        #6 /usr/share/groupoffice/go/base/controller/AbstractController.php(388): GO\Base\Controller\AbstractController->callActionMethod()
        #7 /usr/share/groupoffice/go/base/Router.php(179): GO\Base\Controller\AbstractController->run()
        #8 /usr/share/groupoffice/controller/CoreController.php(604): GO\Base\Router->runController()
        #9 /usr/share/groupoffice/go/base/controller/AbstractController.php(491): GO\Core\Controller\CoreController->actionMultiRequest()
        #10 /usr/share/groupoffice/go/base/controller/AbstractController.php(388): GO\Base\Controller\AbstractController->callActionMethod()
        #11 /usr/share/groupoffice/go/base/Router.php(179): GO\Base\Controller\AbstractController->run()
        #12 /usr/share/groupoffice/index.php(130): GO\Base\Router->runController()
        #13 {main}
[2025-10-07 12:58:50][index.php?r=email/account/checkUnseen][error][go\core\ErrorHandler:70] PDOException in /usr/share/groupoffice/go/base/db/Columns.php at line 78: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'groupoffice.em_accounts' doesn't exist
[2025-10-07 12:58:50][index.php?r=email/account/checkUnseen][error][go\core\ErrorHandler:79] #0 /usr/share/groupoffice/go/base/db/Columns.php(78): PDO->query()
[2025-10-07 12:58:50][index.php?r=email/account/checkUnseen][error][go\core\ErrorHandler:79] #1 /usr/share/groupoffice/go/base/db/ActiveRecord.php(497): GO\Base\Db\Columns::getColumns()
[2025-10-07 12:58:50][index.php?r=email/account/checkUnseen][error][go\core\ErrorHandler:79] #2 /usr/share/groupoffice/go/base/Model.php(130): GO\Base\Db\ActiveRecord->__construct()
[2025-10-07 12:58:50][index.php?r=email/account/checkUnseen][error][go\core\ErrorHandler:79] #3 /usr/share/groupoffice/modules/email/model/Account.php(108): GO\Base\Model::model()
[2025-10-07 12:58:50][index.php?r=email/account/checkUnseen][error][go\core\ErrorHandler:79] #4 /usr/share/groupoffice/modules/email/controller/AccountController.php(179): GO\Email\Model\Account::model()
[2025-10-07 12:58:50][index.php?r=email/account/checkUnseen][error][go\core\ErrorHandler:79] #5 /usr/share/groupoffice/go/base/controller/AbstractController.php(491): GO\Email\Controller\AccountController->actionCheckUnseen()
[2025-10-07 12:58:50][index.php?r=email/account/checkUnseen][error][go\core\ErrorHandler:79] #6 /usr/share/groupoffice/go/base/controller/AbstractController.php(388): GO\Base\Controller\AbstractController->callActionMethod()
[2025-10-07 12:58:50][index.php?r=email/account/checkUnseen][error][go\core\ErrorHandler:79] #7 /usr/share/groupoffice/go/base/Router.php(179): GO\Base\Controller\AbstractController->run()
[2025-10-07 12:58:50][index.php?r=email/account/checkUnseen][error][go\core\ErrorHandler:79] #8 /usr/share/groupoffice/controller/CoreController.php(604): GO\Base\Router->runController()
[2025-10-07 12:58:50][index.php?r=email/account/checkUnseen][error][go\core\ErrorHandler:79] #9 /usr/share/groupoffice/go/base/controller/AbstractController.php(491): GO\Core\Controller\CoreController->actionMultiRequest()
[2025-10-07 12:58:50][index.php?r=email/account/checkUnseen][error][go\core\ErrorHandler:79] #10 /usr/share/groupoffice/go/base/controller/AbstractController.php(388): GO\Base\Controller\AbstractController->callActionMethod()
[2025-10-07 12:58:50][index.php?r=email/account/checkUnseen][error][go\core\ErrorHandler:79] #11 /usr/share/groupoffice/go/base/Router.php(179): GO\Base\Controller\AbstractController->run()
[2025-10-07 12:58:50][index.php?r=email/account/checkUnseen][error][go\core\ErrorHandler:79] #12 /usr/share/groupoffice/index.php(130): GO\Base\Router->runController()
[2025-10-07 12:58:50][index.php?r=email/account/checkUnseen][error][go\core\ErrorHandler:79] #13 {main}
[2025-10-07 12:58:51][sse.php][log][go\core\model\PushDispatcher:145] Closing DB connection: 478
[2025-10-07 12:58:51][sse.php][log][go\core\model\PushDispatcher:153] SSE Memory usage: 499032
[2025-10-07 12:58:52][index.php?r=][log][GO\Core\Controller\AuthController:28] GO\Base\Observable::cacheListeners
[2025-10-07 12:58:52][index.php?r=][log][GO\Base\ModuleCollection:146] setIgnoreAclPermissions(true)
[2025-10-07 12:58:52][index.php?r=][log][GO\Files\FilesModule:47] addListener(store,GO\Files\FilesModule, afterBatchEditStore) => GO\Core\Controller\BatchEditController
[2025-10-07 12:58:52][index.php?r=][log][GO\Base\ModuleCollection:156] setIgnoreAclPermissions(false)

Is it a normal working or a real bug ?

Thanks, Yaël

Yaaaxx avatar Oct 07 '25 13:10 Yaaaxx

I don't understand why those e-mail module errors are there if it's uninstalled. Can you run /install/upgrade.php to clear cache?

I'm unsure how the scheduling will work without the e-mail module. When you invite a user it has to be processed via an e-mail. Do you use caldav and e-mail via a client? It could work via caldav.

mschering avatar Oct 13 '25 07:10 mschering

Effectly, after a reset of the cache, I don't have errors.

I looked in the code to understand how work the scheduling. I haven't found a part to add an event in the calendar of the participant when the email module isn't enabled.

On the 6.8, when the email was disabled, this functioning was working. Adding this option can be good for person who don't use email module

Yaaaxx avatar Oct 13 '25 08:10 Yaaaxx

Added it for the next release without the check for autoAddInvitations. This doesn't happen twice anyhow.

dehart avatar Nov 24 '25 11:11 dehart