Tickets :: Comment on [#9994] Cannot save contact

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

Saved Queries