Project

General

Profile

Actions
Copy link

Bug #66430

closed

Epic #68397: Make TYPO3 work with MySQL strict mode

Avoid MySQL Warning in File Meta Index process

Added by Tim Lochmüller about 9 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
File Abstraction Layer (FAL)
Target version:
-
Start date:
2015-04-15
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
7
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

Hey guys,

the current "typo3/sysext/core/Classes/Resource/Index/MetaDataRepository.php" create a index record with "file,pid,crdate,tstamp,cruser_id". But in the database definition the "l10n_diffsource" has no default value:
...
l10n_diffsource mediumblob NOT NULL,
...

So we get this MySQL Warning: Warning 1364 Field 'l10n_diffsource' doesn't have a default value

Should we add a "DEFAULT ''" to the definition or set a empty string for the field in MetaDataRepository?

Regards,
Tim

Related issues 3 (0 open — 3 closed)

Related to TYPO3 Core - Bug #69031: Use proper data sets in category collection testsClosedMorton Jonuschat2015-08-13

Actions
Related to TYPO3 Core - Bug #69000: Functional Tests: Field 'tx_irretutorial_1ncsv_hotels' doesn't have a default valueClosedMorton Jonuschat2015-08-12

Actions
Related to TYPO3 Core - Bug #85084: Language field in Alternative Page Language always defaults to 0Closed2018-05-25

Actions
Actions
Copy link

Also available in: Atom PDF