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):
32.0.2
- Operating system and version (e.g., Ubuntu 24.04):
22.04.05 LTS
- Web server and version (e.g, Apache 2.4.25):
2.4.52
- Reverse proxy and version _(e.g. nginx 1.27.2)
No reverse proxy
- PHP version (e.g, 8.3):
8.3.29
- Is this the first time you’ve seen this error? (Yes / No):
No
- When did this problem seem to first start?
After Upgrate to version 32
- Installation method (e.g. AlO, NCP, Bare Metal/Archive, etc.)
By script
- Are you using CloudfIare, mod_security, or similar? (Yes / No)
No
Summary of the issue you are facing:
[…]
Steps to replicate it (hint: details matter!):
-
When trying to create a new user I get an error as below
-
From OCC the same error
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.
","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36 Edg/143.0.0.0","version":"32.0.2.2","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":" An exception occurred while executing a query: SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1","Code":1136,"Trace":[{"file":"/var/www/html/lib/private/DB/ConnectionAd apter.php","line":69,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::"},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":308,"function":"executeStatement","class":"OC\\DB\\ConnectionAda pter","type":"->"},{"file":"/var/www/html/lib/private/User/Database.php","line":106,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional .php","line":45,"function":"OC\\User\\{closure}","class":"OC\\User\\Database","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Database.php","line":97,"function":"atomic","class":"OC\ \User\\Database","type":"->"},{"file":"/var/www/html/lib/private/User/Manager.php","line":435,"function":"createUser","class":"OC\\User\\Database","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/ private/User/Manager.php","line":403,"function":"createUserFromBackend","class":"OC\\User\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/provisioning_api/lib/Controller/UsersControlle r.php","line":547,"function":"createUser","class":"OC\\User\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":204,"function":"addUser","cl ass":"OCA\\Provisioning_API\\Controller\\UsersController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":118,"function":"executeController","clas s":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":153,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/html/lib/private/ Route/Router.php","line":321,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/html/ocs/v1.php","line":61,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/html/ocs/v2.php","lin e":8,"args":["/var/www/html/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/html/lib/private/DB/Exceptions/DbalException.php","Line":56,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An excepti on occurred while executing a query: SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1","Code":1136,"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":1218,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/html/3 rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/html/lib/private/DB/Connection.php","line":467,"functio n":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","ty pe":"->"},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":308,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/lib/private/User/Database.php","line":106,"f unction":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":45,"function":"OC\\User\\{closure}","class":"OC\\User\\Database","type":" ->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Database.php","line":97,"function":"atomic","class":"OC\\User\\Database","type":"->"},{"file":"/var/www/html/lib/private/User/Manager.php","li ne":435,"function":"createUser","class":"OC\\User\\Database","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Manager.php","line":403,"function":"createUserFromBackend","class":"OC\\U ser\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/provisioning_api/lib/Controller/UsersController.php","line":547,"function":"createUser","class":"OC\\User\\Manager","type":"->","arg s":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":204,"function":"addUser","class":"OCA\\Provisioning_API\\Controller\\UsersController","type":"->","args":["*** sen sitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":118,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/html/lib/privat e/AppFramework/App.php","line":153,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/html/lib/private/Route/Router.php","line":321,"function":"main","class":"OC\\AppFramework\\App","type": "::"},{"file":"/var/www/html/ocs/v1.php","line":61,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/html/ocs/v2.php","line":8,"args":["/var/www/html/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/ html/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":129,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column c ount doesn't match value count at row 1","Code":1136,"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":1212,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaCon nection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/html/lib/private/DB/Connection.php","line":467,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\ \PrimaryReadReplicaConnection","type":"->"},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/lib/private/DB/QueryBuilde r/QueryBuilder.php","line":308,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/lib/private/User/Database.php","line":106,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\ QueryBuilder","type":"->"},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":45,"function":"OC\\User\\{closure}","class":"OC\\User\\Database","type":"->","args":["*** sensitive parameters replaced ***"]},{"fil e":"/var/www/html/lib/private/User/Database.php","line":97,"function":"atomic","class":"OC\\User\\Database","type":"->"},{"file":"/var/www/html/lib/private/User/Manager.php","line":435,"function":"createUser","class":"OC\\User\\Database ","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Manager.php","line":403,"function":"createUserFromBackend","class":"OC\\User\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/provisioning_api/lib/Controller/UsersController.php","line":547,"function":"createUser","class":"OC\\User\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var /www/html/lib/private/AppFramework/Http/Dispatcher.php","line":204,"function":"addUser","class":"OCA\\Provisioning_API\\Controller\\UsersController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/li b/private/AppFramework/Http/Dispatcher.php","line":118,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":153,"function":"dispatch","c lass":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/html/lib/private/Route/Router.php","line":321,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/html/ocs/v1.php","line":61,"functio n":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/html/ocs/v2.php","line":8,"args":["/var/www/html/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php"," Line":24,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1","Code":"21S01","Trace":[{"file":"/var/www/html/3rdparty/doct rine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1212,"function":"execute","class":"Doctrine\\DBAL\\Driv er\\PDO\\Statement","type":"->"},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/ww w/html/lib/private/DB/Connection.php","line":467,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":67,"func tion":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":308,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/ var/www/html/lib/private/User/Database.php","line":106,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":45,"function":"O C\\User\\{closure}","class":"OC\\User\\Database","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Database.php","line":97,"function":"atomic","class":"OC\\User\\Database","type":"->"} ,{"file":"/var/www/html/lib/private/User/Manager.php","line":435,"function":"createUser","class":"OC\\User\\Database","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Manager.php","li ne":403,"function":"createUserFromBackend","class":"OC\\User\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/provisioning_api/lib/Controller/UsersController.php","line":547,"function": "createUser","class":"OC\\User\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":204,"function":"addUser","class":"OCA\\Provisioning_API\\ Controller\\UsersController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":118,"function":"executeController","class":"OC\\AppFramework\\Http\\D ispatcher","type":"->"},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":153,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/html/lib/private/Route/Router.php","line":321, "function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/html/ocs/v1.php","line":61,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/html/ocs/v2.php","line":8,"args":["/var/www/html/o cs/v1.php"],"function":"require_once"}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}}},"message":"Failed addUser attempt with exception.","exception":{"query":"INSERT INTO *PREFIX*users (uid , password, uid_lower) VALUES(:dcValue1, :dcValue2, :dcValue3)"},"CustomMessage":"Failed addUser attempt with exception."}}
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.
api.js:54
POST https://xxxxx.xxxxxx.xxx/ocs/v2.php/cloud/users 400 (Bad request)
post @ api.js:54
(anonymous) @ users.js:716
Promise.then
addUser @ users.js:715
createUser @ NewUserDialog.vue:249
submit @ NewUserDialog.vue:1
[NEW] Explain Console errors by using Copilot in Edge: click
to explain an error. Learn more
Don't show again
index.js:23
{…}
{userid: 'filstr', error: r}
error
:
r {message: 'Request failed with status code 400', name: 'AxiosError', code: 'ERR_BAD_REQUEST', config: {…}, request: XMLHttpRequest, …}
userid
:
"filstr"
[[Prototype]]
:
Object
Web server / Reverse Proxy
The output of your Apache/nginx/system log in /var/log/____:
No reverse proxy
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!):
<?php
$CONFIG = array (
'instanceid' => 'oc9zacx3u551lshxw',
'passwordsalt' => 'R4DTXIn232w3n3e5WpHlbdnaw/bwbgKxEtp',
'secret' => 'by+luP1J2Y3J5ipTnYu23Hix4vXJLGF6Gao+U8LSgya7d+BNVYoX',
'trusted_domains' =>
array (
0 => 'xxxxxx.xxxxxxx.xxx',
1 => 'xxxxxx.xxxxxxx.xxx',
),
'datadirectory' => '/var/www/html/data',
'dbtype' => 'mysql',
'version' => '32.0.2.2',
'overwrite.cli.url' => 'https://xxxxxxx.xxxxxx.xxxx',
'dbname' => 'cloud',
'dbhost' => 'localhost',
'dbport' => '',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => 'cloud-user',
'dbpassword' => 'bGWF45XuatOciAs3YZ0KgnUH',
'installed' => true,
'mail_from_address' => 'cloud',
'mail_smtpmode' => 'smtp',
'mail_sendmailmode' => 'smtp',
'mail_domain' => 'xxxxxxxx.xxx',
'mail_smtphost' => 'smtp.xxxxx.xxxxx',
'mail_smtpport' => '465',
'mail_smtpauth' => 1,
'mail_smtpname' => 'xxxxx@xxxxxx.xxx',
'mail_smtppassword' => 'xxxxxxxxxxx',
'mail_smtpsecure' => 'ssl',
'app_install_overwrite' =>
array (
0 => 'integration_jira',
1 => 'file_upload_notification',
2 => 'admin_notifications',
3 => 'twofactor_email',
),
'skeletondirectory' => '',
'default_phone_region' => 'PL',
'default_locale' => 'pl_PL',
'force_locale' => 'pl_PL',
'default_language' => 'pl',
'force_language' => 'pl',
'maintenance' => false,
'loglevel' => 2,
'maintenance_window_start' => 1,
'filelocking.enabled' => true,
'defaultapp' => '',
'twofactor_enforced_groups' =>
array (
),
'twofactor_enforced_excluded_groups' =>
array (
),
'auto_logout' => true,
'remember_login_cookie_lifetime' => 1296000,
'session_lifetime' => 3600,
'session_keepalive' => false,
'ldapProviderFactory' => 'OCA\\User_LDAP\\LDAPProviderFactory',
'warn_on_low_disk_space_threshold' => 0.02,
);
Apps
The output of occ app:list (if possible).
Enabled:
- admin_audit: 1.22.0
- announcementcenter: 7.2.2
- cloud_federation_api: 1.16.0
- dashboard: 7.12.0
- dav: 1.34.2
- encryption: 2.20.0
- external: 7.0.0
- federatedfilesharing: 1.22.0
- federation: 1.22.0
- files: 2.4.0
- files_accesscontrol: 3.0.2
- files_downloadlimit: 5.0.0-dev.0
- files_external: 1.24.0
- files_pdfviewer: 5.0.0-dev.0
- files_reminders: 1.5.0
- files_retention: 3.0.0
- files_sharing: 1.24.1
- files_trashbin: 1.22.0
- group_default_quota: 0.1.13
- groupfolders: 20.1.4
- groupquota: 0.2.3
- logreader: 5.0.0-dev.0
- lookup_server_connector: 1.20.0
- nextcloud_announcements: 4.0.0-dev.0
- notifications: 5.0.0-dev.0
- oauth2: 1.20.0
- password_policy: 4.0.0-dev.0
- privacy: 4.0.0-dev.0
- profile: 1.1.0
- provisioning_api: 1.22.0
- quota_warning: 1.22.0
- related_resources: 3.0.0-dev.0
- serverinfo: 4.0.0-dev.0
- settings: 1.15.1
- sharebymail: 1.22.0
- support: 4.0.0-dev.0
- survey_client: 4.0.0-dev.0
- systemtags: 1.22.0
- text: 6.0.1
- theming: 2.7.0
- theming_customcss: 1.19.0
- twofactor_backupcodes: 1.21.0
- twofactor_email: 2.8.3
- updatenotification: 1.22.0
- user_ldap: 1.23.0
- user_status: 1.12.0
- viewer: 5.0.0-dev.0
- webhook_listeners: 1.3.0
- workflowengine: 2.14.0
Disabled:
- activity: 5.0.0-dev.0 (installed 5.0.0-dev.0)
- admin_notifications: 1.0.2 (installed 1.0.2)
- app_api: 32.0.0 (installed 32.0.0)
- approval: 2.1.0 (installed 2.1.0)
- bruteforcesettings: 5.0.0-dev.0 (installed 3.0.0)
- circles: 32.0.0 (installed 30.0.0)
- collectives: 2.16.1 (installed 2.16.1)
- comments: 1.22.0 (installed 1.20.1)
- contactsinteraction: 1.13.1 (installed 1.11.0)
- files_automatedtagging: 1.20.0 (installed 1.20.0)
- files_rightclick: 0.15.1 (installed 1.6.0)
- files_scripts: 4.1.0 (installed 4.1.0)
- files_versions: 1.25.0 (installed 1.23.0)
- firstrunwizard: 5.0.0-dev.0 (installed 3.0.0)
- guests: 4.1.0 (installed 4.1.0)
- integration_jira: 1.2.1 (installed 1.2.1)
- mail: 4.1.2 (installed 4.1.2)
- permissions_overwrite: 0.1.15 (installed 0.1.15)
- photos: 5.0.0-dev.1 (installed 2.2.0)
- polls: 7.4.2 (installed 7.4.2)
- recommendations: 5.0.0-dev.0 (installed 3.0.0)
- suspicious_login: 10.0.0-dev.0 (installed 8.0.0)
- twofactor_admin: 4.7.1 (installed 4.7.1)
- twofactor_duo: 0.0.2 (installed 0.0.2)
- twofactor_nextcloud_notification: 6.0.0-dev.0
- twofactor_reminder: 1.1.0 (installed 1.1.0)
- twofactor_totp: 14.0.0 (installed 13.0.0-dev.0)
- weather_status: 1.12.0 (installed 1.10.0)
- welcome: 1.2.1 (installed 1.2.1)
Tips for increasing the likelihood of a response
- Use the
preformatted textformatting 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.
mysql> use cloud;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show columns from oc_users;
+-------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| uid | varchar(64) | NO | PRI | NULL | |
| displayname | varchar(64) | YES | | NULL | |
| password | varchar(255) | NO | | | |
| uid_lower | varchar(64) | YES | MUL | | |
+-------------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)