Project

General

Profile

Actions

Bug #19923

closed

Table definition in cache_treelist not compliant with MySQL 5.0 strict mode

Added by Steffen Müller over 15 years ago. Updated over 13 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
-
Target version:
-
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.

#
  1. 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

bug_10282.diff (498 Bytes) bug_10282.diff Administrator Admin, 2009-01-27 11:26

Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #16809: FIX FOR Typo3 basic tables definition not compliant with MySQL 5.0 strict mode enabled by defaultClosedDmitry Dulepov2006-12-22

Actions

No data to display

Actions

Also available in: Atom PDF