Fatal Error pages (etc) has no history...

A place to discuss and receive support for LCMS (Little Content Management System)

Postby Aoirthoir » Fri Oct 06, 2006 11:31 am

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
Aoirthoir
 
Posts: 420
Joined: Wed Dec 31, 1969 5:00 pm

Return to LCMS Discussion

Who is online

Users browsing this forum: No registered users and 9 guests

Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved