NC33, setup check exception, missing columns not added by occ

Heracles31 · March 8, 2026, 6:11am

Support intro

Sorry to hear you’re facing problems.

The community help forum (help.nextcloud.com) is for home and non-enterprise users. Support is provided by other community members on a best effort / “as available” basis. All of those responding are volunteering their time to help you.

If you’re using Nextcloud in a business/critical setting, paid and SLA-based support services can be accessed via portal.nextcloud.com where Nextcloud engineers can help ensure your business keeps running smoothly.

Getting help

In order to help you as efficiently (and quickly!) as possible, please fill in as much of the below requested information as you can.

Before clicking submit: Please check if your query is already addressed via the following resources:

Official documentation (searchable and regularly updated)
How to topics and FAQs
Forum search

(Utilizing these existing resources is typically faster. It also helps reduce the load on our generous volunteers while elevating the signal to noise ratio of the forums otherwise arising from the same queries being posted repeatedly).

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can.

The Basics

Nextcloud Server version (e.g., 29.x.x):
- 33.0.0
Operating system and version (e.g., Ubuntu 24.04):
- Ubuntu 24
Web server and version (e.g, Apache 2.4.25):
- 2.4.66
Reverse proxy and version _(e.g. nginx 1.27.2)
- HAProxy (pfSense - 25.11.1)
PHP version (e.g, 8.3):
- 8.4.18
Is this the first time you’ve seen this error? (Yes / No):
- Yes
When did this problem seem to first start?
- Upgraded from Nextcloud 31.0.12 to 31.0.14, to 32.0.6 and to 33.0.0
Installation method (e.g. AlO, NCP, Bare Metal/Archive, etc.)
- Docker, not AIO
Are you using CloudfIare, mod_security, or similar? (Yes / No)
- No

Summary of the issue you are facing:

When I open the Admin Settings page, in the default Overview page, Security & Setup warnings shows errors. The one problematic here is: Task Processing pickup speed. Detailed is pasted below. It complains about missing column user_facing_error_message

An exception occured while running the setup check: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user_facing_error_message' in 'SELECT' in /var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php:130

As this is about missing columns, I used the occ command to add the missing ones.

occ db:add-missing-columns

After the upgrade, Nextcloud also asked for the missing indices and they were added too.

When I run

occ db:schema:expected

It does show that the user_facing_error_message column is expected. When I do

occ db:schema:export

the user_facing_error_message is indeed missing.

Questions :

As occ knows that the column is expected and missing, why it does not add it itself ?
I also begun to deploy Talk and was not done. The high capacity backend is not deployed yet, nor are the STUN / Turn servers.
There are other error messages like the websocket server not configured yet for the whiteboard. I intend to fix that after. I also intend to ignore HSTS (handled differently) or 2FA because authentication is performed externally by Keycloak (OIDC).
What the proper steps would be to fix that ? Add the column manually in MariaDB ? Uninstall / re-install an app ? Some other occ commands ?

Log entries

Nextcloud

Please provide the log entries from your Nextcloud log that are generated during the time of problem (via the Copy raw option from Administration settings->Logging screen or from your nextcloud.log located in your data directory). Feel free to use a pastebin/gist service if necessary.

