Page MenuHomekolab.org

editing task with no status fails
Closed, ResolvedPublic

Description

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

Details

Ticket Type
Task

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.Fri, Sep 27, 9:04 PM
machniak claimed this task.
machniak added a subscriber: machniak.

Fixed in b3b695b66d6d15.