[turba] Upgrading from Turba 1.2 to 2.0

[Michael Rubinsky]

Quoting Brett Charbeneau <brett at wrl.org>:

  __
> NOTE: the old RH installation started with Turba 1.1 and updated to 1.2
> - this creates some goofiness, notably two missing database fields
> (object_type and object_members)

This is mentioned in docs/UPGRADING - when upgrading from 1.1 -> 1.2,  
you must either manually add these fields or run the provided upgrade  
script.

and in the owner_id field, the
> hostname has been appended to the username. More on this later...

This is a configuration setting in horde and has nothing to do with  
the change from 1.x -> 2.0.  Your new server was not set up to use the  
hostnames as your old server was...


>
> ** Unknown column 'object_uid' in 'field list'] [on line 143 of
> "/usr/share/horde3/turba/lib/Driver/sql.php"]

Either you didn't run the 1.2 -> 2.0 upgrade script, or it failed.


> 	I see 'object_uid' in sources.php for turba, but I'm confused as to
> where the error is coming from or where 'object_uid' actually lives
> since it's not in my Turba database.
> 	Below, please find the results of an EXPLAIN command on this table:
>
>
> mysql> EXPLAIN turba_objects;
> +--------------------+--------------+------+-----+---------+-------+
> | Field              | Type         | Null | Key | Default | Extra |
> +--------------------+--------------+------+-----+---------+-------+
> | object_id          | varchar(32)  |      | PRI |         |       |
> | owner_id           | varchar(255) |      | MUL |         |       |
> | object_type        | varchar(255) |      |     | Object  |       |
> | object_members     | blob         | YES  |     | NULL    |       |
> | object_name        | varchar(255) | YES  |     | NULL    |       |
> | object_alias       | varchar(32)  | YES  |     | NULL    |       |
> | object_email       | varchar(255) | YES  |     | NULL    |       |
> | object_homeaddress | varchar(255) | YES  |     | NULL    |       |
> | object_workaddress | varchar(255) | YES  |     | NULL    |       |
> | object_homephone   | varchar(25)  | YES  |     | NULL    |       |
> | object_workphone   | varchar(25)  | YES  |     | NULL    |       |
> | object_cellphone   | varchar(25)  | YES  |     | NULL    |       |
> | object_fax         | varchar(25)  | YES  |     | NULL    |       |
> | object_title       | varchar(255) | YES  |     | NULL    |       |
> | object_company     | varchar(255) | YES  |     | NULL    |       |
> | object_notes       | text         | YES  |     | NULL    |       |
> +--------------------+--------------+------+-----+---------+-------+
> 16 rows in set (0.00 sec)
>

Again, you are missing all of the fields that the 1.2 -> 2.0 upgrade  
script adds.


Thanks,
mike

--
The Horde Project (www.horde.org)
mrubinsk at horde.org