editing task with no status fails
Closed, ResolvedPublic


Roundcube 1.2.3 + libcalendaring, kolab/calendar, kolab/tasklist (all from git 27.12.2016) using MySQL driver

  1. Create new task with no status (default ---)
  2. Click on this task in the list and choose "Edit"
  3. Click Save.
  4. "Failed to save data" message is displayed

Roundcube error log:

[01-Jan-2017 08:24:33 +0100]: <vnun16dl> DB Error: [1048] Column 'status' cannot be null (SQL Query: UPDATE tasks

SET   changed=now() , `title`='test5', `description`='', `flagged`='0', `complete`='0.00', `parent_id`=NULL, `date`=NULL, `time`=NULL, `startdate`=NULL, `starttime`=NULL, `alarms`=NULL, `recurrence`=NULL, `status`=NULL, `tags`='', `notify`=NULL
WHERE task_id='8'
AND   tasklist_id IN ('2')) in /pathtoroundcube/program/lib/Roundcube/rcube_db.php on line 539 (POST /?_task=tasks&_action=task)

So it seems that this edit script interprets default no status value ('') as NULL and then fails due to NOT NULL constrain on this column


Ticket Type

Event Timeline

rc-pl created this task.Jan 1 2017, 8:29 AM
rc-pl updated the task description. (Show Details)Jan 1 2017, 8:34 AM
pasik added a subscriber: pasik.Nov 25 2017, 2:33 PM
vanmeeuwen lowered the priority of this task from 60 to Normal.Mar 28 2019, 8:12 AM
machniak closed this task as Resolved.Sep 27 2019, 9:04 PM
machniak claimed this task.
machniak added a subscriber: machniak.

Fixed in b3b695b66d6d15.