Task #94100

SQL Mode in TYPO3

Added by Marc Hirdes 3 months ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
Documentation
Target version:
-
Start date:
2021-05-10
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
10
PHP Version:
Tags:
Complexity:
Sprint Focus:

Description

Which SQL modes in TYPO3 are necessary and why? Which should be set as system requirements?

Here I get no information for this topic https://docs.typo3.org/m/typo3/guide-installation/master/en-us/In-depth/SystemRequirements/Index.html We made bad experience with STRICT_TRANS_TABLES. Therefore we would set the SQL mode to this value:

sql_mode = "ONLY_FULL_GROUP_BY,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREAT‌​E_USER,NO_ENGINE_SUB‌​STITUTION" 

A recommondation from TYPO3 in the system requirements documentation would be great.

No data to display

Also available in: Atom PDF