Users are not creating

[pmarcis]

Similarly to tasks, users cannot be created, because the data base table does not accept NULL for some parameters.

Query failed:
errorno=1364
error=Field 'username' doesn't have a default value
query=INSERT INTO user (name,registered,refuser) VALUES ('_NEW_',now(),0);

[pmarcis]

I changed the import command to the following:

$res = safe_query("INSERT INTO user (name,username,password,email,status,team,activated,notes,registered,refuser) VALUES ('".$userinfo["name"]."','".$userinfo["username"]."','".$userinfo["password"]."','".$userinfo["email"]."','".$userinfo["status"]."','".$userinfo["team"]."','".$userinfo["activated"]."','".$userinfo["notes"]."',now(),".$mysession["userid"].");");

Now it seems to work, but the tasks are not automatically saved. They have to be assigned after creation of the user.

[pmarcis]

This issue was due to MySQL 5.6 (starting from) having sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES as the default parameter. That means that non-strict behaviour was not allowed. However, I would encourage writing queries that are compliant with SQL table definitions nonetheless (makes support easier as well, because you won't have to troubleshoot issues that could have been avoided).