[Tickets #9929] Re: Fails to store contacts

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/9929
------------------------------------------------------------------------------
  Ticket             | 9929
  Updated By         | themariostephan at gmail.com
  Summary            | Fails to store contacts
  Queue              | Turba
  Version            | Git master
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


themariostephan at gmail.com (2011-04-19 17:00) wrote:

I tried to sync with my phone before, but all actions are taken in the  
web interface.

I click on "new contact" and get:
2011-04-19T18:51:06+02:00 WARN: HORDE [turba] PHP ERROR: strlen()  
expects parameter 1 to be string, object given [pid 3052 on line 450  
of  
"/var/www/webmail.rekursion.net/horde-git/framework/Form/lib/Horde/Form/Renderer.php"]

I enter some data and click "add":
2011-04-19T18:46:10+02:00 WARN: HORDE [turba] PHP ERROR:  
mysqli::real_escape_string() expects parameter 1 to be string, array  
given [pid 3052 on line 194 of  
"/var/www/webmail.rekursion.net/horde-git/framework/Db/lib/Horde/Db/Adapter/Mysqli.php"]

Changing to 'mysql pdo'  generates different messages:
2011-04-19T18:53:24+02:00 WARN: HORDE [turba] PHP ERROR: PDO::quote()  
expects parameter 1 to be string, array given [pid 3052 on line 165 of  
"/var/www/webmail.rekursion.net/horde-git/framework/Db/lib/Horde/Db/Adapter/Pdo/Base.php"]
2011-04-19T18:53:24+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 ' '', '', '',  
'', '', 'mario at example.com', '20110419185324.pHjJT9EhkVZNrb4EUnVgvsA'  
at line 1
   INSERT INTO turba_objects (object_type, object_firstname,
     object_lastname, object_middlenames, object_nameprefix,
     object_namesuffix, object_alias, object_bday, object_photo,
     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, object_homephone, object_workphone,
     object_cellphone, object_fax, object_pager, object_title, object_role,
     object_company, object_logo, object_category, object_notes,
     object_url, object_freebusyurl, object_pgppublickey,
     object_smimepublickey, owner_id, object_uid, object_id) VALUES
     ('Object', '', 'test', '', '', '', '', NULL, NULL, '', '', '', '', '',
     '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
     NULL, , '', '', '', '', '', 'mario at example.com',
     '20110419185324.pHjJT9EhkVZNrb4EUnVgvsA at webmail.rekursion.net',
     'XjfqRdEhkVZNrb4EUoFgvsA') [pid 3052 on line 792 of  
"/var/www/webmail.rekursion.net/horde-git/framework/Db/lib/Horde/Db/Adapter/Base.php"]
2011-04-19T18:53:24+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 ' '', '', '', '', '', 'mario at example.com',  
'20110419185324.pHjJT9EhkVZNrb4EUnVgvsA' at line 1 [pid 3052 on line  
382 of  
"/var/www/webmail.rekursion.net/horde-git/turba/lib/Driver/Sql.php"]
2011-04-19T18:53:24+02:00 WARN: HORDE [turba] PHP ERROR: strlen()  
expects parameter 1 to be string, object given [pid 3052 on line 450  
of  
"/var/www/webmail.rekursion.net/horde-git/framework/Form/lib/Horde/Form/Renderer.php"]