Issue Bug Closed

#15772"NOT NULL" removed from SQL gives error with MySQL 3.23.52

Kasper Skårhøj 03/06/06, 19:54 updated 08/12/06, 14:16

Description

Lines 324ff in class.t3lib_install.php

// Remove NOT NULL statements (they are not needed)
$parts1 = str_replace(’ NOT NULL’, ‘’, $parts1);

results in an error with MySQL 3.23.52 because two new tables (sys_refindex + sys_preview) in TYPO3 4.0 uses a varchar(32) field as primary key and primary keys in that MySQL version seems to require the “NOT NULL” attribute.
This will surely be a problem when people begin to upgrade sites.

(issue imported from #M2777)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.