[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: https://bugs.horde.org/ticket/12498
------------------------------------------------------------------------------
  Ticket             | 12498
  Updated By         | tester 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              | Resolved
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
+New Attachment     | profile.html.html
------------------------------------------------------------------------------


tester at gmail.com (2023-12-30 21:37) wrote:

> Is my database structure ok?
> Can someone give me the right sql command to fix the upgrade?
>
> --
> -- Tabellenstruktur für Tabelle `horde_histories`
> --
>
> CREATE TABLE IF NOT EXISTS `horde_histories` (
>   `history_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
>   `object_uid` varchar(255) NOT NULL,
>   `history_action` varchar(32) NOT NULL,
>   `history_ts` int(11) NOT NULL,
>   `history_desc` longtext,
>   `history_who` varchar(255) DEFAULT NULL,
>   `history_extra` longtext,
>   `history_modseq` int(11) NOT NULL DEFAULT '0',
>   PRIMARY KEY (`history_id`),
>   KEY `history_action_idx` (`history_action`),
>   KEY `history_ts_idx` (`history_ts`),
>   KEY `history_uid_idx` (`object_uid`),
>   KEY `index_horde_histories_on_history_modseq_and_object_uid`  
> (`history_modseq`,`object_uid`)
> ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=74754 ;




tester at gmail.com (2023-12-30 21:37) uploaded: profile.html.html

https://bugs.horde.org/h/services/download/?app=whups&actionID=download_file&file=profile.html.html&ticket=12498&fn=%2Fprofile.html.html