Fatal Error pages (etc) has no history…

Archived from the LCMS Discussion forum.

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