[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