The Basics
- Nextcloud Server version (e.g., 29.x.x):
- 31.0.6
- Operating system and version (e.g., Ubuntu 24.04):
- Ubuntu 22.04.5
- Web server and version (e.g, Apache 2.4.25):
- Apache 2.4.52
- Reverse proxy and version _(e.g. nginx 1.27.2)
- traefik 3.4
- PHP version (e.g, 8.3):
- 8.3
- MySQL Server Version
- 8.0.42-0ubuntu0.22.04.1 (Ubuntu)
- Is this the first time you’ve seen this error? (Yes / No):
- Yes
- When did this problem seem to first start?
- When I tried to install the “Nextcloud Office” App
- Installation method (e.g. AlO, NCP, Bare Metal/Archive, etc.)
- Archive
- Are you using CloudfIare, mod_security, or similar? (Yes / No)
- No
Summary of the issue you are facing:
I tried installing the Nextcloud Office App using the App Store in the Browser but I also tried installing the app via OCC. It returns the Error:
Es ist ein Fehler bei der Anfrage aufgetreten. Es kann nicht fortgefahren werden.
Index name “schedulobj_lastmodified_idx” for table “oc_schedulingobjects” collides with the constraint on table “oc_calendarobjects”.
Steps to replicate it (hint: details matter!):
- Open https:///settings/apps/discover/richdocuments
- Click Install
Log entries
Nextcloud
{"reqId":"wMAku4Tx6wSrVlSbmSkS","level":0,"time":"2025-06-24T14:23:33+00:00","remoteAddr":"1.2.3.4","user":"admin","app":"richdocuments","method":"POST","url":"/settings/apps/enable","message":"- Checking target database schema","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:139.0) Gecko/20100101 Firefox/139.0","version":"31.0.6.2","data":{"app":"richdocuments"}}
{"reqId":"wMAku4Tx6wSrVlSbmSkS","level":3,"time":"2025-06-24T14:23:33+00:00","remoteAddr":"1.2.3.4","user":"admin","app":"settings","method":"POST","url":"/settings/apps/enable","message":"could not enable apps","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:139.0) Gecko/20100101 Firefox/139.0","version":"31.0.6.2","exception":{"Exception":"InvalidArgumentException","Message":"Index name \"schedulobj_lastmodified_idx\" for table \"oc_schedulingobjects\" collides with the constraint on table \"oc_calendarobjects\".","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/private/DB/MigrationService.php","line":429,"function":"ensureUniqueNamesConstraints","class":"OC\\DB\\MigrationService","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/MigrationService.php","line":387,"function":"migrateSchemaOnly","class":"OC\\DB\\MigrationService","type":"->"},{"file":"/var/www/nextcloud/lib/private/Installer.php","line":105,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->"},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/AppSettingsController.php","line":531,"function":"installApp","class":"OC\\Installer","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":200,"function":"enableApps","class":"OCA\\Settings\\Controller\\AppSettingsController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":114,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":307,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":1040,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":24,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/lib/private/DB/MigrationService.php","Line":677,"message":"could not enable apps","exception":{},"CustomMessage":"could not enable apps"}}
Configuration
Nextcloud
{
"system": {
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"skeletondirectory": "",
"htaccess.RewriteBase": "\/",
"trusted_domains": [
"cloud.example.com",
"cloud-test.example.com"
],
"allow_local_remote_servers": true,
"maintenance": false,
"memcache.distributed": "\\OC\\Memcache\\Redis",
"memcache.local": "\\OC\\Memcache\\Redis",
"memcache.locking": "\\OC\\Memcache\\Redis",
"redis": {
"host": "***REMOVED SENSITIVE VALUE***",
"port": 6379
},
"trusted_proxies": "***REMOVED SENSITIVE VALUE***",
"enable_previews": false,
"default_phone_region": "DE",
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"dbtype": "mysql",
"version": "31.0.6.2",
"overwrite.cli.url": "http:\/\/localhost",
"dbname": "***REMOVED SENSITIVE VALUE***",
"dbhost": "***REMOVED SENSITIVE VALUE***",
"dbport": "",
"dbtableprefix": "oc_",
"mysql.utf8mb4": true,
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"installed": true,
"instanceid": "***REMOVED SENSITIVE VALUE***",
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"mail_smtpmode": "smtp",
"mail_sendmailmode": "smtp",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"mail_smtphost": "***REMOVED SENSITIVE VALUE***",
"mail_smtpport": "465",
"maintenance_window_start": 1,
"loglevel": 0,
"log_type": "file",
"logfile": "\/var\/log\/nextcloud\/nextcloud.log",
"log.condition": {
"apps": [
"admin_audit"
]
},
"theme": "",
"twofactor_enforced": "false",
"twofactor_enforced_groups": [],
"twofactor_enforced_excluded_groups": [],
"mail_smtpsecure": "ssl",
"mail_smtpauth": 1,
"mail_smtpname": "***REMOVED SENSITIVE VALUE***",
"mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
"app_install_overwrite": []
}
}
Apps
Enabled:
- activity: 4.0.0
- admin_audit: 1.21.0
- app_api: 5.0.2
- bruteforcesettings: 4.0.0
- calendar: 5.3.3
- circles: 31.0.0
- cloud_federation_api: 1.14.0
- collectives: 2.18.0
- comments: 1.21.0
- contacts: 7.1.3
- contactsinteraction: 1.12.0
- dashboard: 7.11.0
- dav: 1.33.0
- deck: 1.15.1
- drawio: 3.1.0
- federatedfilesharing: 1.21.0
- federation: 1.21.0
- files: 2.3.1
- files_downloadlimit: 4.0.0
- files_pdfviewer: 4.0.0
- files_reminders: 1.4.0
- files_sharing: 1.23.1
- files_trashbin: 1.21.0
- files_versions: 1.24.0
- firstrunwizard: 4.0.0
- impersonate: 2.0.0
- logreader: 4.0.0
- lookup_server_connector: 1.19.0
- mail: 5.1.4
- nextcloud_announcements: 3.0.0
- notifications: 4.0.0
- oauth2: 1.19.1
- password_policy: 3.0.0
- photos: 4.0.0-dev.1
- privacy: 3.0.0
- profile: 1.0.0
- provisioning_api: 1.21.0
- recommendations: 4.0.0
- related_resources: 2.0.0
- serverinfo: 3.0.0
- settings: 1.14.0
- sharebymail: 1.21.0
- spreed: 21.1.0
- support: 3.0.0
- survey_client: 3.0.0
- systemtags: 1.21.1
- tasks: 0.16.1
- text: 5.0.0
- theming: 2.6.1
- twofactor_backupcodes: 1.20.0
- twofactor_totp: 13.0.0-dev.0
- updatenotification: 1.21.0
- user_status: 1.11.0
- viewer: 4.0.0
- weather_status: 1.11.0
- webhook_listeners: 1.2.0
- workflowengine: 2.13.0
Disabled:
- bookmarks: 15.1.0 (installed 15.1.0)
- encryption: 2.19.0
- files_external: 1.23.0
- files_rightclick: 0.15.1 (installed 1.6.0)
- richdocuments: 8.7.1
- sociallogin: 6.0.2 (installed 6.0.2)
- suspicious_login: 9.0.1
- twofactor_nextcloud_notification: 5.0.0
- user_ldap: 1.22.0