[horde] error in horde_history db upgrade

Rene Zeipelt zeipelt at uni-wuppertal.de
Fri Jun 21 15:07:23 UTC 2013


Am 21.06.2013 16:31, schrieb Michael J Rubinsky:
>
> 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...
>
>
>
So, I took a backup for this tables and start the update directly from 
the console (not from web ui) and it works! thanks. rene
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5011 bytes
Desc: S/MIME Kryptografische Unterschrift
URL: <http://lists.horde.org/archives/horde/attachments/20130621/8505639f/attachment.bin>


More information about the horde mailing list