6.0.0-beta6
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
3/30/26
H
istory
A
ttachments
C
omment
W
atch
Download
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
N
ew Ticket
M
y Tickets
S
earch
Q
uery Builder
R
eports
Saved Queries
Open Bugs
Bugs waiting for Feedback
Open Bugs in Releases
Open Enhancements
Enhancements waiting for Feedback
Bugs with Patches
Enhancements with Patches
Release Showstoppers
Stalled Tickets
New Tickets
Horde 5 Showstoppers