Issue Bug Closed

#82092Document that TYPO3 CMS 7.6 is not compatible with MySQL strict modes

Sybille Peters 08/12/17, 12:56 updated 08/12/17, 18:08

Description

It is still necessary to use MySQL strict mode for TYPO3 7.6.21

I just tested this and ran into the already known “SQL error” when trying to create a page in a bare TYPO3 system. (“SQL error: ‘Incorrect integer value: ‘’ for column ‘storage_pid’ at row 1’”)

For TYPO3 8, MySQL strict mode is apparently supported: https://forge.typo3.org/issues/72610

The “system requirements” page does not mention strict mode (which is probably ok since the currently supported version is TYPO3 8) but the other obvious sources for TYPO3 7.6 did not either, e.g. see here:

The Install.md for TYPO3 6.2 mentions strict mode: https://github.com/TYPO3/TYPO3.CMS/blob/TYPO3_6-2/INSTALL.md

It would be even better to also check for strict mode on the environment check on FIRST_INSTALL but I will see if there is already an issue for this and if not I will create one …

Since strict mode is officially supported in TYPO3 8 and TYPO3 8 is the current LTS version, the problem is not so severe but there still may be people using TYPO3 7.6.

Reviews 0

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