[Tickets #13423] Re: Can't add new contact

[noreply at bugs.horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: http://bugs.horde.org/ticket/13423
------------------------------------------------------------------------------
  Ticket           | 13423
  Aktualisiert Von | rainer at rainer-nerb.de
  Zusammenfassung  | Can't add new contact
  Warteschlange    | Turba
  Version          | 4.2.1
  Typ              | Bug
  Status           | Feedback
  Priorität        | 2. Medium
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


rainer at rainer-nerb.de (2014-08-07 15:35) hat geschrieben:

> 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 at www.it-nerb.org',#012#011   
'LDNk3sr-HywmiF0vW212rQ8') [pid 1852 on line 204 of "/usr/sh