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

* Your Email Address
* Spam protection	Enter the letters below: .___.. ,.__ __ .__ _/ \./ [__)/ `[__) ./__. \| [__)\__.[__)
Comment	>>> Is my database structure ok? >>> Can someone give me the right sql command to fix the upgrade? > > Moin! > I use this: > > /!40101 SET @saved_cs_client = @@character_set_client /; > /!40101 SET character_set_client = utf8 /; > CREATE TABLE `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` bigint(20) NOT NULL, > `history_desc` text DEFAULT NULL, > `history_who` varchar(255) DEFAULT NULL, > `history_extra` text DEFAULT NULL, > `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` (`history_modseq`), > KEY `index_horde_histories_on_object_uid` (`object_uid`), > KEY `history_modseq_idx` (`history_modseq`) > ) ENGINE=MyISAM AUTO_INCREMENT=14715533 DEFAULT CHARSET=utf8mb3 > COLLATE=utf8mb3_unicode_ci; > /!40101 SET character_set_client = @saved_cs_client /; > > :-) > Arnold >
Attachment
Watch this ticket