[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         | lp.allard.1 at gmail.com
  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             |
------------------------------------------------------------------------------


lp.allard.1 at gmail.com (2013-07-26 20:20) wrote:

> I'm beginning to think that the way indexes are named has changed at  
> some point in the past so that when we generate the name of the  
> index to drop, it doesn't match the name it was created with in the  
> past.
>
> We probably need to catch the error and try to remove the old name  
> explicitly when this happens.

OK so I am not a MySQL Guru, can someone recommend a MySQL command to  
try to fix this?