Actions
Bug #19923
closedTable definition in cache_treelist not compliant with MySQL 5.0 strict mode
Start date:
2009-01-27
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
4.3
PHP Version:
4.3
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
The table cache_treelist was introduced in revision 3947. The column treelist of type TEXT has a NOT NULL property which breaks MySQL 5 strict mode compatibility.
Removing the NOT NULL property fixes the issue.
- Table structure for table 'cache_treelist'
#
CREATE TABLE cache_treelist (
md5hash char(32) DEFAULT '' NOT NULL,
pid int(11) DEFAULT '0' NOT NULL,
treelist text NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
expires int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (md5hash)
) ENGINE=InnoDB;
(issue imported from #M10282)
Files
No data to display
Actions