[horde] Database trouble after update to 5.2.1

steffo76 at gmx.de steffo76 at gmx.de
Tue Sep 2 13:19:50 UTC 2014


Hi there,

after updating my horde installation to 5.2.1 I'm having a database problem concerning turba. After the update I'm experiencing some trouble with turba contact lists- trying to open them leads to a more or less blank screen and an error in the log saying

2014-09-02T14:55:49+02:00 ERR: HORDE [turba] SQL QUERY FAILED: Unknown column 'object_category' in 'field list'
        SELECT object_id, owner_id, object_type, object_members, object_uid,
          object_firstname, object_lastname, object_middlenames,
          object_nameprefix, object_namesuffix, object_alias, object_bday,
          object_anniversary, object_spouse, object_photo, object_phototype,
          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_department, object_tz, object_email, object_homephone,
          object_homefax, object_workphone, object_cellphone,
          object_assistantphone, object_fax, object_pager, object_title,
          object_role, object_company, object_logo, object_logotype,
          object_category, object_notes, object_url, object_freebusyurl,
          object_pgppublickey, object_smimepublickey, object_imaddress,
          object_imaddress2, object_imaddress3 FROM turba_objects WHERE
          object_id IN ('013a7ce35400940be4dffx82242895dc') AND owner_id =
          'blablabla' [pid 2419 on line 258 of "/usr/share/pear/Horde/Db/Adapter/Mysql.php"]

Which is pretty much correct, considering:

show create table turba_objects\G
*************************** 1. row ***************************
       Table: turba_objects
Create Table: CREATE TABLE `turba_objects` (
  `object_id` varchar(32) NOT NULL DEFAULT ' ',
  `owner_id` varchar(255) NOT NULL DEFAULT ' ',
  `object_type` varchar(255) NOT NULL DEFAULT 'Object',
  `object_uid` varchar(255) DEFAULT NULL,
  `object_members` longtext,
  `object_alias` varchar(32) DEFAULT NULL,
  `object_email` varchar(255) DEFAULT NULL,
  `object_homephone` varchar(25) DEFAULT NULL,
  `object_workphone` varchar(25) DEFAULT NULL,
  `object_cellphone` varchar(25) DEFAULT NULL,
  `object_fax` varchar(25) DEFAULT NULL,
  `object_title` varchar(255) DEFAULT NULL,
  `object_company` varchar(255) DEFAULT NULL,
  `object_notes` longtext,
  `object_pgppublickey` longtext,
  `object_smimepublickey` longtext,
  `object_freebusyurl` varchar(255) DEFAULT NULL,
  `object_firstname` varchar(255) DEFAULT NULL,
  `object_lastname` varchar(255) DEFAULT NULL,
  `object_middlenames` varchar(255) DEFAULT NULL,
  `object_nameprefix` varchar(32) DEFAULT NULL,
  `object_namesuffix` varchar(32) DEFAULT NULL,
  `object_phototype` varchar(10) DEFAULT NULL,
  `object_bday` varchar(10) DEFAULT NULL,
  `object_homestreet` varchar(255) DEFAULT NULL,
  `object_homepob` varchar(10) DEFAULT NULL,
  `object_homecity` varchar(255) DEFAULT NULL,
  `object_homeprovince` varchar(255) DEFAULT NULL,
  `object_homepostalcode` varchar(10) DEFAULT NULL,
  `object_homecountry` varchar(255) DEFAULT NULL,
  `object_workstreet` varchar(255) DEFAULT NULL,
  `object_workpob` varchar(10) DEFAULT NULL,
  `object_workcity` varchar(255) DEFAULT NULL,
  `object_workprovince` varchar(255) DEFAULT NULL,
  `object_workpostalcode` varchar(10) DEFAULT NULL,
  `object_workcountry` varchar(255) DEFAULT NULL,
  `object_tz` varchar(32) DEFAULT NULL,
  `object_geo` varchar(255) DEFAULT NULL,
  `object_pager` varchar(25) DEFAULT NULL,
  `object_role` varchar(255) DEFAULT NULL,
  `object_logotype` varchar(10) DEFAULT NULL,
  `object_url` varchar(255) DEFAULT NULL,
  `object_photo` longblob,
  `object_logo` longblob,
  `object_anniversary` varchar(10) DEFAULT NULL,
  `object_department` varchar(255) DEFAULT NULL,
  `object_spouse` varchar(255) DEFAULT NULL,
  `object_homefax` varchar(25) DEFAULT NULL,
  `object_nickname` varchar(255) DEFAULT NULL,
  `object_assistantphone` varchar(25) DEFAULT NULL,
  `object_imaddress` varchar(255) DEFAULT NULL,
  `object_imaddress2` varchar(255) DEFAULT NULL,
  `object_imaddress3` varchar(255) DEFAULT NULL,
  `object_homephone2` varchar(25) DEFAULT NULL,
  `object_carphone` varchar(25) DEFAULT NULL,
  `object_workphone2` varchar(25) DEFAULT NULL,
  `object_radiophone` varchar(25) DEFAULT NULL,
  `object_companyphone` varchar(25) DEFAULT NULL,
  `object_otherstreet` varchar(255) DEFAULT NULL,
  `object_otherpob` varchar(10) DEFAULT NULL,
  `object_othercity` varchar(255) DEFAULT NULL,
  `object_otherprovince` varchar(255) DEFAULT NULL,
  `object_otherpostalcode` varchar(10) DEFAULT NULL,
  `object_othercountry` varchar(255) DEFAULT NULL,
  `object_yomifirstname` varchar(255) DEFAULT NULL,
  `object_yomilastname` varchar(255) DEFAULT NULL,
  `object_manager` varchar(255) DEFAULT NULL,
  `object_assistant` varchar(255) DEFAULT NULL,
  `object_workemail` varchar(255) DEFAULT NULL,
  `object_homeemail` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`object_id`),
  KEY `turba_owner_idx` (`owner_id`),
  KEY `turba_email_idx` (`object_email`),
  KEY `turba_firstname_idx` (`object_firstname`),
  KEY `turba_lastname_idx` (`object_lastname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

Can I just say 

alter table turba_objects add column object_category varchar(80);

?

Regards
Stephan
 


More information about the horde mailing list