[horde] upgrade fails from Horde 3.2RC1 to Horde 3.3

frdt at dethysebaert.be frdt at dethysebaert.be
Sat Nov 1 16:06:56 UTC 2008


I come back with my issue and not yet a solution at this time
Following the upgrade process in documentation upgrade of config files  
run without error and database upgrade is generating errors
I'm running onto a gentoo distribution , test.php in horde return  
nothing missing. Thanks for your help

here are the database upgrade

Changing existing data after this point. Did you create backups of your old
data, and are you sure that you want to continue?
     (y) Yes
     (n) No

Type your choice: y

Running pre-update scripts...
/home/www/horde-webmail-1.2-rc1/scripts/upgrades/2008-08-29_fix_mdb2_sequences.php
PHP Warning:  mime_magic: type regex            BEGIN[[:space:]]*[{]    
  application/x-awk invalid in Unknown on line 0
PHP Warning:  mime_magic: type search/400       \\input          
text/x-tex invalid in Unknown on line 0
PHP Warning:  mime_magic: type search/400       \\section        
text/x-tex invalid in Unknown on line 0
PHP Warning:  mime_magic: type search/400       \\setlength      
text/x-tex invalid in Unknown on line 0
PHP Warning:  mime_magic: type search/400       \\documentstyle  
text/x-tex invalid in Unknown on line 0
PHP Warning:  mime_magic: type search/400       \\chapter        
text/x-tex invalid in Unknown on line 0
PHP Warning:  mime_magic: type search/400       \\documentclass  
text/x-tex invalid in Unknown on line 0
X-Powered-By: PHP/4.4.8_pre20070816-pl1-gentoo
Content-type: text/html

[   OK   ] Done
/home/www/horde-webmail-1.2-rc1/turba/scripts/upgrades/2.1_to_2.2_sql_schema.php
PHP Warning:  mime_magic: type regex            BEGIN[[:space:]]*[{]    
  application/x-awk invalid in Unknown on line 0
PHP Warning:  mime_magic: type search/400       \\input          
text/x-tex invalid in Unknown on line 0
PHP Warning:  mime_magic: type search/400       \\section        
text/x-tex invalid in Unknown on line 0
PHP Warning:  mime_magic: type search/400       \\setlength      
text/x-tex invalid in Unknown on line 0
PHP Warning:  mime_magic: type search/400       \\documentstyle  
text/x-tex invalid in Unknown on line 0
PHP Warning:  mime_magic: type search/400       \\chapter        
text/x-tex invalid in Unknown on line 0
PHP Warning:  mime_magic: type search/400       \\documentclass  
text/x-tex invalid in Unknown on line 0
X-Powered-By: PHP/4.4.8_pre20070816-pl1-gentoo
Content-type: text/html

[ 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





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


More information about the horde mailing list