6.0.0-beta1
7/9/25

[#9929] Fails to store contacts
Summary Fails to store contacts
Queue Turba
Queue Version Git master
Type Bug
State Duplicate
Priority 1. Low
Owners
Requester themariostephan (at) gmail (dot) com
Created 04/18/2011 (5196 days ago)
Due
Updated 04/19/2011 (5195 days ago)
Assigned 04/19/2011 (5195 days ago)
Resolved 04/19/2011 (5195 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
04/19/2011 06:04:43 PM themariostephan (at) gmail (dot) com Comment #7 Reply to this comment
Indeed, duplicate of bug #9841.
Yes, after pulling 4661e5d6ef7209c02d15a0e37d8ed594a98eaeb3 we wiped 
the database and reinstalled. Saving contacts works now. Thanks!

But the "strlen() expects parameter 1" and 
"mysqli::real_escape_string()" log messages persist.
04/19/2011 05:21:35 PM Jan Schneider Comment #6
State ⇒ Duplicate
Reply to this comment
Indeed, duplicate of bug #9841.
04/19/2011 05:15:21 PM Michael Rubinsky Comment #5 Reply to this comment
Possibly related to bug: 9905 or bug: 9841
04/19/2011 05:06:28 PM themariostephan (at) gmail (dot) com Comment #4 Reply to this comment

Just noticed the double comma here:
     NULL, , '', '', '', '', '', 'mario@example.com',
     '20110419185324.pHjJT9EhkVZNrb4EUnVgvsA@webmail.rekursion.net',
We didn't change anything in turba/config/backends.php.
04/19/2011 05:00:34 PM themariostephan (at) gmail (dot) com Comment #3 Reply to this comment
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@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@example.com',
     '20110419185324.pHjJT9EhkVZNrb4EUnVgvsA@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@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"]

04/19/2011 03:52:25 PM Jan Schneider Comment #2
State ⇒ Feedback
Reply to this comment
We just installed horde from git. Turba should store it's contacts 
into a mysql database. However the following messages appear in the 
log file:
Doing *what*? At least the last error message should only happen when 
using Turba's API.
2011-04-19T00:36:42+02:00 WARN: HORDE [turba] PHP ERROR: strlen() 
expects parameter 1 to be string, object given [pid 16138 on line 
450 of 
"/var/www/webmail.rekursion.net/horde-git/framework/Form/lib/Horde/Form/Renderer.php"]
Did you change anything in config/backends.php? Are you using a custom 
backend?
2011-04-19T00:36:47+02:00 WARN: HORDE [turba] PHP ERROR: 
mysqli::real_escape_string() expects parameter 1 to be string, array 
given [pid 16132 on line 194 of 
"/var/www/webmail.rekursion.net/horde-git/framework/Db/lib/Horde/Db/Adapter/Mysqli.php"]
Does it make any difference if you the mysql driver instead of the 
mysqli driver?
2011-04-19T00:36:50+02:00 EMERG: HORDE [horde] Already Exists [pid 
16138 on line 709 of 
"/var/www/webmail.rekursion.net/horde-git/turba/lib/Api.php"]
04/18/2011 11:48:08 PM themariostephan (at) gmail (dot) com Comment #1
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ Fails to store contacts
Queue ⇒ Turba
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
Reply to this comment
Hello,
We just installed horde from git. Turba should store it's contacts 
into a mysql database. However the following messages appear in the 
log file:

2011-04-19T00:36:42+02:00 WARN: HORDE [turba] PHP ERROR: strlen() 
expects parameter 1 to be string, object given [pid 16138 on line 450 
of 
"/var/www/webmail.rekursion.net/horde-git/framework/Form/lib/Horde/Form/Renderer.php"]
2011-04-19T00:36:47+02:00 WARN: HORDE [turba] PHP ERROR: 
mysqli::real_escape_string() expects parameter 1 to be string, array 
given [pid 16132 on line 194 of 
"/var/www/webmail.rekursion.net/horde-git/framework/Db/lib/Horde/Db/Adapter/Mysqli.php"]
2011-04-19T00:36:50+02:00 EMERG: HORDE [horde] Already Exists [pid 
16138 on line 709 of 
"/var/www/webmail.rekursion.net/horde-git/turba/lib/Api.php"]

Saved Queries