An exception occured while running the setup check: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user_facing_error_message' in 'SELECT' in /var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php:130 Stack trace: #0 /var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php(130): PDOStatement->execute(NULL) #1 /var/www/html/3rdparty/doctrine/dbal/src/Connection.php(1104): Doctrine\DBAL\Driver\PDO\Statement->execute() #2 /var/www/html/lib/private/DB/Connection.php(420): Doctrine\DBAL\Connection->executeQuery('SELECT `id`, `l...', Array, Array, NULL) #3 /var/www/html/lib/private/DB/ConnectionAdapter.php(50): OC\DB\Connection->executeQuery('SELECT `id`, `l...', Array, Array) #4 /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php(268): OC\DB\ConnectionAdapter->executeQuery('SELECT `id`, `l...', Array, Array) #5 /var/www/html/lib/public/AppFramework/Db/QBMapper.php(336): OC\DB\QueryBuilder\QueryBuilder->executeQuery() #6 /var/www/html/lib/private/TaskProcessing/Db/TaskMapper.php(181): OCP\AppFramework\Db\QBMapper->findEntities(Object(OC\DB\QueryBuilder\QueryBuilder)) #7 /var/www/html/lib/private/TaskProcessing/Manager.php(1333): OC\TaskProcessing\Db\TaskMapper->findTasks('', NULL, NULL, NULL, NULL, 1772775180, NULL) #8 /var/www/html/apps/settings/lib/SetupChecks/TaskProcessingPickupSpeed.php(44): OC\TaskProcessing\Manager->getTasks('', NULL, NULL, NULL, NULL, 1772775180) #9 /var/www/html/lib/private/SetupCheck/SetupCheckManager.php(34): OCA\Settings\SetupChecks\TaskProcessingPickupSpeed->run() #10 /var/www/html/apps/settings/lib/Controller/CheckSetupController.php(132): OC\SetupCheck\SetupCheckManager->runAll() #11 /var/www/html/lib/private/AppFramework/Http/Dispatcher.php(205): OCA\Settings\Controller\CheckSetupController->check() #12 /var/www/html/lib/private/AppFramework/Http/Dispatcher.php(118): OC\AppFramework\Http\Dispatcher->executeController(Object(OCA\Settings\Controller\CheckSetupController), 'check') #13 /var/www/html/lib/private/AppFramework/App.php(153): OC\AppFramework\Http\Dispatcher->dispatch(Object(OCA\Settings\Controller\CheckSetupController), 'check') #14 /var/www/html/lib/private/Route/Router.php(321): OC\AppFramework\App::main('OCA\\Settings\\Co...', 'check', Object(OC\AppFramework\DependencyInjection\DIContainer), Array) #15 /var/www/html/lib/base.php(1155): OC\Route\Router->match('/settings/ajax/...') #16 /var/www/html/index.php(25): OC::handleRequest() #17 {main} Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user_facing_error_message' in 'SELECT' in /var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php:24 Stack trace: #0 /var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php(132): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException)) #1 /var/www/html/3rdparty/doctrine/dbal/src/Connection.php(1104): Doctrine\DBAL\Driver\PDO\Statement->execute() #2 /var/www/html/lib/private/DB/Connection.php(420): Doctrine\DBAL\Connection->executeQuery('SELECT `id`, `l...', Array, Array, NULL) #3 /var/www/html/lib/private/DB/ConnectionAdapter.php(50): OC\DB\Connection->executeQuery('SELECT `id`, `l...', Array, Array) #4 /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php(268): OC\DB\ConnectionAdapter->executeQuery('SELECT `id`, `l...', Array, Array) #5 /var/www/html/lib/public/AppFramework/Db/QBMapper.php(336): OC\DB\QueryBuilder\QueryBuilder->executeQuery() #6 /var/www/html/lib/private/TaskProcessing/Db/TaskMapper.php(181): OCP\AppFramework\Db\QBMapper->findEntities(Object(OC\DB\QueryBuilder\QueryBuilder)) #7 /var/www/html/lib/private/TaskProcessing/Manager.php(1333): OC\TaskProcessing\Db\TaskMapper->findTasks('', NULL, NULL, NULL, NULL, 1772775180, NULL) #8 /var/www/html/apps/settings/lib/SetupChecks/TaskProcessingPickupSpeed.php(44): OC\TaskProcessing\Manager->getTasks('', NULL, NULL, NULL, NULL, 1772775180) #9 /var/www/html/lib/private/SetupCheck/SetupCheckManager.php(34): OCA\Settings\SetupChecks\TaskProcessingPickupSpeed->run() #10 /var/www/html/apps/settings/lib/Controller/CheckSetupController.php(132): OC\SetupCheck\SetupCheckManager->runAll() #11 /var/www/html/lib/private/AppFramework/Http/Dispatcher.php(205): OCA\Settings\Controller\CheckSetupController->check() #12 /var/www/html/lib/private/AppFramework/Http/Dispatcher.php(118): OC\AppFramework\Http\Dispatcher->executeController(Object(OCA\Settings\Controller\CheckSetupController), 'check') #13 /var/www/html/lib/private/AppFramework/App.php(153): OC\AppFramework\Http\Dispatcher->dispatch(Object(OCA\Settings\Controller\CheckSetupController), 'check') #14 /var/www/html/lib/private/Route/Router.php(321): OC\AppFramework\App::main('OCA\\Settings\\Co...', 'check', Object(OC\AppFramework\DependencyInjection\DIContainer), Array) #15 /var/www/html/lib/base.php(1155): OC\Route\Router->match('/settings/ajax/...') #16 /var/www/html/index.php(25): OC::handleRequest() #17 {main} Next Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user_facing_error_message' in 'SELECT' in /var/www/html/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:69 Stack trace: #0 /var/www/html/3rdparty/doctrine/dbal/src/Connection.php(1976): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #1 /var/www/html/3rdparty/doctrine/dbal/src/Connection.php(1918): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #2 /var/www/html/3rdparty/doctrine/dbal/src/Connection.php(1111): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'SELECT `id`, `l...', Array, Array) #3 /var/www/html/lib/private/DB/Connection.php(420): Doctrine\DBAL\Connection->executeQuery('SELECT `id`, `l...', Array, Array, NULL) #4 /var/www/html/lib/private/DB/ConnectionAdapter.php(50): OC\DB\Connection->executeQuery('SELECT `id`, `l...', Array, Array) #5 /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php(268): OC\DB\ConnectionAdapter->executeQuery('SELECT `id`, `l...', Array, Array) #6 /var/www/html/lib/public/AppFramework/Db/QBMapper.php(336): OC\DB\QueryBuilder\QueryBuilder->executeQuery() #7 /var/www/html/lib/private/TaskProcessing/Db/TaskMapper.php(181): OCP\AppFramework\Db\QBMapper->findEntities(Object(OC\DB\QueryBuilder\QueryBuilder)) #8 /var/www/html/lib/private/TaskProcessing/Manager.php(1333): OC\TaskProcessing\Db\TaskMapper->findTasks('', NULL, NULL, NULL, NULL, 1772775180, NULL) #9 /var/www/html/apps/settings/lib/SetupChecks/TaskProcessingPickupSpeed.php(44): OC\TaskProcessing\Manager->getTasks('', NULL, NULL, NULL, NULL, 1772775180) #10 /var/www/html/lib/private/SetupCheck/SetupCheckManager.php(34): OCA\Settings\SetupChecks\TaskProcessingPickupSpeed->run() #11 /var/www/html/apps/settings/lib/Controller/CheckSetupController.php(132): OC\SetupCheck\SetupCheckManager->runAll() #12 /var/www/html/lib/private/AppFramework/Http/Dispatcher.php(205): OCA\Settings\Controller\CheckSetupController->check() #13 /var/www/html/lib/private/AppFramework/Http/Dispatcher.php(118): OC\AppFramework\Http\Dispatcher->executeController(Object(OCA\Settings\Controller\CheckSetupController), 'check') #14 /var/www/html/lib/private/AppFramework/App.php(153): OC\AppFramework\Http\Dispatcher->dispatch(Object(OCA\Settings\Controller\CheckSetupController), 'check') #15 /var/www/html/lib/private/Route/Router.php(321): OC\AppFramework\App::main('OCA\\Settings\\Co...', 'check', Object(OC\AppFramework\DependencyInjection\DIContainer), Array) #16 /var/www/html/lib/base.php(1155): OC\Route\Router->match('/settings/ajax/...') #17 /var/www/html/index.php(25): OC::handleRequest() #18 {main} Next OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user_facing_error_message' in 'SELECT' in /var/www/html/lib/private/DB/Exceptions/DbalException.php:56 Stack trace: #0 /var/www/html/lib/private/DB/ConnectionAdapter.php(53): OC\DB\Exceptions\DbalException::wrap(Object(Doctrine\DBAL\Exception\InvalidFieldNameException), '', 'SELECT `id`, `l...') #1 /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php(268): OC\DB\ConnectionAdapter->executeQuery('SELECT `id`, `l...', Array, Array) #2 /var/www/html/lib/public/AppFramework/Db/QBMapper.php(336): OC\DB\QueryBuilder\QueryBuilder->executeQuery() #3 /var/www/html/lib/private/TaskProcessing/Db/TaskMapper.php(181): OCP\AppFramework\Db\QBMapper->findEntities(Object(OC\DB\QueryBuilder\QueryBuilder)) #4 /var/www/html/lib/private/TaskProcessing/Manager.php(1333): OC\TaskProcessing\Db\TaskMapper->findTasks('', NULL, NULL, NULL, NULL, 1772775180, NULL) #5 /var/www/html/apps/settings/lib/SetupChecks/TaskProcessingPickupSpeed.php(44): OC\TaskProcessing\Manager->getTasks('', NULL, NULL, NULL, NULL, 1772775180) #6 /var/www/html/lib/private/SetupCheck/SetupCheckManager.php(34): OCA\Settings\SetupChecks\TaskProcessingPickupSpeed->run() #7 /var/www/html/apps/settings/lib/Controller/CheckSetupController.php(132): OC\SetupCheck\SetupCheckManager->runAll() #8 /var/www/html/lib/private/AppFramework/Http/Dispatcher.php(205): OCA\Settings\Controller\CheckSetupController->check() #9 /var/www/html/lib/private/AppFramework/Http/Dispatcher.php(118): OC\AppFramework\Http\Dispatcher->executeController(Object(OCA\Settings\Controller\CheckSetupController), 'check') #10 /var/www/html/lib/private/AppFramework/App.php(153): OC\AppFramework\Http\Dispatcher->dispatch(Object(OCA\Settings\Controller\CheckSetupController), 'check') #11 /var/www/html/lib/private/Route/Router.php(321): OC\AppFramework\App::main('OCA\\Settings\\Co...', 'check', Object(OC\AppFramework\DependencyInjection\DIContainer), Array) #12 /var/www/html/lib/base.php(1155): OC\Route\Router->match('/settings/ajax/...') #13 /var/www/html/index.php(25): OC::handleRequest() #14 {main} Next OCP\TaskProcessing\Exception\Exception: There was a problem finding the tasks in /var/www/html/lib/private/TaskProcessing/Manager.php:1336 Stack trace: #0 /var/www/html/apps/settings/lib/SetupChecks/TaskProcessingPickupSpeed.php(44): OC\TaskProcessing\Manager->getTasks('', NULL, NULL, NULL, NULL, 1772775180) #1 /var/www/html/lib/private/SetupCheck/SetupCheckManager.php(34): OCA\Settings\SetupChecks\TaskProcessingPickupSpeed->run() #2 /var/www/html/apps/settings/lib/Controller/CheckSetupController.php(132): OC\SetupCheck\SetupCheckManager->runAll() #3 /var/www/html/lib/private/AppFramework/Http/Dispatcher.php(205): OCA\Settings\Controller\CheckSetupController->check() #4 /var/www/html/lib/private/AppFramework/Http/Dispatcher.php(118): OC\AppFramework\Http\Dispatcher->executeController(Object(OCA\Settings\Controller\CheckSetupController), 'check') #5 /var/www/html/lib/private/AppFramework/App.php(153): OC\AppFramework\Http\Dispatcher->dispatch(Object(OCA\Settings\Controller\CheckSetupController), 'check') #6 /var/www/html/lib/private/Route/Router.php(321): OC\AppFramework\App::main('OCA\\Settings\\Co...', 'check', Object(OC\AppFramework\DependencyInjection\DIContainer), Array) #7 /var/www/html/lib/base.php(1155): OC\Route\Router->match('/settings/ajax/...') #8 /var/www/html/index.php(25): OC::handleRequest() #9 {main}

