[Tickets #9955] Editing a Contact in a SQL-Addressbook fails if no category is set

[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/9955
------------------------------------------------------------------------------
  Ticket           | 9955
  Erstellt Von     | florian at brandner.net
  Zusammenfassung  | Editing a Contact in a SQL-Addressbook fails if no
                   | category is set
  Warteschlange    | Turba
  Version          | 3.0.1
  Typ              | Bug
  Status           | Unconfirmed
  Priorität        | 2. Medium
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


florian at brandner.net (2011-04-22 14:36) hat geschrieben:

When trying to save a contact in a SQL-Addressbook without setting a  
Category, an error occurs and the contact is not saved.

Output of the Horde.log:

2011-04-22T16:31:18+02:00 ERR: HORDE [turba] SQL QUERY FAILED:  
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an  
error in your SQL syntax; check the manual that corresponds to your  
MySQL server version for the right syntax to use near ' object_notes =  
'', object_url = '', object_freebusyurl = '', object_pgppublicke' at  
line 1
	UPDATE turba_objects SET owner_id = 'flo', object_type = 'Object',
	  object_members = NULL, object_uid =
	  '<uid>@<domain>',
	  object_firstname = 'Vorname', object_lastname = 'Nachname',
	  object_middlenames = '', object_nameprefix = '', object_namesuffix =
	  '', object_alias = '', object_bday = '2000-01-01', object_photo =
	  NULL, object_phototype = NULL, object_homestreet = '', object_homepob
	  = '', object_homecity = '', object_homeprovince = '',
	  object_homepostalcode = '', object_homecountry = '', object_workstreet
	  = '', object_workpob = '', object_workcity = '', object_workprovince =
	  '', object_workpostalcode = '', object_workcountry = '', object_tz =
	  '', object_email = 'name at domain.de', object_homephone =
	  '+49-1234-5678', object_workphone = '+49-1234-5678',
	  object_cellphone = '', object_fax = '', object_pager = '',
	  object_title = '', object_role = '', object_company = 'Blah
	  AG', object_logo = NULL, object_logotype = NULL, object_category = ,
	  object_notes = '', object_url = '', object_freebusyurl = '',
	  object_pgppublickey = '', object_smimepublickey = '' WHERE object_id =
	  'oid' [pid 9898 on line 792 of "/usr/share/php/Horde/Db/Adapter/Base.php"]

Behind "object_category = " should be '' or NULL.

Specifying a category in the contact before saving works.