[Tickets #12498] Re: SQL Syntax error or access violation updating Horde_History DB schema

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/12498
------------------------------------------------------------------------------
  Ticket             | 12498
  Updated By         | samuel.wolf at wolf-maschinenbau.de
  Summary            | SQL Syntax error or access violation updating
                     | Horde_History DB schema
  Queue              | Horde Framework Packages
  Version            | Git master
  Type               | Bug
  State              | Feedback
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


samuel.wolf at wolf-maschinenbau.de (2013-07-26 14:48) wrote:

> Wher can i find the migration files? With the today update of  
> Horde_History from 2.1.1 to 2.1.5 we have the very same error.
> Or can i simply create a index with this name and let the schema  
> upgrade remove it?

Same problem here:
Migrating to HordeHistoryRemoveCompositeIndex (5)
== 5 HordeHistoryRemoveCompositeIndex: migrating  
==============================
-- removeIndex('horde_histories', 'history_modseq')
QUERY FAILED: Can't DROP 'index_horde_histories_on_history_modseq';  
check that column/key exists

DROP INDEX `index_horde_histories_on_history_modseq` ON `horde_histories`