Bug #19923
Table definition in cache_treelist not compliant with MySQL 5.0 strict mode
Status: | Closed | Start date: | 2009-01-27 | |
---|---|---|---|---|
Priority: | Should have | Due date: | ||
Assigned To: | Benjamin Mack | % Done: | 0% |
|
Category: | - | Spent time: | - | |
Target version: | - | |||
TYPO3 Version: | 4.3 | Is Regression: | ||
PHP Version: | 4.3 | Sprint Focus: | ||
Complexity: |
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)
Related issues