[Tickets #11681] SyncML/Funambol cannot create new tasks

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/11681
------------------------------------------------------------------------------
  Ticket             | 11681
  Created By         | horde at luetgens.org
  Summary            | SyncML/Funambol cannot create new tasks
  Queue              | Synchronization
  Version            | Git master
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


horde at luetgens.org (2012-11-09 16:17) wrote:

New tasks should be uploaded to horde/nag upon synchronization. They  
are not. This is the culprit:

2012-11-09T16:40:18+01:00 DEBUG: HORDE [nag] SQL QUERY FAILED: Column  
'task_creator' cannot be null
         INSERT INTO nag_tasks (task_owner, task_creator, task_assignee,
           task_id, task_name, task_uid, task_desc, task_start, task_due,
           task_priority, task_estimate, task_completed, task_alarm,
           task_alarm_methods, task_private, task_parent, task_recurtype,
           task_recurinterval, task_recurenddate, task_recurcount,
           task_recurdays, task_exceptions, task_completions) VALUES
           ('dBETGU6cUytPafXKz0fFUPA', NULL, NULL, 'b45xI06cUytQnSPiNvv35BA',
           'Neue Aufgabe',
           'xxxxx',
           NULL, 0, 0, 0, '0.00', 0, 0, 'N;', 0, '', 0, NULL, NULL, NULL, NULL,
           NULL, NULL) [pid 32321 on line 806 of  
"/usr/share/php/Horde/Db/Adapter/Base.php"]


Could be either a nag problem (task creator needs to allow for NULL  
values) or a sync problem (input from clients has to be parsed for  
NULL values).

This problem appeared after updating from horde 4.x to horde 5.x.

I used Thunderbird / Lightning / Funambol for this.