[turba] Upgrading Turba 2.3.2 -> 3.0.10 (Stable)

zBit zbit at centrum.cz
Tue Nov 29 12:07:03 UTC 2011


Hello,

We need to upgrade our Horde webmail (H3.3.5 + I4.3.5 + T2.3.2) because of several problems (e.g. regarding attachments).
So far I have deployed new stable installation (H4.0.11 + I5.0.14 + T3.0.10) using the preferred way - pear - on our development
machine, changed a little overall settings using the Horde GUI administration site. As far as Turba is concerned, I merely renamed
sources.php to backends.php. The conf.php file as well as other Turba configuration files seem to be almost the same in both old
and new installations. I have imported old data into new database and run all available migrations from within the GUI administration.
The migrations finished without any problem as I can tell. Having both Horde and IMP ready I logged into an random e-mail account
but the address book looked pretty empty. Whatever account I choose its contact list is empty. I read all available (faq/install/upgrade)
guides but did not stumble accross something interesting in my problem. Therefore I have enabled debug while clicking on the
addressbook and it generated quite different SQL queries for both old and new installation. I do not know what should be wrong with
my configuration or where else to look at. Do you have any idea?

OLD HORDE 

HORDE [debug] [turba] SQL Query by DataTree_sql::getAttributes(): SELECT datatree_id, attribute_name AS name, attribute_key AS 
"key", attribute_value AS value FROM horde_datatree_attributes WHERE datatree_id IN (*, *, *) [pid * on line 1085 of "horde/lib/Horde/DataTree/sql.php"]

HORDE [debug] [turba] SQL query by Turba_Driver_sql::_search(): 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_homestreet
, object_homepob, object_homecity, object_homeprovince, object_homepostalcode, object_homecountry, object_workstreet, object_workpob, object_wo
rkcity, object_workprovince, object_workpostalcode, object_workcountry, object_tz, object_email, object_homephone, object_workphone, object_cel
lphone, object_fax, object_pager, object_title, object_role, object_company, object_category, object_notes, object_url, object_freebusyurl, obj
ect_pgppublickey, object_smimepublickey FROM turba_objects WHERE (owner_id = ? AND (LOWER(object_email) LIKE LOWER(?))) [pid * on line 168 
of "horde/turba/lib/Driver/sql.php"]

NEW HORDE

DEBUG: HORDE [turba] SQL SELECT object_id, object_type, owner_id, object_nameprefix,
          object_firstname, object_middlenames, object_lastname,
          object_namesuffix FROM turba_objects WHERE (owner_id =
          'login at domain.xy') [pid * on line 803 of "/usr/share/php/Horde/Db/Adapter/Base.php"]
DEBUG: HORDE [turba] SQL SHOW FIELDS FROM `turba_objects` [pid * on line 803 of "/usr/share/php/Horde/Db/Adapter/Base.php"]
DEBUG: HORDE [turba] SQL SELECT object_id, object_type, owner_id, object_nameprefix,
          object_firstname, object_middlenames, object_lastname,
          object_namesuffix FROM turba_objects WHERE (object_type = 'Group' AND
          owner_id = 'some at email.org') [pid * on line 803 of "/usr/share/php/Horde/Db/Adapter/Base.php"]

Kind regards,
David


More information about the turba mailing list