[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-27 07:41) wrote:

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

I fixed it with the following steps:
* horde-db-migrate show Horde_History schema version: 4 and the SQL error.
* comment out the up function in the following files  
(/usr/share/php/data/Horde_History/migration):
   5_horde_history_remove_compositeindex.php
   6_horde_history_fix_botchedindexes.php
* run horde-db-migrate to update to Horde_History schema version: 6
* I use phpmyadmin to delete all indexes in the horde_histories table  
except the "PRIMARY key
* at last add the indexes with the following commands
ALTER TABLE `HORDE_DB_NAME`.`horde_histories` ADD INDEX  
`index_horde_histories_on_history_action` ( `history_action` )
ALTER TABLE `HORDE_DB_NAME`.`horde_histories` ADD INDEX  
`index_horde_histories_on_history_ts` ( `history_ts` )
ALTER TABLE `HORDE_DB_NAME`.`horde_histories` ADD INDEX  
`index_horde_histories_on_history_modseq` ( `history_modseq` )
ALTER TABLE `HORDE_DB_NAME`.`horde_histories` ADD INDEX  
`index_horde_histories_on_object_uid` ( `object_uid` )

I hope this helps.