3 replies to this topic

[k1000o]

When creating tasks the completed date is mandatory, is this normal?

An error has occurred. Please click here to continue to the home page. If the error persists please contact your administrator.
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '' for column 'completeddatetime' at row 1

I would say that this field will be only completed automatically later hen the tasks is checked as completed, or manually modified later.

[Jason]

When creating tasks the completed date is mandatory, is this normal?

An error has occurred. Please click here to continue to the home page. If the error persists please contact your administrator.
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '' for column 'completeddatetime' at row 1

I would say that this field will be only completed automatically later hen the tasks is checked as completed, or manually modified later.

It is not mandatory, but my guess is you have something that needs to be changed with your my.ini to allow for null values for completeddatetime.

[k1000o]

You were right, after removing STRICT_TRANS_TABLES from sql-mode it works o.k

[Jason]

ok good. I believe this issue is resolved as something that is looked at during installation.