6.0.0-beta1
7/6/25

[#13291] Cannot add new contact
Summary Cannot add new contact
Queue Turba
Queue Version 4.2.0RC1
Type Bug
State Not A Bug
Priority 1. Low
Owners
Requester azurit (at) pobox (dot) sk
Created 06/25/2014 (4029 days ago)
Due
Updated 06/25/2014 (4029 days ago)
Assigned 06/25/2014 (4029 days ago)
Resolved 06/25/2014 (4029 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
06/25/2014 04:52:43 PM Michael Rubinsky State ⇒ Not A Bug
 
06/25/2014 04:48:32 PM azurit (at) pobox (dot) sk Comment #5 Reply to this comment
ok, i found this:
'category' => 'object_category',

in my backends.local.php (it wa copied from older version). i removed 
it and it's working now, thank you.
06/25/2014 04:48:04 PM Michael Rubinsky Comment #4 Reply to this comment
Yes, I'm sure. object_category only exists in the database migrations:

mrubinsk@coffee:turba (FRAMEWORK_5_2)$ grep -r object_category ./
.//migration/10_turba_upgrade_categoriestotags.php:            $sql = 
'SELECT object_uid, object_category, owner_id FROM turba_objects';
.//migration/10_turba_upgrade_categoriestotags.php:                     
     $row['object_category']
.//migration/10_turba_upgrade_categoriestotags.php:         
$this->removeColumn('turba_objects', 'object_category');
.//migration/10_turba_upgrade_categoriestotags.php:         
$this->addColumn('turba_objects', 'object_category', 'string', 
array('limit' => 80));
.//migration/10_turba_upgrade_categoriestotags.php:        $sql = 
'UPDATE turba_objects SET object_category = ? WHERE object_uid = ?';
.//migration/1_turba_base_tables.php:             
$t->column('object_category', 'string', array('limit' => 80));
06/25/2014 04:40:59 PM azurit (at) pobox (dot) sk Comment #3
New Attachment: turba.png Download
Reply to this comment
are you sure? see the attachment, i'm running newest unstable turba.
06/25/2014 04:36:40 PM Michael Rubinsky Comment #2
Priority ⇒ 1. Low
State ⇒ Feedback
Reply to this comment
That query doesn't exist in current Turba.
06/25/2014 03:45:42 PM azurit (at) pobox (dot) sk Comment #1
Priority ⇒ 3. High
Type ⇒ Bug
Summary ⇒ Cannot add new contact
Queue ⇒ Turba
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
Reply to this comment
This is in error log:

WARN: HORDE [turba] PHP ERROR: mysqli::real_escape_string() expects 
parameter 1 to be string, array given [pid 13081 on line 188 of 
"/usr/share/php/Horde/Db/Adapter/Mysqli.php"]

ERR: HORDE [turba] SQL QUERY FAILED: Unknown column 'object_category' 
in 'field list'
         INSERT INTO turba_objects (object_type, object_firstname,
           object_lastname, object_middlenames, object_nameprefix,
           object_namesuffix, object_alias, object_bday, object_spouse,
           object_anniversary, object_yomifirstname, object_yomilastname,
           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_otherstreet, object_otherpob, object_othercity,
           object_otherprovince, object_otherpostalcode, object_othercountry,
           object_tz, object_email, object_homephone, object_homephone2,
           object_workphone, object_workphone2, object_carphone,
           object_radiophone, object_companyphone, object_assistantphone,
           object_homefax, object_cellphone, object_fax, object_pager,
           object_imaddress, object_imaddress2, object_imaddress3, 
object_title,
           object_role, object_company, object_department, object_logo,
           object_assistant, object_manager, object_category, object_notes,
           object_url, object_freebusyurl, object_pgppublickey,
           object_smimepublickey, owner_id, object_uid, object_id) VALUES
           ('Object', 'it', 'test', '', '', '', '', NULL, '', NULL, '', '',
           NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '',
           '', '', '', 'test@example.com', '', '', '', '', '', '', '', 
'', '', '', '',
           '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', 
'', '', '',
           'test@example.com',
           'censored',
           'censored2') [pid 13081 on line 315 of 
"/usr/share/php/Horde/Db/Adapter/Mysqli.php"]

Saved Queries