6.0.0-beta1
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
9/20/25
H
istory
A
ttachments
C
omment
W
atch
Download
Comment on [#12498] SQL Syntax error or access violation updating Horde_History DB schema
*
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? > > -- > -- 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 ;
Attachment
Watch this ticket
N
ew Ticket
M
y Tickets
S
earch
Q
uery Builder
R
eports
Saved Queries
Open Bugs
Bugs waiting for Feedback
Open Bugs in Releases
Open Enhancements
Enhancements waiting for Feedback
Bugs with Patches
Enhancements with Patches
Release Showstoppers
Stalled Tickets
New Tickets
Horde 5 Showstoppers