[horde] Database trouble after update to 5.2.1
Michael J Rubinsky
mrubinsk at horde.org
Tue Sep 2 14:09:50 UTC 2014
Quoting steffo76 at gmx.de:
> 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);
>
> ?
I was almost positive that an issue like this was fixed recently, but
I can't find a commit for it. Please create a bug ticket on
bugs.horde.org and I'll look at it.
--
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5869 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/horde/attachments/20140902/b188cfd4/attachment.bin>
More information about the horde
mailing list