[Tickets #13535] Database not updated properly on HGWE update

[noreply at bugs.horde.org]

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

Ticket-URL: https://bugs.horde.org/ticket/13535
------------------------------------------------------------------------------
  Ticket           | 13535
  Erstellt Von     | steffo76 at gmx.de
  Zusammenfassung  | Database not updated properly on HGWE update
  Warteschlange    | Horde Groupware Webmail Edition
  Version          | 5.2.1
  Typ              | Bug
  Status           | Unconfirmed
  Priorität        | 1. Low
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


steffo76 at gmx.de (2014-09-02 15:17) hat geschrieben:

Hi,

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