Summary | Cannot save contact |
Queue | Turba |
Queue Version | 3.0.1 |
Type | Bug |
State | Resolved |
Priority | 1. Low |
Owners | mrubinsk (at) horde (dot) org |
Requester | imp (at) lx-soft (dot) com |
Created | 04/27/2011 (5205 days ago) |
Due | |
Updated | 04/27/2011 (5205 days ago) |
Assigned | |
Resolved | 04/27/2011 (5205 days ago) |
Github Issue Link | |
Github Pull Request | |
Milestone | 3.0.2 |
Patch | No |
Assigned to Michael Rubinsky
State ⇒ Resolved
Milestone ⇒ 3.0.2
Priority ⇒ 1. Low
Patch ⇒ No
Milestone ⇒
Queue ⇒ Turba
Summary ⇒ Cannot save contact
Type ⇒ Bug
State ⇒ Unconfirmed
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