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

[bugs at horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: http://bugs.horde.org/ticket/11681
------------------------------------------------------------------------------
  Ticket           | 11681
  Aktualisiert Von | andreas at sperbernest.de
  Zusammenfassung  | SyncML/Funambol cannot create new tasks
  Warteschlange    | Synchronization
  Version          | Git master
  Typ              | Bug
  Status           | Unconfirmed
  Priorität        | 2. Medium
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


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

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.