Web Browser

If the problem is related to the Web interface, open your browser inspector Console and Network tabs while refreshing (reloading) and reproducing the problem. Provide any relevant output/errors here that appear.

PASTE

Web server / Reverse Proxy

The output of your Apache/nginx/system log in /var/log/____:

PASTE HERE

Configuration

Nextcloud

The output of occ config:list system or similar is best, but, if not possible, the contents of your config.php file from /path/to/nextcloud is fine (make sure to remove any identifiable information!):

{
    "system": {
        "htaccess.RewriteBase": "\/",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "apps_paths": [
            {
                "path": "\/var\/www\/html\/apps",
                "url": "\/apps",
                "writable": false
            },
            {
                "path": "\/var\/www\/html\/custom_apps",
                "url": "\/custom_apps",
                "writable": true
            }
        ],
        "default_phone_region": "CA",
        "maintenance_window_start": 100,
        "mail_smtptimeout": "30",
        "mail_smtpport": "465",
        "mail_smtpsecure": "ssl",
        "mail_smtpauthtype": "LOGIN",
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "forwarded_for_headers": [
            "HTTP_X_FORWARDED_FOR",
            "HTTP_X_FORWARDED"
        ],
        "overwriteprotocol": "https",
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "password": "***REMOVED SENSITIVE VALUE***",
            "port": 6379
        },
        "mail_smtpmode": "smtp",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "upgrade.disable-web": true,
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "localhost",
            "nextcloud.domain.org",
            "nextcloud.domain.lan"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "33.0.0.16",
        "overwrite.cli.url": "https:\/\/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_sendmailmode": "smtp",
        "mail_smtpauth": true,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "memories.exiftool": "\/var\/www\/html\/custom_apps\/memories\/bin-ext\/exiftool-amd64-glibc",
        "memories.vod.path": "\/var\/www\/html\/custom_apps\/memories\/bin-ext\/go-vod-amd64",
        "allow_local_remote_servers": true,
        "maintenance": false,
        "loglevel": 0,
        "twofactor_enforced": "false",
        "twofactor_enforced_groups": [],
        "twofactor_enforced_excluded_groups": [],
        "app_install_overwrite": []
    }
}







