[Tickets #9994] Cannot save contact

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/9994
------------------------------------------------------------------------------
  Ticket             | 9994
  Created By         | imp at lx-soft.com
  Summary            | Cannot save contact
  Queue              | Turba
  Version            | 3.0.1
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


imp at lx-soft.com (2011-04-27 07:01) wrote:

After editing an existing contact (DB backend), I am not able to save  
changes. Turba reports following error message:

- There was an error saving the contact. Contact your system  
administrator for further help.

It seems it's related to "horde categories":
- If I choose "New Category" instead of an existing category name, the  
saving is successful.

If I look at turba/lib/Driver/Sql.php _save() function, the error may  
be related to this hash:

$attributes['object_category'] => Array ( [new] => , [value] => WORK) ;

This attribute is an array and not a single string.

Related log messages:
2011-04-27T08:48:28+02:00 WARN: HORDE [turba] PHP ERROR: PDO::quote()  
expects parameter 1 to be string, array given [pid 25379 on line 165  
of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
2011-04-27T08:48:28+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 = 'vink', object_type = 'Object',
           object_members = NULL, object_uid =
           '20110421154437.lAhNZY6rGWdNsDTFogwmVDA at horde.mon-net.org',
           object_firstname = 'Vincent', object_lastname = '*****',
           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 = 'Vincent.Xxxxxx at xxxx.xxx', 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 =
           '_1r0FY6rGWdNsDTFowZWVDA' [pid 25379 on line 792 of  
"/usr/share/php/Horde/Db/Adapter/Base.php"]
2011-04-27T08:48:28+02: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 25379 on  
line 503 of "/var/www/turba/lib/Driver/Sql.php"]

Regards,

Vincent