[Tickets #3423] NEW: Upgrade script from 1.2 to 2.0 fails

[bugs@bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=3423
-----------------------------------------------------------------------
 Ticket             | 3423
 Created By         | keith at ajmani.org
 Summary            | Upgrade script from 1.2 to 2.0 fails
 Queue              | Turba
 Version            | 2.0.5
 State              | Unconfirmed
 Priority           | 3. High
 Type               | Bug
 Owners             | 
-----------------------------------------------------------------------


keith at ajmani.org (2006-02-07 16:27) wrote:

The upgrade script for 1.2 -> 2.0, included in
turba2/examples/scripts/upgrades/1.2_to_2.0.sql does not make all the
necessary changes to an existing database.

The script runs successfully, but upon login users are unable to browse the
contents of their existing "My Address Book".  Using the "Private Address
Book" succeeds. 

Attempting to add a new record to "My Address Book" fails, with the
following errors:

on screen: DB Error: no such field

in log: 

Feb 07 19:14:27 HORDE [error] [turba] DB Error: no such field: INSERT INTO
turba
_objects (object_name, object_email, object_alias, object_homeaddress,
object_wo
rkaddress, object_homephone, object_workphone, object_cellphone, object_fax,
obj
ect_title, object_company, object_notes, object_pgppublickey,
object_smimepublic
key, object_freebusyurl, object_type, owner_id, object_uid, object_id)
VALUES ('
Keith Ajmani3', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
'Object'
, 'keith', '20060207191427.6rvgct4txy4g at webmail.skule.net',
'56f6f8fdd7a6377b03a
824ecbf52c490') [nativecode=1054 ** Unknown column 'object_type' in 'field
list'
] [on line 185 of "/usr/share/horde3/turba/lib/Driver/sql.php"]

I checked the turba_objects DB, and sure enough that field, and also
'object_members' are missing. I compared the DB fields to the ones in the
turba create script.

I executed the following SQL and now the address book works!

alter table turba_objects add column object_type VARCHAR(255) NOT NULL
DEFAULT 'Object';
alter table turba_objects add column object_members BLOB; 

Please update the upgrade script.

Thank you,

Keith