[horde] errors upgrade from 3.2RC1 to 3.3

frdt at dethysebaert.be frdt at dethysebaert.be
Sat Oct 25 10:57:11 UTC 2008


Hi
I try to update my horde webmail from 3.2RC1 to 3.3 using a test  
platerforme before
upgrading in production
the test.php seams to show that all component are up to date
I follow the documentation and upgrade using a new directory in parallelle
Patch of the files of the runing horde installation go with no errors
Than upgrade of database contain many errors as follow.
When errors occures I have to choice to continue the upgrade.
Afer all this erros and when finished I can load the apllication but  
canot login into
with my account. The test.php return no abnormal missing component,  
and the version of my
installation is well 3.3
here are some errors about db upgrade

Fatal error: Call to undefined method: mdb2_error->execute() in  
/home/www/horde-
webmail-1.2/mnemo/scripts/upgrades/convert_datatree_shares_to_sql.php  
on line 16


[ 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']"]

[  INFO  ] Migrating share data for share_id: 1
[ ERROR! ] MDB2 Error: no such table
[ ERROR! ] MDB2 Error: no such table
[  INFO  ] Migrating share data for share_id: 8
[ ERROR! ] MDB2 Error: no such table
[ ERROR! ] MDB2 Error: no such table
[  INFO  ] Migrating share data for share_id: 9
[ ERROR! ] MDB2 Error: no such table
[ ERROR! ] MDB2 Error: no such table
[  INFO  ] Migrating share data for share_id: 13
[ ERROR! ] MDB2 Error: no such table
[ ERROR! ] MDB2 Error: no such table
[  INFO  ] Migrating share data for share_id: 24
[ ERROR! ] MDB2 Error: no such table
[ ERROR! ] MDB2 Error: no such table
[  INFO  ] Encountered 10 errors. No data was deleted from your database.


----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.


More information about the horde mailing list