[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         | Michael Rubinsky <mrubinsk at horde.org>
  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             |
------------------------------------------------------------------------------


Michael Rubinsky <mrubinsk at horde.org> (2013-07-26 13:23) wrote:

>> My guess is that because of the confusion we created surrounding the
>> upgrade of the History package you ran the migration before the final
>> correct fix was in place. The migration might have succeeded enough
>> to remove the index but no update the schema version.
>>
>> Try migrating to version 4 and then back up to 6. If that fails, you
>> can edit the migration files and comment out the $this->removeIndex()
>> line in the 6 migration.
>
> 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?

Sure, that's another (probably simpler) way to go.