[horde] Horde Groupware Webmail Edition 1.2 upgrade problem

Dragos Leahu dragos_leahu at yahoo.com
Sun Oct 19 15:11:24 UTC 2008


Hi,

I have Horde Groupware Webmail Edition 1.1 working on Fedora 8. When I try to upgrade to Horde Groupware Webmail Edition 1.2, it gives some errors during installation, reproduced below. 

The Thing is that eventually the upgrade gets to the end, but the new versions are not installed, according to the result of "Check for newer versions", from the Administration Setup menu, which sais there are new versions for all applications/modules.

Here is the only part of the upgrade with errors:

====================================================

Running pre-update scripts...
/root/horde-webmail-1.2/scripts/upgrades/2008-08-29_fix_mdb2_sequences.php
[   OK   ] Modified sequence for ingo_shares
[   OK   ] Modified sequence for kronolith_shares
[   OK   ] Modified sequence for mnemo_shares
[   OK   ] Modified sequence for nag_shares
[   OK   ] Modified sequence for turba_shares
[   OK   ] Done
/root/horde-webmail-1.2/turba/scripts/upgrades/2.1_to_2.2_sql_schema.php
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_firstname VARCHAR(255) [nativecode=1060 ** Duplicate column
           name 'object_firstname']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_lastname VARCHAR(255) [nativecode=1060 ** Duplicate column
           name 'object_lastname']"]
[ ERROR! ] [db_error: message="DB Error: no such field" code=-19 mode=return
           level=notice prefix="" info="UPDATE turba_objects SET
           object_lastname = object_name [nativecode=1054 ** Unknown column
           'object_name' in 'field list']"]
[ ERROR! ] [db_error: message="DB Error: not found" code=-4 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects DROP COLUMN
           object_name [nativecode=1091 ** Can't DROP 'object_name'; check that
           column/key exists]"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_middlenames VARCHAR(255) [nativecode=1060 ** Duplicate column
           name 'object_middlenames']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_nameprefix VARCHAR(255) [nativecode=1060 ** Duplicate column
           name 'object_nameprefix']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_namesuffix VARCHAR(32) [nativecode=1060 ** Duplicate column
           name 'object_namesuffix']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_phototype VARCHAR(10) [nativecode=1060 ** Duplicate column
           name 'object_phototype']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_bday VARCHAR(10) [nativecode=1060 ** Duplicate column name
           'object_bday']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_homestreet VARCHAR(255) [nativecode=1060 ** Duplicate column
           name 'object_homestreet']"]
[ ERROR! ] [db_error: message="DB Error: no such field" code=-19 mode=return
           level=notice prefix="" info="UPDATE turba_objects SET
           object_homestreet = object_homeaddress [nativecode=1054 ** Unknown
           column 'object_homeaddress' in 'field list']"]
[ ERROR! ] [db_error: message="DB Error: not found" code=-4 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects DROP COLUMN
           object_homeaddress [nativecode=1091 ** Can't DROP
           'object_homeaddress'; check that column/key exists]"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_homepob VARCHAR(10) [nativecode=1060 ** Duplicate column name
           'object_homepob']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_homecity VARCHAR(255) [nativecode=1060 ** Duplicate column
           name 'object_homecity']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_homeprovince VARCHAR(255) [nativecode=1060 ** Duplicate
           column name 'object_homeprovince']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_homepostalcode VARCHAR(255) [nativecode=1060 ** Duplicate
           column name 'object_homepostalcode']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_homecountry VARCHAR(255) [nativecode=1060 ** Duplicate column
           name 'object_homecountry']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_workstreet VARCHAR(255) [nativecode=1060 ** Duplicate column
           name 'object_workstreet']"]
[ ERROR! ] [db_error: message="DB Error: no such field" code=-19 mode=return
           level=notice prefix="" info="UPDATE turba_objects SET
           object_workstreet = object_workaddress [nativecode=1054 ** Unknown
           column 'object_workaddress' in 'field list']"]
[ ERROR! ] [db_error: message="DB Error: not found" code=-4 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects DROP COLUMN
           object_workaddress [nativecode=1091 ** Can't DROP
           'object_workaddress'; check that column/key exists]"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_workpob VARCHAR(10) [nativecode=1060 ** Duplicate column name
           'object_workpob']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_workcity VARCHAR(255) [nativecode=1060 ** Duplicate column
           name 'object_workcity']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_workprovince VARCHAR(255) [nativecode=1060 ** Duplicate
           column name 'object_workprovince']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_workpostalcode VARCHAR(255) [nativecode=1060 ** Duplicate
           column name 'object_workpostalcode']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_workcountry VARCHAR(255) [nativecode=1060 ** Duplicate column
           name 'object_workcountry']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_tz VARCHAR(32) [nativecode=1060 ** Duplicate column name
           'object_tz']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_geo VARCHAR(255) [nativecode=1060 ** Duplicate column name
           'object_geo']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_pager VARCHAR(25) [nativecode=1060 ** Duplicate column name
           'object_pager']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_role VARCHAR(255) [nativecode=1060 ** Duplicate column name
           'object_role']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_logotype VARCHAR(10) [nativecode=1060 ** Duplicate column
           name 'object_logotype']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_category VARCHAR(80) [nativecode=1060 ** Duplicate column
           name 'object_category']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_url VARCHAR(255) [nativecode=1060 ** Duplicate column name
           'object_url']"]
[ ERROR! ] [db_error: message="DB Error: already exists" code=-5 mode=return
           level=notice prefix="" info="CREATE INDEX turba_email_idx ON
           turba_objects (object_email) [nativecode=1061 ** Duplicate key name
           'turba_email_idx']"]
[ ERROR! ] [db_error: message="DB Error: already exists" code=-5 mode=return
           level=notice prefix="" info="CREATE INDEX turba_firstname_idx ON
           turba_objects (object_firstname) [nativecode=1061 ** Duplicate key
           name 'turba_firstname_idx']"]
[ ERROR! ] [db_error: message="DB Error: already exists" code=-5 mode=return
           level=notice prefix="" info="CREATE INDEX turba_lastname_idx ON
           turba_objects (object_lastname) [nativecode=1061 ** Duplicate key
           name 'turba_lastname_idx']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_photo BLOB [nativecode=1060 ** Duplicate column name
           'object_photo']"]
[ ERROR! ] [db_error: message="DB Error: unknown error" code=-1 mode=return
           level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
           object_logo BLOB [nativecode=1060 ** Duplicate column name
           'object_logo']"]
Continue? [n]
    (y) Yes
    (n) No
y
Type your choice: [   OK   ] Contact name fields parsed.
[   OK   ] Home address fields parsed.
[   OK   ] Work address fields parsed.
/root/horde-webmail-1.2/turba/scripts/upgrades/2007-06-17_flatten_shares.php

Horde Groupware Webmail Edition Configuration Menu
    (0) Exit
    (1) Configure database settings
    (2) Create database or tables
    (3) Configure administrator settings
    (4) Update from an older Horde Groupware Webmail Edition version

Type your choice:


======================================================

Any help would be appreciated.

Regards,
Dragos

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


More information about the horde mailing list