WackoWiki

View source for Re: Error when creating a new user

[1] **Debugging**

If you wanna know what went wrong, ((/Dev/Testing turn on error reporting)) including setting ##DB_ERROR_MODE## to ##1## or ##2##.
%%
const DB_ERROR_MODE		= 1;
const PHP_ERROR_REPORTING	= 6;
%%
It will show you in the error_log or the Exception message what failed.

You can check if your ##user## table is OK and up to date. Maybe there is a missing default value or the like causing an SQL Strict mode issue.
  * ((source:master/src/setup/database/mysql.php setup/database/mysql.php))

What database and database version are you using, MySQL or MariaDB? 
You can check why the SQL query which should INSERT the new user is failing.

Can you register a new user via the ##registration## action?
If not it is probably the user table.

[2] **Upgrade to the latest version** (6.1.29 → 6.2.1)

Most SQL queries have been rewritten. No changes to the tables.