6.0.0-beta1
10/17/25

[#13423] Can't add new contact
Summary Can't add new contact
Queue Turba
Queue Version 4.2.1
Type Bug
State Duplicate
Priority 2. Medium
Owners
Requester rainer (at) rainer-nerb (dot) de
Created 08/07/2014 (4089 days ago)
Due
Updated 08/20/2014 (4076 days ago)
Assigned 08/07/2014 (4089 days ago)
Resolved 08/20/2014 (4076 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
08/20/2014 04:49:11 PM Jan Schneider Comment #6
State ⇒ Duplicate
Reply to this comment
Duplicate of bug #13291
08/12/2014 04:42:41 PM rainer (at) rainer-nerb (dot) de Comment #5
New Attachment: horde.log Download
Reply to this comment
see attached file, hope it's sufficient
08/11/2014 05:03:02 PM Jan Schneider Comment #4 Reply to this comment
I cannot locate the syntax error from that error message in the query 
you posted. Beside that, we would need the backtrace from the error too.
08/07/2014 03:35:36 PM rainer (at) rainer-nerb (dot) de Comment #3 Reply to this comment
We would need a more detailed log file, showing the actual query 
being performed. Try setting the log level to debug and try again.
OK, here's the query:
HORDE: [turba] SQL QUERY FAILED: SQLSTATE[42601]: Syntax error: 7 
FEHLER:  Syntaxfehler bei »,«#012ZEILE 1: ...'', '', '', '', '', '', 
'', '', '', NULL, '', '', , '', '', ...#012                             
                                   ^  #012#011INSERT INTO 
turba_objects (object_type, object_firstname,#012#011   
object_lastname, object_middlenames, object_nameprefix,#012#011   
object_namesuffix, object_alias, object_bday, object_spouse,#012#011   
object_anniversary, object_yomifirstname, object_yomilastname,#012#011 
  object_photo, object_homestreet, object_homepob, 
object_homecity,#012#011  object_homeprovince, object_homepostalcode, 
object_homecountry,#012#011  object_workstreet, object_workpob, 
object_workcity,#012#011  object_workprovince, object_workpostalcode, 
object_workcountry,#012#011  object_otherstreet, object_otherpob, 
object_othercity,#012#011  object_otherprovince, 
object_otherpostalcode, object_othercountry,#012#011  object_tz, 
object_email, object_homephone, object_homephone2,#012#011   
object_workphone, object_workphone2, object_carphone,#012#011   
object_radiophone, object_companyphone, object_assistantphone,#012#011 
  object_homefax, object_cellphone, object_fax, object_pager,#012#011   
object_imaddress, object_imaddress2, object_imaddress3, 
object_title,#012#011  object_role, object_company, object_department, 
object_logo,#012#011  object_assistant, object_manager, 
object_category, object_notes,#012#011  object_url, 
object_freebusyurl, object_pgppublickey,#012#011   
object_smimepublickey, owner_id, object_uid, object_id) VALUES#012#011 
  ('Object', '', 'Last Name', '', '', '', '', NULL, '', NULL, '', 
'',#012#011  NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '',#012#011  '', '', '', '', '', '', '12345', '', '', '', '', 
'', '', '', '', '',#012#011  '', '', '', '', '', '', '', NULL, '', '', 
, '', '', '', '', '',#012#011  'rainer', 
'20140807153156.DiXBDP5o8ktBiKkSJ7_BIQ1@www.it-nerb.org',#012#011   
'LDNk3sr-HywmiF0vW212rQ8') [pid 1852 on line 204 of "/usr/sh


08/07/2014 03:12:15 PM Michael Rubinsky Comment #2
State ⇒ Feedback
Reply to this comment
We would need a more detailed log file, showing the actual query being 
performed. Try setting the log level to debug and try again.
08/07/2014 09:09:06 AM rainer (at) rainer-nerb (dot) de Comment #1
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Can't add new contact
Queue ⇒ Turba
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
Reply to this comment
when trying to create a new contact, I receive an error-message that 
there was a server-error.

messages in log-file:
horde HORDE: [turba] PHP ERROR: PDO::quote() expects parameter 1 to be 
string, array given [pid 1332 on line 308 of 
"/usr/share/pear/Horde/Db/Adapter/Pdo/Base.php"]
horde HORDE: [turba] SQL QUERY FAILED: SQLSTATE[42601]: Syntax error: 
7 FEHLER:  Syntaxfehler bei »,«#012LINE 1: ...'', '', '', '', '', '', 
'', '', '', NULL, '', '', , '', '', ...#012

Saved Queries