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

* Your Email Address
* Spam protection	Enter the letters below: . ..__ .__ .___..__ \|\/\|\| \[ __ \| \| \ \| \|\|__/[_./ \| \|__/
Comment	> 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
Attachment
Watch this ticket

Saved Queries