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

* Your Email Address
* Spam protection	Enter the letters below: . ..___ __ .___. . \|_/ [__ / `[__ \| \| \| \[___\__.[___\|__\|
Comment	> 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@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.
Attachment
Watch this ticket

Saved Queries