[Tickets #10018] There was an error saving the contact.

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/10018
------------------------------------------------------------------------------
  Ticket             | 10018
  Created By         | steven at tkfast.com
  Summary            | There was an error saving the contact.
  Queue              | Turba
  Version            | Git master
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
+New Attachment     | example.txt
------------------------------------------------------------------------------


steven at tkfast.com (2011-04-30 21:56) wrote:

When you try to update an existing contact you have to select a  
Category on the Other tab and if you select Unfiled or any Existing  
Category it will give you the error listed below.  If you add a new  
category it will update the contact that is the only way to update a  
contact from the turba.

Turba 3.0.1
http://webmail.xxxx.com/turba/edit.php

2011-04-30T16:39:51-05:00 DEBUG: HORDE [turba] SQL
         UPDATE turba_objects SET owner_id = 'steven at ccccc.com', object_type =
           'Object', object_members = NULL, object_uid =
           '20100122083516.25675wai0ew9hgo4 at webmail.xxxxxx.com',  
object_firstname
           = 'Eric', object_lastname = 'Bade', object_middlenames = '',
           object_nameprefix = '', object_namesuffix = '', object_alias = '',
           object_bday = NULL, 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 =
           'ebade at xxxxxx.com', object_homephone = '', object_workphone = '',
           object_cellphone = '', object_fax = '', object_pager = '',
           object_title = '', object_role = '', object_company = '',  
object_logo
           = NULL, object_logotype = NULL, object_category = ,  
object_notes = '',
           object_url = '', object_freebusyurl = '', object_pgppublickey = '',
           object_smimepublickey = '' WHERE object_id =
           '243722f9a73ec47948936bca2f77d1ac' [pid 2662 on line 783 of  
"/usr/share/php/Horde/Db/Adapter/Base.php"]
2011-04-30T16:39:51-05:00 ERR: HORDE [turba] 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 [pid 2662 on  
line 505 of "/data/webmail/horde4/turba/lib/Driver/Sql.php"]
2011-04-30T16:39:51-05:00 DEBUG: 1. Turba_Form_EditContact->execute()  
/data/webmail/horde4/turba/edit.php:78
2. Turba_Object->store()  
/data/webmail/horde4/turba/lib/Form/EditContact.php:74
3. Turba_Driver->save() /data/webmail/horde4/turba/lib/Object.php:470
4. Turba_Driver_Share->_save() /data/webmail/horde4/turba/lib/Driver.php:913
5. Turba_Driver_Sql->_save()  
/data/webmail/horde4/turba/lib/Driver/Share.php:212

2011-04-30T16:39:51-05:00 DEBUG: HORDE [turba] There was an error  
saving the contact. Contact your system administrator for further  
help. [pid 2662 on line 27 of  
"/usr/share/php/Horde/Core/Notification/Handler/Decorator/Hordelog.php"]
2011-04-30T16:39:51-05:00 DEBUG: HORDE [turba] SQL  (0.0004s)