Page 1 of 1

PostPosted: Fri Oct 06, 2006 11:31 am
by Aoirthoir
If you are running LCMS with history enabled, and you click an existing record and then choose the history tab, you will get a an error that says the table has no history. If you save a record first from that table or add a record, then the history tab will give no errors. Though obviously you would not see any history for a pre-existing item.

Another solution is to simply add the following SQL to create the __history tables:

CREATE TABLE `pages__history` (
`history__id` int(11) NOT NULL auto_increment,
`history__language` varchar(2) default NULL,
`history__comments` text,
`history__user` varchar(32) default NULL,
`history__state` int(5) default '0',
`history__modified` datetime default NULL,
`id` int(11) default NULL,
`path` varchar(255) default NULL,
`title` varchar(255) default NULL,
`description` text,
`header_image` varchar(64) default NULL,
`header_image_mimetype` varchar(64) default NULL,
`content` text,
`last_modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`history__id`),
KEY `prikeys` USING HASH (`id`),
KEY `datekeys` USING BTREE (`history__modified`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

CREATE TABLE `sidebars__history` (
`history__id` int(11) NOT NULL auto_increment,
`history__language` varchar(2) default NULL,
`history__comments` text,
`history__user` varchar(32) default NULL,
`history__state` int(5) default '0',
`history__modified` datetime default NULL,
`id` int(11) default NULL,
`title` varchar(64) default NULL,
`content` text,
`link_url` varchar(255) default NULL,
`link_label` varchar(64) default NULL,
`link_description` text,
PRIMARY KEY (`history__id`),
KEY `prikeys` USING HASH (`id`),
KEY `datekeys` USING BTREE (`history__modified`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

CREATE TABLE `users__history` (
`history__id` int(11) NOT NULL auto_increment,
`history__language` varchar(2) default NULL,
`history__comments` text,
`history__user` varchar(32) default NULL,
`history__state` int(5) default '0',
`history__modified` datetime default NULL,
`id` int(11) default NULL,
`username` varchar(32) default NULL,
`password` varchar(32) default NULL,
PRIMARY KEY (`history__id`),
KEY `prikeys` USING HASH (`id`),
KEY `datekeys` USING BTREE (`history__modified`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8