Enabled:
  - activity: 6.0.0-dev.0
  - admin_audit: 1.23.0
  - app_api: 33.0.0
  - bookmarks: 16.1.3
  - bruteforcesettings: 6.0.0-dev.0
  - calendar: 6.2.1
  - circles: 33.0.0
  - cloud_federation_api: 1.17.0
  - comments: 1.23.0
  - contacts: 8.4.0
  - contactsinteraction: 1.14.1
  - dashboard: 7.13.0
  - dav: 1.36.0
  - drawio: 4.2.3
  - federatedfilesharing: 1.23.0
  - federation: 1.23.0
  - files: 2.5.0
  - files_downloadlimit: 5.1.0-dev.0
  - files_pdfviewer: 6.0.0-dev.0
  - files_reminders: 1.6.0
  - files_sharing: 1.25.2
  - files_trashbin: 1.23.0
  - files_versions: 1.26.0
  - firstrunwizard: 6.0.0-dev.0
  - iframewidget: 0.9.3
  - impersonate: 4.0.0
  - integration_reddit: 2.1.1
  - integration_slack: 3.1.0
  - logreader: 6.0.0
  - lookup_server_connector: 1.21.0
  - mail: 5.7.2
  - nextcloud_announcements: 5.0.0
  - notes: 4.13.0
  - notifications: 6.0.0
  - oauth2: 1.21.0
  - onlyoffice: 10.0.0
  - password_policy: 5.0.0-dev.0
  - photos: 6.0.0-dev.0
  - privacy: 5.0.0-dev.0
  - profile: 1.2.0
  - provisioning_api: 1.23.0
  - recommendations: 6.0.0-dev.0
  - related_resources: 4.0.0-dev.0
  - serverinfo: 5.0.0-dev.0
  - settings: 1.16.0
  - sharebymail: 1.23.0
  - support: 5.0.0
  - systemtags: 1.23.0
  - tasks: 0.17.1
  - text: 7.0.0-dev.3
  - theming: 2.8.0
  - twofactor_backupcodes: 1.22.0
  - twofactor_totp: 15.0.0-dev.0
  - twofactor_webauthn: 2.6.0
  - updatenotification: 1.23.0
  - user_oidc: 8.6.0
  - user_status: 1.13.0
  - viewer: 6.0.0-dev.0
  - weather_status: 1.13.0
  - webhook_listeners: 1.5.0
  - whiteboard: 1.5.7
  - workflowengine: 2.15.0
