Tickets :: Comment on [#12498] SQL Syntax error or access violation updating Horde

* Your Email Address
* Spam protection	Enter the letters below: . ,.__.. ..__ .___. \./ [__]\|\/\|\| \ _/ \| \| \|\| \|\|__/./__.
Comment	>> 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. >
Attachment
Watch this ticket