Tasks are not creating

[pmarcis]

Hi,

You have in your code:

$res = safe_query("INSERT INTO task (name,owner) VALUES ('_NEW_','".$mysession['userid']."');");

The task table, however, requires NOT NULL values for descr, instructions, ranges. Also, the task name here is a default one - _NEW_.

It seems that tasks cannot be created.

I get an exception from MySQL:

Query failed:
errorno=1364
error=Field 'descr' doesn't have a default value
query=INSERT INTO task (name,owner) VALUES ('_NEW_','0');

[pmarcis]

I changed the line to:

$res = safe_query("INSERT INTO task (name,type,descr,instructions,ranges,owner) VALUES ('".$taskinfo["name"]."','".$taskinfo["type"]."','".$taskinfo["descr"]."','".$taskinfo["instructions"]."','".$taskinfo["ranges"]."','".$mysession['userid']."');");

Seems to be working, but I am not sure whether it is supposed to work with these parameters.

[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).