Created client doesn't have user login

Hi,
This is my second ISPConfig install, it will be based on multiple Ubuntu 18.04 servers each with dedicated function, database, web/file, email, dns however I ran into an issue I have installed the database server (no ispconfig there just perconadb) and web server ( nginx + php fpm + ispconfig 3.1.13 ) I can login with root and everything is fine that far. the problem appears when i create a client, the client account is created in the panel and in the db "client" table, however there is no user created for that client, nothing in CP Users on the panel or in the DB "sys_user" table, I have checked all the logs in /var/log/ispconfig and there is no errors.

Please assist, I've lost many hours with no idea what to look for.

 

Strange, I discovered the percona mysql server was failing silently on adding into sys_user
Changing in client_edit.php
$sql = "INSERT INTO sys_user (username,passwort,modules,startmodule,app_theme,typ,active,language,groups,default_group,client_id)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
to
$sql = "INSERT INTO sys_user (`username`,`passwort`,`modules`,`startmodule`,`app_theme`,`typ`,`active`,`language`,`groups`,`default_group`,`client_id`)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

Seems to resolve the issue.

 

Just a FYI for anyone having issues... I've ran into additional problems with isp config and had to modify a lot of php code, they are all related with the database, seems ispconfig is not yet ready to handle mysql 8.0.13.