Disabled:
  - encryption: 2.21.0
  - files_external: 1.25.1
  - memories: 7.8.2 (installed 7.8.2)
  - spreed: 23.0.1 (installed 22.0.9)
  - survey_client: 5.0.0-dev.0 (installed 2.0.0)
  - suspicious_login: 11.0.0-dev.0
  - terms_of_service: 4.6.1 (installed 4.6.1)
  - twofactor_nextcloud_notification: 7.0.0
  - user_ldap: 1.24.0

Apps

The output of occ app:list (if possible).

Tips for increasing the likelihood of a response

Use the preformatted text formatting option in the editor for all log entries and configuration output.
If screenshots are useful, feel free to include them.
- If possible, also include key error output in text form so it can be searched for.
Try to edit log output only minimally (if at all) so that it can be ran through analyzers / formatters by those trying to help you.

jtr · March 8, 2026, 6:38pm

The occ db:add-missing-columns is for adding optional columns. In your case, your missing an expected column. No idea why you’re missing it offhand. The db migration for it has been there since the first beta of 33.0.0.

What the proper steps would be to fix that ? Add the column manually in MariaDB?

Yeah probably the cleared approach. At least assuming you don’t seem to have other schema mismatches (doesn’t sound like it).

Heracles31 · March 12, 2026, 3:36am

