6.0.0-beta1
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
10/20/25
H
istory
A
ttachments
C
omment
W
atch
Download
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
N
ew Ticket
M
y Tickets
S
earch
Q
uery Builder
R
eports
Saved Queries
Open Bugs
Bugs waiting for Feedback
Open Bugs in Releases
Open Enhancements
Enhancements waiting for Feedback
Bugs with Patches
Enhancements with Patches
Release Showstoppers
Stalled Tickets
New Tickets
Horde 5 Showstoppers