[horde] error in horde_history db upgrade

Michael J Rubinsky mrubinsk at horde.org
Fri Jun 21 14:31:06 UTC 2013


Quoting Rene Zeipelt <zeipelt at uni-wuppertal.de>:

> Hello,
> last db schema upgrade for horde history fails with following error:
>
> twebmail:/var/www/horde/imp/config# horde-db-migrate Horde_History
> [  INFO  ] Migrating DB up.
> [  INFO  ] Current Horde_History schema version: 2
> Migrating to HordeHistoryAddModSeq (3)
> == 3 HordeHistoryAddModSeq: migrating  
> =========================================
> -- createTable('horde_histories_modseq', array('autoincrementKey' => false))
>    -> 0.0004s
> SQLSTATE[42S01]: Base table or view already exists: 1050 Table  
> 'horde_histories_modseq' already exists
>
> Deleting the table horde_histories_modseq run into:
>
> twebmail:/var/www/horde/imp/config# horde-db-migrate Horde_History
> [  INFO  ] Migrating DB up.
> [  INFO  ] Current Horde_History schema version: 2
> Migrating to HordeHistoryAddModSeq (3)
> == 3 HordeHistoryAddModSeq: migrating  
> =========================================
> -- createTable('horde_histories_modseq', array('autoincrementKey' => false))
>    -> 0.0004s
> -- addColumn('horde_histories', 'history_modseq', 'integer',  
> array('default' => 0, 'null' => false))
> SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name  
> 'history_modseq'
>
> What is going wrong? Thanks for help.

Sounds to me like the migration ran previously already...

-- 
mike

The Horde Project (www.horde.org)
mrubinsk at horde.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 2200 bytes
Desc: PGP Public Key
URL: <http://lists.horde.org/archives/horde/attachments/20130621/becb462a/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 6062 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.horde.org/archives/horde/attachments/20130621/becb462a/attachment-0001.bin>


More information about the horde mailing list