Thanks for these infos. As you said that the proper fix would be to add it manually if it was the only missing columns, I re-did the diff between expected and export. Actually, there are more differences…

Only in the expected / missing in the export :

< - mp_sid_hash:

< - name: mp_sid_hash

< - columns:

< - single_id

< - mountpoint_hash

< - unique: true

< - primary: false

< - flags:

< - options:

< - password_expiration_time:

< - name: password_expiration_time

< - type: datetime

< - default

< - notnull: false

< - length: 0

< - precision: 10

< - scale: 0

< - fixed: false

< - unsigned: false

< - autoincrement: false

< - columnDefinition

< - comment

< - etag:

< - name: etag

< - type: string

< - default

< - notnull: false

< - length: 32

< - precision: 10

< - scale: 0

< - fixed: false

< - unsigned: false

< - autoincrement: false

< - columnDefinition

< - comment

< - user_facing_error_message:

< - name: user_facing_error_message

< - type: string

< - default

< - notnull: false

< - length: 4000

< - precision: 10

< - scale: 0

< - fixed: false

< - unsigned: false

< - autoincrement: false

< - columnDefinition

< - comment

And some different names for similar fields are :

< - mail_smime_certs_uid_idx:

< - name: mail_smime_certs_uid_idx

-–

> - mail_smime_certs_uid_email_idx:

> - name: mail_smime_certs_uid_email_idx

< - mail_trusted_senders_type:

< - name: mail_trusted_senders_type

-–

> - mail_trusted_senders_idx:

> - name: mail_trusted_senders_idx

Does that suggest a more problematic situation or if I just add the missing items and forget about the others ?