I'm on NC 31.0.9.
Today I upgraded Group Folders to latest available version for… me (19.1.5). Since then, I cannot access the Admin Dashboard anymore and sync does not work.
Error: f.root_id column not found.
The table definition of oc_group_folders currently is:
```
CREATE TABLE `oc_group_folders` (
`folder_id` bigint(20) NOT NULL AUTO_INCREMENT,
`mount_point` varchar(4000) NOT NULL,
`quota` bigint(20) NOT NULL,
`acl` int(11) DEFAULT 0,
PRIMARY KEY (`folder_id`),
UNIQUE KEY `gf_folders_folder_id` (`folder_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
```
No update available:
```
occ app:update --all
All apps are up-to-date or no updates could be found
```
Installed apps:
```
occ app:list
#Enabled:
- activity: 4.0.0
- admin_audit: 1.21.0
- analytics: 6.0.0
- app_api: 5.0.2
- bruteforcesettings: 4.0.0
- calendar: 5.5.4
- circles: 31.0.0
- cloud_federation_api: 1.14.0
- collectives: 3.1.2
- comments: 1.21.0
- contacts: 7.3.1
- contactsinteraction: 1.12.0
- dashboard: 7.11.0
- dav: 1.33.0
- deck: 1.15.2
- external: 6.0.2
- 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
- groupfolders: 19.1.5
- impersonate: 2.0.0
- logreader: 4.0.0
- lookup_server_connector: 1.19.0
- mail: 5.5.1
- memories: 7.6.2
- nextcloud_announcements: 3.0.0
- notifications: 4.0.0
- oauth2: 1.19.1
- password_policy: 3.0.0
- previewgenerator: 5.10.0
- privacy: 3.0.0
- profile: 1.0.0
- provisioning_api: 1.21.0
- quota_warning: 1.21.0
- recommendations: 4.0.0
- related_resources: 2.0.0
- serverinfo: 3.0.0
- settings: 1.14.0
- sharebymail: 1.21.0
- support: 3.0.0
- survey_client: 3.0.0
- suspicious_login: 9.0.1
- systemtags: 1.21.1
- tasks: 0.16.1
- text: 5.0.0
- theming: 2.6.1
- theming_customcss: 1.18.0
- 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:
- encryption: 2.19.0 (installed 2.8.1)
- files_accesscontrol: 2.0.0 (installed 2.0.0)
- files_antivirus: 6.0.4 (installed 6.0.4)
- files_external: 1.23.0
- photos: 4.0.0 (installed 2.5.0)
- spreed: 21.1.5 (installed 21.1.5)
- twofactor_nextcloud_notification: 5.0.0
- user_ldap: 1.22.0
```
Is there a migration missing? I see the table change was in 19.1.4, so I think I was on 19.1.3.
https://github.com/nextcloud/groupfolders/blob/v19.1.4/lib/Migration/Version20000Date20250612140256.php
I upgraded from the admin dashboard webui. After the upgrade, the admin dashboard is not available anymore.
### Steps to reproduce
1. Upgrade to latest version
2. Access the Dashboard
3. Error occurs. Check logs to get trace
### Expected behaviour
It works as it was working before. Group-Folders was on former version.
### Actual behaviour
Group Folders causes fatal error, because the db schema for group_folders table is missing column root_id
### Server configuration
**Operating system:**
Rocky 10.0
**Web server:**
Apache php-fpm
**Database:**
MariaDB 10.11.11
**PHP version:**
8.4.12
**Nextcloud version:** (see Nextcloud admin page)
31.0.9
**Team folders version:**
groupfolders: 19.1.5
**Updated from an older Nextcloud/ownCloud or fresh install:**
Updated from current NC group-folders version (was: former version updated last friday, Sep/08/25)
**Where did you install Nextcloud from:**
Official Webpage. It is running since years without a problem.
**Are you using external storage, if yes which one:** local/s3/smb/sftp/...
separate local volume for NC data dir
**Are you using encryption:** yes/no
No.
**Are you using an external user-backend, if yes which one:** LDAP/ActiveDirectory/Webdav/Saml/...
No.
### Client configuration
**Browser:**
Safari macOS. But it doesn't matter. FF also does not work
**Operating system:**
Rocky 10.
### Logs
#### Web server error log
<details>
<summary>Web server error log</summary>
```
Webserver / php-fpm error_log files are empty.
```
</details>
#### Nextcloud log (data/nextcloud.log)
<details>
<summary>Nextcloud log</summary>
```
{
"reqId": "aMwyzth0ri7aNubuflnAPwAAyQg",
"level": 3,
"time": "2025-09-18T17:26:54+01:00",
"remoteAddr": "2a02:****:****:****:****:****:****:****",
"user": "*****************",
"app": "index",
"method": "GET",
"url": "/index.php/settings/admin/overview",
"message": "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'f.root_id' in 'ON'",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.6 Safari/605.1.15",
"version": "31.0.9.1",
"exception": {
"Exception": "OC\\DB\\Exceptions\\DbalException",
"Message": "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'f.root_id' in 'ON'",
"Code": 1054,
"Trace": [
{
"file": "/var/www/html/lib/private/DB/ConnectionAdapter.php",
"line": 53,
"function": "wrap",
"class": "OC\\DB\\Exceptions\\DbalException",
"type": "::"
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 289,
"function": "executeQuery",
"class": "OC\\DB\\ConnectionAdapter",
"type": "->"
},
{
"file": "/var/www/html/apps/groupfolders/lib/Folder/FolderManager.php",
"line": 667,
"function": "executeQuery",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->"
},
{
"file": "/var/www/html/apps/groupfolders/lib/Folder/FolderManager.php",
"line": 981,
"function": "getFoldersForGroups",
"class": "OCA\\GroupFolders\\Folder\\FolderManager",
"type": "->"
},
{
"file": "/var/www/html/apps/groupfolders/lib/AppInfo/Capabilities.php",
"line": 47,
"function": "getFoldersForUser",
"class": "OCA\\GroupFolders\\Folder\\FolderManager",
"type": "->"
},
{
"file": "/var/www/html/apps/groupfolders/lib/AppInfo/Capabilities.php",
"line": 41,
"function": "hasFolders",
"class": "OCA\\GroupFolders\\AppInfo\\Capabilities",
"type": "->"
},
{
"file": "/var/www/html/lib/private/CapabilitiesManager.php",
"line": 61,
"function": "getCapabilities",
"class": "OCA\\GroupFolders\\AppInfo\\Capabilities",
"type": "->"
},
{
"file": "/var/www/html/lib/private/Template/JSConfigHelper.php",
"line": 139,
"function": "getCapabilities",
"class": "OC\\CapabilitiesManager",
"type": "->"
},
{
"file": "/var/www/html/lib/private/TemplateLayout.php",
"line": 233,
"function": "getConfig",
"class": "OC\\Template\\JSConfigHelper",
"type": "->"
},
{
"file": "/var/www/html/lib/private/legacy/OC_Template.php",
"line": 120,
"function": "__construct",
"class": "OC\\TemplateLayout",
"type": "->"
},
{
"file": "/var/www/html/lib/public/AppFramework/Http/TemplateResponse.php",
"line": 189,
"function": "fetchPage",
"class": "OC_Template",
"type": "->"
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 159,
"function": "render",
"class": "OCP\\AppFramework\\Http\\TemplateResponse",
"type": "->"
},
{
"file": "/var/www/html/lib/private/AppFramework/App.php",
"line": 161,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->"
},
{
"file": "/var/www/html/lib/private/Route/Router.php",
"line": 315,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::"
},
{
"file": "/var/www/html/lib/base.php",
"line": 1063,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->"
},
{
"file": "/var/www/html/index.php",
"line": 24,
"function": "handleRequest",
"class": "OC",
"type": "::"
}
],
"File": "/var/www/html/lib/private/DB/Exceptions/DbalException.php",
"Line": 56,
"Previous": {
"Exception": "Doctrine\\DBAL\\Exception\\InvalidFieldNameException",
"Message": "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'f.root_id' in 'ON'",
"Code": 1054,
"Trace": [
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1976,
"function": "convert",
"class": "Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter",
"type": "->"
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1918,
"function": "handleDriverException",
"class": "Doctrine\\DBAL\\Connection",
"type": "->"
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1111,
"function": "convertExceptionDuringQuery",
"class": "Doctrine\\DBAL\\Connection",
"type": "->"
},
{
"file": "/var/www/html/lib/private/DB/Connection.php",
"line": 419,
"function": "executeQuery",
"class": "Doctrine\\DBAL\\Connection",
"type": "->"
},
{
"file": "/var/www/html/lib/private/DB/ConnectionAdapter.php",
"line": 50,
"function": "executeQuery",
"class": "OC\\DB\\Connection",
"type": "->"
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 289,
"function": "executeQuery",
"class": "OC\\DB\\ConnectionAdapter",
"type": "->"
},
{
"file": "/var/www/html/apps/groupfolders/lib/Folder/FolderManager.php",
"line": 667,
"function": "executeQuery",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->"
},
{
"file": "/var/www/html/apps/groupfolders/lib/Folder/FolderManager.php",
"line": 981,
"function": "getFoldersForGroups",
"class": "OCA\\GroupFolders\\Folder\\FolderManager",
"type": "->"
},
{
"file": "/var/www/html/apps/groupfolders/lib/AppInfo/Capabilities.php",
"line": 47,
"function": "getFoldersForUser",
"class": "OCA\\GroupFolders\\Folder\\FolderManager",
"type": "->"
},
{
"file": "/var/www/html/apps/groupfolders/lib/AppInfo/Capabilities.php",
"line": 41,
"function": "hasFolders",
"class": "OCA\\GroupFolders\\AppInfo\\Capabilities",
"type": "->"
},
{
"file": "/var/www/html/lib/private/CapabilitiesManager.php",
"line": 61,
"function": "getCapabilities",
"class": "OCA\\GroupFolders\\AppInfo\\Capabilities",
"type": "->"
},
{
"file": "/var/www/html/lib/private/Template/JSConfigHelper.php",
"line": 139,
"function": "getCapabilities",
"class": "OC\\CapabilitiesManager",
"type": "->"
},
{
"file": "/var/www/html/lib/private/TemplateLayout.php",
"line": 233,
"function": "getConfig",
"class": "OC\\Template\\JSConfigHelper",
"type": "->"
},
{
"file": "/var/www/html/lib/private/legacy/OC_Template.php",
"line": 120,
"function": "__construct",
"class": "OC\\TemplateLayout",
"type": "->"
},
{
"file": "/var/www/html/lib/public/AppFramework/Http/TemplateResponse.php",
"line": 189,
"function": "fetchPage",
"class": "OC_Template",
"type": "->"
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 159,
"function": "render",
"class": "OCP\\AppFramework\\Http\\TemplateResponse",
"type": "->"
},
{
"file": "/var/www/html/lib/private/AppFramework/App.php",
"line": 161,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->"
},
{
"file": "/var/www/html/lib/private/Route/Router.php",
"line": 315,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::"
},
{
"file": "/var/www/html/lib/base.php",
"line": 1063,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->"
},
{
"file": "/var/www/html/index.php",
"line": 24,
"function": "handleRequest",
"class": "OC",
"type": "::"
}
],
"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php",
"Line": 67,
"Previous": {
"Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
"Message": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'f.root_id' in 'ON'",
"Code": 1054,
"Trace": [
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"line": 132,
"function": "new",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
"type": "::"
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1104,
"function": "execute",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
"type": "->"
},
{
"file": "/var/www/html/lib/private/DB/Connection.php",
"line": 419,
"function": "executeQuery",
"class": "Doctrine\\DBAL\\Connection",
"type": "->"
},
{
"file": "/var/www/html/lib/private/DB/ConnectionAdapter.php",
"line": 50,
"function": "executeQuery",
"class": "OC\\DB\\Connection",
"type": "->"
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 289,
"function": "executeQuery",
"class": "OC\\DB\\ConnectionAdapter",
"type": "->"
},
{
"file": "/var/www/html/apps/groupfolders/lib/Folder/FolderManager.php",
"line": 667,
"function": "executeQuery",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->"
},
{
"file": "/var/www/html/apps/groupfolders/lib/Folder/FolderManager.php",
"line": 981,
"function": "getFoldersForGroups",
"class": "OCA\\GroupFolders\\Folder\\FolderManager",
"type": "->"
},
{
"file": "/var/www/html/apps/groupfolders/lib/AppInfo/Capabilities.php",
"line": 47,
"function": "getFoldersForUser",
"class": "OCA\\GroupFolders\\Folder\\FolderManager",
"type": "->"
},
{
"file": "/var/www/html/apps/groupfolders/lib/AppInfo/Capabilities.php",
"line": 41,
"function": "hasFolders",
"class": "OCA\\GroupFolders\\AppInfo\\Capabilities",
"type": "->"
},
{
"file": "/var/www/html/lib/private/CapabilitiesManager.php",
"line": 61,
"function": "getCapabilities",
"class": "OCA\\GroupFolders\\AppInfo\\Capabilities",
"type": "->"
},
{
"file": "/var/www/html/lib/private/Template/JSConfigHelper.php",
"line": 139,
"function": "getCapabilities",
"class": "OC\\CapabilitiesManager",
"type": "->"
},
{
"file": "/var/www/html/lib/private/TemplateLayout.php",
"line": 233,
"function": "getConfig",
"class": "OC\\Template\\JSConfigHelper",
"type": "->"
},
{
"file": "/var/www/html/lib/private/legacy/OC_Template.php",
"line": 120,
"function": "__construct",
"class": "OC\\TemplateLayout",
"type": "->"
},
{
"file": "/var/www/html/lib/public/AppFramework/Http/TemplateResponse.php",
"line": 189,
"function": "fetchPage",
"class": "OC_Template",
"type": "->"
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 159,
"function": "render",
"class": "OCP\\AppFramework\\Http\\TemplateResponse",
"type": "->"
},
{
"file": "/var/www/html/lib/private/AppFramework/App.php",
"line": 161,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->"
},
{
"file": "/var/www/html/lib/private/Route/Router.php",
"line": 315,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::"
},
{
"file": "/var/www/html/lib/base.php",
"line": 1063,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->"
},
{
"file": "/var/www/html/index.php",
"line": 24,
"function": "handleRequest",
"class": "OC",
"type": "::"
}
],
"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
"Line": 24,
"Previous": {
"Exception": "PDOException",
"Message": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'f.root_id' in 'ON'",
"Code": "42S22",
"Trace": [
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"line": 130,
"function": "execute",
"class": "PDOStatement",
"type": "->"
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1104,
"function": "execute",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
"type": "->"
},
{
"file": "/var/www/html/lib/private/DB/Connection.php",
"line": 419,
"function": "executeQuery",
"class": "Doctrine\\DBAL\\Connection",
"type": "->"
},
{
"file": "/var/www/html/lib/private/DB/ConnectionAdapter.php",
"line": 50,
"function": "executeQuery",
"class": "OC\\DB\\Connection",
"type": "->"
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 289,
"function": "executeQuery",
"class": "OC\\DB\\ConnectionAdapter",
"type": "->"
},
{
"file": "/var/www/html/apps/groupfolders/lib/Folder/FolderManager.php",
"line": 667,
"function": "executeQuery",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->"
},
{
"file": "/var/www/html/apps/groupfolders/lib/Folder/FolderManager.php",
"line": 981,
"function": "getFoldersForGroups",
"class": "OCA\\GroupFolders\\Folder\\FolderManager",
"type": "->"
},
{
"file": "/var/www/html/apps/groupfolders/lib/AppInfo/Capabilities.php",
"line": 47,
"function": "getFoldersForUser",
"class": "OCA\\GroupFolders\\Folder\\FolderManager",
"type": "->"
},
{
"file": "/var/www/html/apps/groupfolders/lib/AppInfo/Capabilities.php",
"line": 41,
"function": "hasFolders",
"class": "OCA\\GroupFolders\\AppInfo\\Capabilities",
"type": "->"
},
{
"file": "/var/www/html/lib/private/CapabilitiesManager.php",
"line": 61,
"function": "getCapabilities",
"class": "OCA\\GroupFolders\\AppInfo\\Capabilities",
"type": "->"
},
{
"file": "/var/www/html/lib/private/Template/JSConfigHelper.php",
"line": 139,
"function": "getCapabilities",
"class": "OC\\CapabilitiesManager",
"type": "->"
},
{
"file": "/var/www/html/lib/private/TemplateLayout.php",
"line": 233,
"function": "getConfig",
"class": "OC\\Template\\JSConfigHelper",
"type": "->"
},
{
"file": "/var/www/html/lib/private/legacy/OC_Template.php",
"line": 120,
"function": "__construct",
"class": "OC\\TemplateLayout",
"type": "->"
},
{
"file": "/var/www/html/lib/public/AppFramework/Http/TemplateResponse.php",
"line": 189,
"function": "fetchPage",
"class": "OC_Template",
"type": "->"
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 159,
"function": "render",
"class": "OCP\\AppFramework\\Http\\TemplateResponse",
"type": "->"
},
{
"file": "/var/www/html/lib/private/AppFramework/App.php",
"line": 161,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->"
},
{
"file": "/var/www/html/lib/private/Route/Router.php",
"line": 315,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::"
},
{
"file": "/var/www/html/lib/base.php",
"line": 1063,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->"
},
{
"file": "/var/www/html/index.php",
"line": 24,
"function": "handleRequest",
"class": "OC",
"type": "::"
}
],
"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"Line": 130
}
}
},
"message": "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'f.root_id' in 'ON'",
"exception": {
"query": "SELECT `f`.`folder_id`, `mount_point`, `quota`, `acl`, `c`.`fileid`, `c`.`storage`, `c`.`path`, `c`.`name`, `c`.`mimetype`, `c`.`mimepart`, `c`.`size`, `c`.`mtime`, `c`.`storage_mtime`, `c`.`etag`, `c`.`encrypted`, `c`.`parent`, `a`.`permissions` AS `group_permissions`, `c`.`permissions` AS `permissions` FROM `*PREFIX*group_folders` `f` INNER JOIN `*PREFIX*group_folders_groups` `a` ON `f`.`folder_id` = `a`.`folder_id` LEFT JOIN `*PREFIX*filecache` `c` ON `c`.`fileid` = `f`.`root_id` WHERE `a`.`group_id` IN (:groupIds)"
},
"CustomMessage": "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'f.root_id' in 'ON'"
}
}
```
</details>
#### Browser log
<details>
<summary>Browser log</summary>
```
Irrelevant.
```
</details>