[horde] errors upgrade from 3.2RC1 to 3.3

Manilal K M libregeek at gmail.com
Sun Oct 26 05:33:37 UTC 2008


2008/10/25  <frdt at dethysebaert.be>:
>
> 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.
> --
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>

May be you have missed the MDB2 package in PEAR and did not upgraded
the database using the script provided in scripts/ folder.
Read docs/UPGRADING once more.

-- 
Manilal K M : മണിലാല്‍ കെ എം.
http://libregeek.blogspot.com


More information about the horde mailing list